Stress Testing Stored Procedures with Free Tools

I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help...

Understanding the CDC State Value

If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...

Columbia Enterprise Developers Guild meeting tonight

If you're in or around the Midlands of South Carolina area, the Columbia Enterprise Developers Guild meets the 2nd Wednesday...

Decryption and CASTing

In my last encryption post I showed how to encrypt and decrypt data with a symmetric key. However there was...

Different ways to move Sql Server file location

Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons,...

Many speaking engagements!

I have several speaking events coming up, and I would love to see you there!

First of all, I'll be...

Microsoft PivotViewer

Microsoft PivotViewer is a really cool Silverlight web-based control that provides a visual way to interact with massive amounts of data (download)....

Quick tip: configure SQL Server authentication mode using T-SQL

SQL Server stores its authentication mode in the registry. The registry can be read and updated using the T-SQL commands...

SQL Hide ‘n Seek

When was the last time you had to find something within your database?  Did it feel more like a child’s game or an arduous task? What would you say...

SQL Hide ‘n Seek

When was the last time you had to find something within your database?  Did it feel more like a child’s...