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

sp_SrvPermissions

Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it...

SQLCMD – Database Backup and Restore – Automation – Quickest and Simplest method

In today’s world we rely more on third party tools to do a Backup and Restore of databases. Most of...