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

Test Post – Please ignore

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

Last Weeks Top “Reading” Links #58

Monday morning and it’s time for weekly round-up.  If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...

SQL Saturday in Verona – Slide deck of “Put databases under source control” available for download

“Put databases under source control” slide deck is available here. The SQL Saturday – Verona event was a great success. Now we’re waiting for...

Automated Permissions Auditing With Powershell and T-SQL: Part 4

Previously, on REAL-SQL-Guy…
We were introduced to two SQL queries to obtain database login permissions, one for SQL Server 2000, one...

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

Connection options in SSMS

When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know...

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

I’m speaking at SQL Server Saturday #233 – Washington DC!

It’s that time of the year again when SQL Saturday makes its way back to the Washington DC Area. Here...

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