Recertification, too easy?

3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify...

Weekly Round-up 21st March 2016

Here are some of the more interesting links that I have found this week

SQL Server
SQL Server 2016 RC1 has...

SQL Saturday #486 Richmond – A Window Into Your Data

Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...

Calculating Some Max Mirror Stats

This turned out to be quite a challenge. I couldn’t find anything that made this very clean and straight forward...

Failover all databases to other server

Quick snippet I threw together to help with failing over synchronized databases to the other server in bulk. No way...

Leadership Lessons

Not for you, for me.
I’m sure you’ve heard the statement: Praise in public. Criticize in private.
I agree with this approach....

Previewing the new SSRS 2016 portal

Ran into an issue with the “Preview New Reporting Portal” link on a fresh install of 2016 giving me a...

Simple Methods to Recover master.mdf File Password

Overview
MS SQL Server is the relational database management system used to store information in form of tables, views, indexes, triggers,...

SQL 2012 SP3 and entity framework conflict

the problem
An issue with SQL Server 2012 SP3 was identified that impacted EF4/5 due to additional datatypes in the dll....

SQL Server Management Studio Preview

You may have heard that SQL Server Management Studio (SSMS) is now available as a stand-alone installation package outside of...