Monday Morning SQL Break – March 21, 2016

Monday, Monday, Monday… let’s start with a wrap-up of last week’s blog and twitter activity.  If you haven’t already, follow me...

Query Active Directory from SQL Server

Have you ever had the need to query Active Directory right out of SQL Server using native TSQL?  There are...

Recertification, too easy?

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

Recertification, too easy?

3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify this year to keep it active. So shortly after...

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...