[EN] Microsoft Exams Online.. A Man of Worse Origin.

imageTen days ago at Born To Learn Blog Liberty Munson annouced confirmation post about general availability of Online Proctored Microsoft Exams for MCP (Microsoft Certified Professional) and MTA (Microsoft Technology Associations) exams. After beta period availability in United States this projest looks as succesfull project. With partnership of Pearson VUE (which in fact is only one partner for any Microsoft exams, beginning from 1st january next year) Microsoft expanded opportunnity for additional twenty countries. As I could expect… not for Microsoft Professionals in Poland:

Australia, Brazil, Chile, Colombia, Egypt, Finland, Ireland, Kenya, Malaysia, Mexico, Norway, Peru, Philippines, Russia, Singapore, South Africa, Sweden, Switzerland, Thailand, United States, Uruguay

List of possible online proctored exams are huge:

70-331-OP: CoreSolutionsofMicrosoftSharePointServer2013
70-332-OP: AdvancedSolutionsofMicrosoftSharePointServer2013
70-336-OP: CoreSolutionsofMicrosoftLyncServer2013
70-337-OP: EnterpriseVoice&OnlineServiceswithMicrosoftLyncServer2013
70-341-OP: CoreSolutionsofMicrosoftExchangeServer2013
70-342-OP: AdvancedSolutionsofMicrosoftExchangeServer2013
70-346-OP: ManagingOffice365IdentitiesandRequirements
70-347-OP: EnablingOffice365Services
70-410-OP: InstallingandConfiguringWindowsServer2012
70-411-OP: AdministeringWindowsServer2012
70-412-OP: ConfiguringAdvancedWindowsServer2012Services
70-417-OP: UpgradingYourSkillstoMCSAWindowsServer2012
70-461-OP: QueryingMicrosoftSQLServer2012
70-462-OP: AdministeringMicrosoftSQLServer2012Databases
70-463-OP: ImplementingaDataWarehousewithMicrosoftSQLServer2012
70-469-OP: RecertificationforMCSE-OP: DataPlatform
70-470-OP: RecertificationforMCSE-OP: BusinessIntelligence
70-480-OP: ProgramminginHTML5withJavaScriptandCSS3
70-481-OP: EssentialsofDevelopingWindowsStoreAppsusingHTML5andJavaScript
70-482-OP: AdvancedWindowsStoreAppDevelopmentusingHTML5andJavaScript
70-483-OP: ProgramminginC#
70-486-OP: DevelopingASP.NETMVCWebApplications
70-488-OP: DevelopingMicrosoftSharePointServer2013CoreSolutions
70-489-OP: DevelopingMicrosoftSharePointServer2013AdvancedSolutions
70-490-OP: RecertificationforMCSD-OP: WindowsStoreAppsusingHTML5
70-491-OP: RecertificationforMCSD-OP: WindowsStoreAppsusingC#
70-494-OP: RecertificationforMCSD-OP: WebApplications
70-499-OP: RecertificationforMCSD-OP: ApplicationLifecycleManagement
70-517-OP: RecertificationforMCSD-OP: SharePointApplications
70-532-OP: DevelopingMicrosoftAzureSolutions
70-533-OP: ImplementingMicrosoftAzureInfrastructureSolutions
70-534-OP: ArchitectingMicrosoftAzureSolutions(beta)
70-640-OP: WindowsServer2008ActiveDirectory,Configuring
70-680-OP: TS-OP: Windows7,Configuring
70-687-OP: ConfiguringWindows8.1
70-688-OP: ManagingandMaintainingWindows8.1
70-692-OP: UpgradingYourWindowsXPSkillstoMCSAWindows8.1
70-695-OP: DeployingWindowsDevicesandEnterpriseApps
70-696-OP: ManagingEnterpriseDevicesandApps
70-980-OP: RecertificationforMCSE-OP: ServerInfrastructure
70-981-OP: RecertificationforMCSE-OP: PrivateCloud
70-982-OP: RecertificationforMCSE-OP: DesktopInfrastructure
74-409-OP: ServerVirtualizationwithWindowsServerHyper-VandSystemCenter
98-349-OP: WindowsOperatingSystemFundamentals
98-361-OP: SoftwareDevelopmentFundamentals
98-364-OP: DatabaseFundamentals
98-365-OP: WindowsServerAdministrationFundamentals
98-366-OP: NetworkingFundamentals
98-367-OP: SecurityFundamentals
98-375-OP: HTML5ApplicationDevelopmentFundamentals

More information here: Online Proctored Microsoft Exams Available in Twenty One Countries in December 2014 http://bit.ly/1H2Y7ac and here: Online proctored exams Registration and Requirements http://bit.ly/1zYO2YH


I understand why: Online proctored (OP) exams allow you to take an exam in the comfort of your home or office, often within 15 minutes of registering, while being monitored by an offsite proctor.


I completely don’t undestand why: why again Microsoft forgets about Poland; forgets, or is taking deliberate action agains Microsoft Professionals in Poland. Is not first time when I feel as:

A Man of Worse Origin.

We (in Poland) experienced many of similar stories: no availability of Microsoft Zune, no availability of X-Box Online, no availability of Sufrace 2 or 3 at TechEd and more. Why Microsoft, Why? Even some exams will be available in future, maybe, someday, in 2016 or 2020, why we are Peoples of Worse Origin?

[EN] SQL Server 2014 Cumulative Update #5 is available!

LOGO__SQLServer2014Just before holiday period (as someone called x-mass) Microsoft released new updates packages for newest SQL Server 2014. In this Cumulative Update No 5 {build no 12.0.2456.0} SQL Server Product Team resolved over fifty bugs and problems. Here is the list of bugs, which some of them are very interesting. In this update very interesting for me are funcionalities which have been added for Azure collaboration (such as ‘Edit Top 200 Rows’ and ‘Select Top 1000 Rows’) and support for ReST file system for local disk.

VSTS BUG: 2515444 | KB: 2970136
FIX: Cannot remove backup file after you restore the database from Windows Azure Blob storage service in SQL Server 2014
SQL service

VSTS BUG: 3720664 | KB: 2981424
FIX: Exception when you select more than one hierarchy from parent/child dimension in SSAS 2012 or in SSAS 2014
Analysis Services

VSTS BUG: 3260592 | KB: 2986423
FIX: It takes a long time to add new columns to a table when the row size exceeds the maximum allowed size
SQL service

VSTS BUG: 3260606 | KB: 2992069
FIX: XMLA and Windows PowerShell return different code for the same SSAS 2012 or SSAS 2014 processing
Analysis Services

VSTS BUG: 3720670 | KB: 2995622
FIX: "Specified cast is not valid" when you load an XML document that has time zone information in SSIS 2012 or SSIS 2014
Integration Services

VSTS BUG: 3720671 | KB: 2996729
FIX: "Non-yielding Scheduler" condition occurs when you run a complex query in SQL Server 2012 or SQL Server 2014
SQL performance

VSTS BUG: 3720672 | KB: 2997392
FIX: INSERT performance decreases in merge replication that uses precomputed partitions in SQL Server 2012 or 2014
SQL service

VSTS BUG: 3720635 | KB: 2998870
FIX: "The record ID is incorrect" error when you use DAX to execute query in a dimension in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 3720680 | KB: 3002071
FIX: "System objects not be updated" when you use AlwaysOn Availability Groups in SQL Server 2012 or SQL Server 2014
High Availability

VSTS BUG: 3720682 | KB: 3002883
FIX: Error occurs when you open FILESTREAM data that is hosted on dynamic disks in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 3720683 | KB: 3004355
FIX: SQL Server crashes when you retrieve an SQL statement hash for logging XEvent in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 3427718 | KB: 3004548
FIX: Add Azure Replica wizard cannot enumerate Azure Virtual Network in SQL Server 2014
High Availability

VSTS BUG: 3720647 | KB: 3005300
FIX: High CPU consumption when you use spatial data type and associated methods in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 3720685 | KB: 3006648
FIX: Data corruption in a target table when you use a SQL Server destination in SSIS 2012 or SSIS 2014
SQL service

VSTS BUG: 3560727 | KB: 3007050
FIX: RTDATA_LIST waits when you run natively stored procedures that encounter expected failures in SQL Server 2014
In-Memory OLTP

VSTS BUG: 3720649 | KB: 3008000
FIX: Error when you use Office 15.0 Access Database Engine OLE DB Provider as data source in SSMS 2012 or SSMS 2014
Integration Services

VSTS BUG: 3720695 | KB: 3009576
FIX: Cannot restore database by using the full backup and differential backup files that contain defunct files
SQL service

VSTS BUG: 3720696 | KB: 3009883
FIX: Error when you execute statistics update on a table that has sql_variant data type in SQL Server 2012 or 2014
SQL performance

VSTS BUG: 3720681 | KB: 3011807
FIX: Large chain of blocking occurs when you use merge replication in SQL Server 2012 or in SQL Server 2014
SQL service

VSTS BUG: 3343225 | KB: 3012182
FIX: Log_Send_Rate column cannot reflect the rate accurately in SQL Server 2012 or in SQL Server 2014
SQL service

VSTS BUG: 3720668 | KB: 3013553
FIX: Insufficient memory error when you run an XML Validation Control Flow task on a large input file in SSIS 2012 or SSIS 2014
SQL service

VSTS BUG: 3556632 | KB: 3013861
FIX: Upgrade wizard appears again when you reopen the SSIS 2014 solution with upgraded SSIS packages
Integration Services

VSTS BUG: 3548910 | KB: 3014156
FIX: An update is available that enables "Edit Top 200 Rows" option for tables and views of SQL Azure database
SQL service

VSTS BUG: 3548883 | KB: 3014164
FIX: Cannot use new service tiers Basic, Standard and Premium when you deploy to Windows Azure SQL Database in SSMS 2014
SQL service

VSTS BUG: 3548922 | KB: 3014166
FIX: An update is available that enables "Select Top 1000 Rows" option for tables and views of SQL Azure database
SQL service

VSTS BUG: 3557908 | KB: 3014193
FIX: The view indexes are not visible in the Object Explorer in SSMS 2014
Management Tools

VSTS BUG: 3565098 | KB: 3014359
FIX: Out-of-range error occurs when you use SQL Server Managed Backup to Windows Azure
SQL service

VSTS BUG: 3424685 | KB: 3014825
FIX: "No exceptions should be raised by this code" error when you run parallel query in SQL Server 2014
SQL performance

VSTS BUG: 3709035 | KB: 3014867
FIX: "Remote hardening failure" exception cannot be caught and a potential data loss when you use SQL Server 2014
High Availability

VSTS BUG: 3446846 | KB: 3016334
FIX: Error when you upgrade a SQL Server 2012 SP2 instance with MDS to SQL Server 2014

VSTS BUG: 3428568 | KB: 3016518
FIX: "You do not have permission…" error when you run a report that connects to a .BISM file in PowerPivot gallery
Analysis Services

VSTS BUG: 3306406 | KB: 3017266
FIX: "Requested value ReFS was not found" error when you install SQL Server 2014 on a local drive that is ReFS formatted
Setup & Install

VSTS BUG: 3527886 | KB: 3020112
FIX: Non-yielding error occurs when you execute DML statements in SQL Server 2014
SQL service

VSTS BUG: 3551049 | KB: 3020113
FIX: Error 35377 occurs when you try to access clustered columnstore indexes in SQL Server 2014
SQL service

VSTS BUG: 3654616 | KB: 3020116
FIX: "Non-yielding scheduler" error and AlwaysOn Availability Group transitions to RESOLVING state not Failover
High Availability

VSTS BUG: 3548637
Federations feature will be discontinued with Web and Business service tiers. The Federations related Transact-SQL code examples in SSMS are updated with comments on being discontinued.
SQL service

VSTS BUG: 3548892
The Property Page shortcut menu item for databases (right-click on a database node and select Properties) on Azure databases is enabled.
SQL service

VSTS BUG: 3548904
Table Designer is now be used when creating tables on the latest version of Azure SQL Database.
SQL service

VSTS BUG: 3548910
The Edit Top N rows shortcut menu option is enabled (right-click on Table and selectEdit Top N Rows) for opening the Visual Database Tools with N rows populated.
SQL service

VSTS BUG: 3548922
The Select Top N rows shortcut menu option (right-click a table or a view and selectSelect Top N Rows) is enabled for generating a script that will select the top N rows from a table or a view.
SQL service

VSTS BUG: 3548929
The Property shortcut menu option for tables (right-click Table node and selectProperties) on Azure databases is enabled.
SQL service

VSTS BUG: 3708148
The following nodes to Object Explorer for features are added in the latest version of Azure SQL Database:

  • Storage (under Database node)
  • Assemblies (Database node -> Programmability)
  • Rules (Database node -> Programmability)
  • Defaults (Database node -> Programmability)
  • Plan Guides (Database node -> Programmability)
  • Sequences (Database node -> Programmability)
  • Aggregate Functions (Database node -> Functions)
  • Application Roles (Database node -> Security -> Roles)
  • User-defined Object Types (CLR Types) (Database node -> Programmability -> Types)
  • XML Schema Collections (Database node -> Programmability -> Types)

SQL service

VSTS BUG: 3708389
The Column and Index subfolders under the Table and View nodes are added.
SQL service

VSTS BUG: 3708718
The Modify and Execute Stored Procedure shortcut menu options (right-click a stored procedure) when it is connected to the latest version of Azure SQL Database are enabled.
SQL service

VSTS BUG: 3708719
The Modify shortcut menu option for Functions (right-click a function) when connected to the latest version of Azure SQL Database is enabled.
SQL service

VSTS BUG: 3750221
Both the Federation and Management nodes from Object Explorer when connected to the latest version of Azure SQL Database are removed. When they are connected to an Azure v. Current server only the management node is removed (Federations are still valid on Azure v.Current).
SQL service

VSTS BUG: 3782631
The Memory Optimization Advisor shortcut menu option for tables on all Azure databases is removed.
SQL service


This update could be applied to applies to

  • Microsoft SQL Server 2014 Enterprise
  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Standard
  • Microsoft SQL Server 2014 Express
  • Microsoft SQL Server 2014 Web
  • SQL Server 2014 Reporting Services
  • Microsoft SQL Server 2014 Business Intelligence

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 5

You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP:

  1. Install the service pack on the passive node.
  2. Install the service pack on the active node (This step requests servicerestart).

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

  • SQLServer2014_RTM_CU5_3011055_12_0_2456_x64 (623 MB)
  • SQLServer2014_RTM_CU5_3011055_12_0_2456_x86 (376 MB)


[EN] Want to learn about SQL Server? Focus on SQL Server 2014, but remember about 2012.

LOGO__TakeTheCertificationChallengeAs leader of Polish SQL Server User Group in Wroclaw (former leader from September) and frequently speaker at many user gorups meetings and conferences (most often outside VaterLand) I have been asked many times: ‘I want to learn more about SQL Server’ and/or ‘which certification is good for me’. In this post I will try to answer for the second question in the context of SQL Server.  Should we learn old technology? What is old technology? Many times I asking on my session: ‘Which version of SQL Server are still in your production systems?’ Many of attendees answering: 2008, 2008 R2, 2012 some of them 2014, but stll many 2005 even most often 6.5 instead of 2000. So which version is old? It depends on environment, company policies, customers, and in 85% of other application which has been written for example in COBOL and still work in production, still with SQL Server 2000 or older.

After some discussions we agree that newest version of SQL Server are more interesting than older. That’s normal situation. But how about certification? If someone want to be certified professional in SQL Server area, which version should he/she leard? The answer is very simple. newest. That means SQL Server 2014. And my advice based not only on my personal experience, but on Microsoft Learning Certification Part Roadmap. On December 31st this year all Microsoft Official Courses (MOC) for SQL Server 2012 will be retired:

  • 10774A | Querying Microsoft SQL Server 2012
  • 10775A | Administering Microsoft SQL Server 2012 Databases
  • 10777A | Implementing a Data Warehouse with Microsoft SQL Server 2012
  • 10776A | Developing Microsoft SQL Server 2012 Databases
  • 20465B | Designing Database Solutions for SQL Server 2012
  • 10778A | Implementing Data Models and Reports with Microsoft SQL Server 2012
  • 20467B | Designing Business Intelligence Solutions with Microsoft SQL Server 2012

What is implication for this? You will not be able to order those courses from Authorized Learning Centers. But You can still pass those exams at exams center (more about changes in exams area will be on my next post). Only retired SQL Server exams in near future are for SQL Server 2008 (retirement date 31st July 2015):

  • 70-450: PRO: Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008
  • 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
  • 70-459: Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform
  • 70-460: Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence

If you can’t leard about SQL Server 2012 from MOC, some books in Self-Training Kit are still available at Amazon. But if you want to be “on date” you can focus on SQL Server 2014 Microsoft Official Courses which replacing old trainings:


What more you chould know about those exams? Let’s look for more details based on Partner Newsletter from the 31 July 2014. 

Basic Principles

Let’s start with some of the basic principles we applied when planning the curriculum. When we sat down to think about the key concepts and skills that data professionals require, we came to the following realizations:

  • The scope of “data” as an area of expertise is huge – it spans everything from single-database systems that support specific applications, to enterprise-scale multi-location data centers. It also encompasses a wide range of workloads, including traditional online transaction processing (OTLP) systems, enterprise data warehouses to support online analytical processing (OLAP) solutions, managed reporting, self-service BI, and Big Data processing.
  • Data specialists need to work with more than just SQL Server. While SQL Server is at the very core of the Microsoft data platform, data professionals need expertise in other technologies such as Windows Server, System Center, SharePoint Server, Microsoft Office, and Microsoft Azure; to name just a few.
  • General trends in IT affect how data technologies are used. The IT landscape is changing, moving towards a more cloud-based, user-oriented vision of IT services that support core business activities. These trends have a significant effect on the way that data professionals need to use the tools and technologies in the Microsoft data platform.

These realizations became the drivers for the curriculum design. We wanted to ensure that we created a solid learning experience that would not only provide students with the skills they need to use SQL Server components and features; but which also contextualize those skills within a wider “story” that reflects the realities of building and managing data solutions in today’s modern business environments. To accomplish this, we used the following principles to guide our planning:

  • The curriculum should provide a logical progression that enables new students to learn fundamental skills before moving onto more advanced concepts and technologies.
  • The learning experiences should have SQL Server at their core, but should include other data-related technologies to properly contextualize the skills being taught.
  • The courses cover key objectives that are measured in the SQL Server certification exams, but each course should primarily focus on providing the information students need to build and manage effective data solutions.

When reviewing the SQL Server 2012 curriculum, we found a lot of existing content that supports these principles. However, we also found a large degree of duplication across courses such as design topics that also covered implementation details, and topics that appear in multiple courses. We made it a key goal to eliminate topic duplication as much as possible; so that each distinct technology feature or tool is covered only once in the curriculum, in the place where it fits best. This made for better instructional flow, and made room to accommodate new content in the curriculum.

How about the courses are:

For students who are new to the Microsoft data platform, or who want to learn how to perform specific data-related roles for specific workloads and enterprise scenarios, the new curriculum includes the following courses:

  • 20461C: Querying Microsoft SQL Server. This course introduces the Transact-SQL language used in SQL Server, and the fundamental data manipulation language (DML) statements and techniques you can use to retrieve, update, insert, and delete data. Transact-SQL is a foundational skill for anyone planning to work with SQL Server – hence this course’s position at the start of the curriculum.
  • 20462C: Administering Microsoft SQL Server Databases. This course provides students with the knowledge and skills required by a database administrator (DBA) for a single-server database environment, such as might be found in a small organization or department. Core database management skills such as installing and configuring SQL Server, managing security, performing backup and restore operations, and automating administrative tasks are explored in detail in this course.
  • 20463C: Implementing a Data Warehouse with Microsoft SQL Server. Data warehousing has become a common workload in many organizations, and this course describes how to design and implement a data warehousing solution. The solution explored in the course comprises a relational database with a de-normalized schema containing fact and dimension tables, as well as a comprehensive extract, transform, and load (ETL) solution based on SQL Server Integration Services. The course also describes how to manage data consistency and quality using Master Data Services and Data Quality Services.
  • 20464C: Developing Microsoft SQL Server Databases. Developing a database is an advanced skill that requires knowledge of how SQL Server stores and retrieves data, data modeling, the creation of database objects such as tables, views, and indexes, and the programming constructs that you can use to implement functions and stored procedures. This course covers all of these topics and provides hands-on learning experiences in which students implement commonly used database objects and solutions.
  • 20465C: Designing a Data Solution with Microsoft SQL Server. This course builds on the fundamental skills in managing and creating SQL Server databases to explore enterprise data solutions that span multiple servers and geographically distributed data centers. The course begins by discussing the challenges that exist in large organizations, and describes how to use tools such as the Microsoft Assessment and Planning (MAP) Toolkit to discover database servers and services in a large IT estate. The course then discusses tools and techniques that you can use to configure and monitor multiple servers consistently, before exploring options for database workload consolidation. Cloud technologies for data, including private cloud solutions built on Windows Hyper-V and public cloud solutions built on Microsoft Azure are then examined, before the course’s focus turns to ensuring high-availability of business-critical databases and replication.
  • 20466C: Implementing Data Models and Reports with Microsoft SQL Server. This course builds on the data warehousing skills learned in course 20463C to teach students how to design and implement enterprise BI solutions that include managed reporting with SQL Server Reporting Services and OLAP data models in SQL Server Analysis Services. The course also describes how to implement BI dashboards in Microsoft SharePoint Server, and how to use the data mining capabilities of SQL Server Analysis Services and Microsoft Excel to build solutions for predictive analysis.
  • 20467C: Implementing Self Service BI and Big Data Solutions. This course explores ways in which enterprises can extend the managed BI solutions described in course 20466C to empower users to perform their own reporting and analytical data modeling. In this course, students learn how to build self-service BI solutions that use Microsoft Excel and Power BI for Microsoft Office 365, before exploring how to incorporate Big Data into a self-service BI solution by using Windows Azure HDInsight.

And last but not least is certification path, which is very well explained with this picture:


But… As we see these are three levels of certification: Microsoft technology Associate (MTA), Microsoft Certified Solutions Associate (MCSA) for SQL Server 2012 and SQL Server 2008, Microsoft Certified Solutions Expert (MCSE) for Data Platform and Business Intelligence. The TOP of this certification (formerly knonw as Microsoft Certified Master) is not available anymore since last day of December last year. If we look a more detailed for this certification we will discover:

for Microsoft MCSA Certification: you must pass three exams (461,462,463) for achieving this certificate


for Microsoft MCSE: Data Platform Certification: you must have MCSA and pass two other exams (464,465) for achieving this certificate


for Microsoft MCSE: Business Intelligence Certification: you must have MCSA and pass two other exams (466,467) for achieving this certificate


MCSA is ‘non-expired’ certification, but both MCSE required re-certification for each three years after achieving first MCSE. But all of those exams in cert path are for SQL Server 2012. So? Based on official information from Microsoft Learning: No MCSA: SQL Server 2014 credential will be released. No MCSA certification, but why I’m writing about SQL Server 2012 in the context of 2014? Because, when you will register for exams 464/465/466/467 even they are focused on SQL Server 2012: Starting April 24, 2014, the questions on this exam include content covering SQL Server 2014! More details about those exams are here:

Oficially there is no coverage for SQL Server 2014 in exams 461,462,463. But… you should be prepared for this.

One more point.

In most cases, the labs are performed on MIA-SQL, which includes multiple instances of SQL Server 2014, SharePoint Server, and Microsoft Office applications. Some High-Availability labs are performed on the MIA-CLUSTER nodes, which enable students to gain hands-on experience with AlwaysOn Failover Clustering and AlwaysOn Availability Groups in the classroom.

Many of the labs in courses 10977B, 20465C, and 20467C make use of cloud services from Microsoft Azure and Microsoft Office 365. To support these labs, the MSL-TMG1 virtual machine provides a gateway for Internet access from the classroom virtual machines. Before attending these courses, students should provision trial subscriptions for Windows Azure and Power BI for Microsoft Office 365 (though there are instructions to do so in the introduction modules of these courses for students who have not done so ahead of time).

In short summary: going to be expert in SQL Server 2012 (or SQL Server 2014) you should be prepared for SQL Server 2014 knowledge (or SQL Server 2012) and Cloud Services, SharePoint, Office Applications and Microsoft Azure. Not only SQL.

More useful information here: