Free Introducing Microsoft SQL Server 2012 eBook Now Available

2012The final version of Introducing Microsoft SQL Server 2012 by Ross Mistry (@RossMistry) and Stacia Misner (@StaciaMisner), is now available. 

Although this book expects readers to have an understanding of SQL Server from a database administrator and business-intelligence perspective, anyone who has an interest in SQL Server will find its content valuable as it provides insight into new and improved capabilities of 2012 as they apply to achieving mission-critical confidence, breakthrough insight, and using a cloud on your terms.

The  PDF version of this book can be download from here (288 pages; 10.8 MB) and a hardcopy is also available for purchase from here (US$14.99).


1.   SQL Server 2012 Editions and Engine Enhancements

2.   High-Availability and Disaster-Recovery Enhancements

3.   Performance and Scalability

4.   Security Enhancements

5.   Programmability and Beyond-Relational Enhancements


6.   Integration Services

7.   Data Quality Services

8.   Master Data Services

9.   Analysis Services and PowerPivot

10.   Reporting Services

SQL Server 2012 Beta Exams Are Now Available

Just checked Prometric and all the SQL Server 2012 Beta exams are available for booking. Perfect timing as I’m attending SQL Connections in Las Vegas at the end of March and have also signed up for the 2 day pre-conference workshop on SQL Server 2012 Update for Developers. Woot!

Microsoft Virtual Academy – New SQL Server 2012 Content Released

Microsoft has released 5 new SQL Server 2012 Microsoft Virtual Academy courses.

Breakthrough Insights using Microsoft SQL Server 2012 – Analysis Services

The 7 modules of this course will introduce you to concepts and practices such as:

  • Developing and Managing a Business Intelligent Semantic Model
  • Enriching your BI Semantic Models with Data Analysis Expressions (DAX)
  • Leveraging Master Data Services (MDS) in your Data Warehouse

Breakthrough Insights using Microsoft SQL Server 2012 – Scalable Data Warehouse

The 7 modules of this course will teach you:

  • What’s new in Microsoft StreamInsight
  • Symmetric Multiprocessing to Parallel Data Warehouse
  • Using columnstore technology to revolutionize your query performance
  • SQL Server Integration Services
  • SQL Server Fast Track for data warehouse for dramatic speed improvements
  • Going beyond relational data management into the realm of unstructured and spatial data management

Breakthrough Insights using Microsoft SQL Server 2012 – Reporting Services

The 9 modules of this course will teach you:  

  • What’s new Microsoft SQL Server 2012 Reporting Services
  • Introduce you to Self-Service Alerting
  • What’s new in Microsoft SQL Server 2012 Analysis Services and PowerPivot
  • How to use Power View for insightful visual reports
  • How to build great Business Intelligence Semantic Models for Power View
  • Deploying and managing PowerPivot in Microsoft SQL Server 2012 for SharePoint
  • A Deeper understanding of PowerPivot in Microsoft SQL Server 2012
  • How to install and configure Reporting Services in SharePoint Integration mode
  • An overview of Reporting Services in Microsoft SQL Azure

Cloud on your terms with Microsoft SQL server 2012: Scale on Demand

The 3 modules of this course will teach you: 

  • Virtualization in the Private Cloud (two parts)
  • Beyond the Hype – Hybrid Solutions for On-Premise and In-Cloud Database Applications

Mission Critical Confidence using Microsoft SQL Server 2012

The 9 modules of this course will teach you:

  • Microsoft SQL Server 2012 Security enhancements
  • Microsoft SQL Server 2012 High Availability and Disaster Recovery Design Patterns, Architectures and Best Practices using AlwaysOn
  • T-SQL Cookbook – Microsoft SQL Server 2012 Enhancements
  • Mission Critical application testing with Distributed Replay 
  • AlwaysOn Failover Cluster Instances and other High Availability enhancements
  • Improve Application Availability Using AlwaysOn – A Deep Dive Into Availability Groups
  • AlwaysOn – Active Secondary Part 1 – Readable Secondary
  • AlwaysOn – Active Secondary Part 2 – Enabling Backup On Secondary Replicas
  • Using The Power Of Extended Events For Tracing And Troubleshooting 



Certification: Yes….No….Maybe!

I read an interesting article by Paul Randal the other day on whether certification was worth it (How valuable are certifications) and it got me thinking about whether Microsoft was serious about certification or does the program exist purely to “keep people happy” (and to drive sales of MOC).

Over the years Microsoft has been criticised for taking far too long to release certifications relevant to current technologies and for not doing enough to stamp out cheating (which devalues certification).  Microsoft has also come under fire for releasing certifications but not releasing relevant study material (Self-paced Training Kits, e-Learning and classroom training etc.).  Unfortunately these “issues” have further contributed to the belief that certification is a waste of time.  Well, it appears times are changing.

Relevant and Up-to-Date Certifications

Microsoft Learning has listened to suggestions from certification candidates and is addressing the need for relevant and up-to-date certifications by ensuring it offers both training and certifications to enable IT Pros and Developers to develop and validate their skill.  One example of this effort is the recently announced Private Cloud Certification (Beta in April 2012) and the upcoming Private Cloud Jump Start course.  Another example is the recently announced SQL Server 2012 certifications (Beta in March 2012) and the SQL Server 2012 Developer Training Kit BOM.  For me though, the most exciting aspect of Microsoft’s change in direction is recertification.

Recertification is Microsoft’s way of ensuring that certifications remain meaningful and valuable, and that a person continues to demonstrate competence in a given technology even as the technology changes through service packs, revisions, and new product version releases.

Recertification is currently required for MCPD: Windows Azure Developer and MCPD: Windows Phone Developer certifications (every two years) and for Professional-level SQL Server 2012 certifications (every three years).  Hopefully Microsoft will make recertification a requirement for all technologies.  

Exam Security

This is a difficult area to address and unfortunately cheating will exist as long as certification exists.  That said, Microsoft has implemented a number of strategies to combat cheating and has even gone as far as publishing real-life stories of piracy and cheating.  Exam security is not limited to cracking down on brain-dumps, theft or impersonation though.  Take the MCM program for example.

A few years ago Microsoft released the MCM program which in my opinion addresses some of the criticism it received for not stamping out cheating (and the devaluation of certifications) as these certifications can’t be gained through study alone (thus ruling out the use of brain-bumps) as they contain a practical (lab) component. Significant security measures have also been implemented to ensure the integrity of the MCM is maintained and that people sitting exams are who they say they are.

As with recertification, I hope Microsoft extends lab based exams to all certifications and also implements the same MCM security related measures for all exams and certification candidates.

Need to report suspected cheating or piracy?  Visit the Microsoft Certification Exam Policies site or send an email to


I’ve always been passionate about certification and at times have been frustrated with the “perception” that certification is a waste of time because they become out-dated and that anyone can pass a certification exam by downloading a dump. 

Microsoft appears to be listening to suggestions and heading in the right direction with some of the initiatives they’ve implemented and I hope they continue to refine and release additional initiatives/incentives to ensure certifications retain their relevancy.

Have questions about Training and Certification?  Pop by the Training and Certification and Born to Learn forums where dedicated members will gladly point you in the right direction.,

%d bloggers like this: