Tag Archives: server

New CBT Nuggets Course: Implementing a Data Warehouse using SQL (70-767)

70-767

CBT Nuggets trainer Knox Hutchinson recently released three courses that show learners how to implement a data warehouse using Microsoft SQL Server.

Each module maps directly to a section covered in Microsoft’s Implementing a Data Warehouse using SQL exam (70-767):

Topics this training covers include:

  • Designing and implementing dimension tables and fact tables
  • Data warehouse storage
  • Implementing an ETL control flow by using an SSIS package
  • Deploying SSIS packages and projects
  • Using DQA to maintain data quality
  • Implementing an MDS model

What this training includes:

  • 3 courses
  • 52 videos
  • In-video quizzes
  • Supplemental files

What was on Fire at Microsoft Ignite 2017?

Ignite

This conference was certainly short on big product announcements, but it was long on visions for the future involving super exciting emerging technologies. Below is a list of hot topics from Microsoft at the event!

  • The keynote set the tone by emphasizing mixed reality, artificial intelligence (AI), and quantum computing; all of these are impacting key Microsoft products including Microsoft 365, Dynamics 365, and Azure
    • Microsoft 365 refers to Office 365, Windows 10, and Enterprise Mobility + Security plus other Microsoft apps
    • Dynamics 365 refers to Microsoft’s cloud-based ERP and CRM enterprise system
    • Azure is Microsoft’s public cloud offering
  • Microsoft is pushing a new programming language aimed at quantum computing
  • Microsoft 365 F1
  • Microsoft 365 Education
  • Microsoft 365 Powered Devices
  • Teams (replacing Skype for Business)
  • Bing with AI
  • LinkedIn Profile Cards in more and more MS apps
  • Windows AutoPilot – a collection of technologies used to set up and pre-configure new devices, getting them ready for productive use; also, you can use Windows AutoPilot to reset, repurpose and recover devices
  • ATP – Windows Defender Advanced Threat Protection
  • Azure
    • Stack Shipping
    • Hybrid Benefit
    • Cost Management
    • Security Center
    • Machine Learning
    • Cosmos DB
    • Cognitive Services
  • SQL Server
    • Linux and Docker support
    • DB Migration Service (to Azure)
    • SQL Data Warehouse

Microsoft

70-742 Additional Notes – AD FS, WAP, and Preauthentication

When you are configuring AD FS and WAP you have two preauthentication methods and various types of preauthentication available. Here is a recap of when you would use the various methods and types:

  • AD FS preauthentication method
    • Type – Web and MSOFBA
      • WebApplication
      • Rich Office Client
      • SharePoint
      • Office Server
      • Custom WebApp
    • Type – HTTP Basic
      • Rich Client without HTTP Redirection
      • Exchange ActiveSync
      • Remote Desktop Gateway
    • Type – OAuth2
      • Application using OAuth2
      • Windows Store Apps
      • Custom Application
  • Pass-Through preauthentication method 
    • No authentication
    • Forward authentication
    • Anonymous website
    • Legacy application
    • Public website