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

SQL Server Diagnostic Information Queries for August 2013

I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...

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

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

Windows Failover Cluster Monitor

Windows Failover Clusters are fantastic, they provide High Availability for mission critical SQL Server instances and make my life as...