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

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

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

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

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

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

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

Using a system function as a computed column within a table-value function….

Wouldn’t it be nice if SQL Server allowed this functionality? for instance if did the below:-

I get the above error....

Execute SSIS Packages with a Macro in BIDS

When running SSIS packages in BIDS it is common to click on the green arrow at the top of BIDS...

sp_SrvPermissions

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