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

February 7, 2019 at 1:49 pm

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?

October 2, 2017 at 3:17 pm

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

September 18, 2017 at 11:07 am

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