SQL Server – Custom sorting in ORDER BY clause

ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...

SQL Service Account Recursive Group Membership

It was recently brought to my attention that a post with the script I talk about below could not be...

SSIS Execute SQL error – No disconnected record set is available

If you get the error in SSIS that says:

…failed with the following error: “No disconnected record set is available for...

Test Post – Please ignore

I’m just testng out my new laptop making sure things are working as they should

The Next Phase of My Career

For anyone who hasn't seen an update somewhere else in the social media universe, I recently started a new job...

70-457 Reviewer #16 Implement AlwaysOn in SQL Server 2012

This reviewer is still part of lesson in Implementing High Availability in SQL Server 2012. This covers about 12% of...

Chicago SQL Server Users Group Wrapup

Thursday night I had a great time presenting my session entitled “Squeezing Top Performance from Your Virtualized SQL Server” to...

Superpowers Revealed

Like many of you out there, I’m constantly looking for new things to learn. A new skill, a new hobby,...

A Tour of the Transaction Log: Part 3 Reading Log Backups

In part one and two of our Tour of the Transaction Log articles we focused on reading events from the...

Checking your users and groups in Command Window.

As a DBA, I work closely with the Infra guys to manage domain accounts. Now and then, there comes a...