SQL Server – Get SQL Server Service Account using T-SQL

SQL Server service account information is stored in Windows Registry database. You can get this information from Services Console or...

SQL Server – Why is the ‘sa’ Login Account Disabled & How to Enable ‘sa’ Login Account

Ever noticed and wondered why the well-known SQL Server system administrator (sa) login is in a disabled state? The reason...

Trigger Status

Have you ever spent hours looking at an issue only to have your investigation hindered by a trigger?  I know...

Azure Changes, While I’m Working

My laptop is out for repair. I’m working currently on a Surface Pro instead. It’s spurred me to do something...

Backup your Windows Azure SQL Databases – Yes,you should !

Care about RPO’s and RTO’s?  Then you should be backing up your Windows AzureSQL Databases(Formerly SQLAzure).

Windows Azure SQL Database is...

CDC changes column-by-column instead of row-by-row, can you improve it???

CDC changes column-by-column instead of row-by-row, can you improve it???.

CDC changes column-by-column instead of row-by-row, can you improve it???

I’m writing a table value function that returns a cdc recordset that, instead of returning changed data row-by-row, I need...

Last Weeks Top “Reading” Links #45

It’s Monday, it’s time for weekly round-up #45.  Technically, this should be #46, but since I went on vacation, I...

Need Recommendations on Being a Better Listener

This past weekend I’ve been reading The Zen of Listening by Rebecca Shafir, part of my ongoing efforts to be...

Restoring a TDE Database on a New Instance

You’ve enabled Transparent Data Encryption (TDE) on one of your databases, and the server has failed. How do you get...