TSQL Sudoku

I am a big Sudoku fan.  Typically if I need a break, I will break out a Sudoku puzzle from...

Writing Your Resume

There’s a  lot of info out there about putting together a resume, and I probably can’t add a lot, but...

Announcing the upcoming Colorado GiveCamp

What is a GiveCamp?

GiveCamp is a weekend-long event where technology professionals from designers, developers and database administrators to marketers and...

Auditing SQL Logins Addendum

One thing that has come out of auditing successful logins is the number of applications called ".Net SqlClient Data Provider"....

Basic Computed Columns

I ran into an issue recently with a computed column, which I’ve rarely used, so I investigated them and wrote...

Calculate table size with existing data

Calculate the physical size of a SQL Server database table (data and indexes) , if rows exist . These steps present a...

Compiles and recompiles

I want to spend some time over the next few months looking at query compilation and the plan cache, and...

Going Big with SSDs

Nimbus Data just sold 100TB of SSDs to eBay
I found a report recently that eBay had implemented 100TB of SSD storage from Nimbus...

Splitting ID’s with commas, updating them, and then Slamming them back together

Unfortunately my company still uses
MS Access DBs. That's Access 97 folks! I've battled many challenges over the
last couple months with...

SQL MCM Training – Day 8

Today Paul talked the whole day about HA DR Strategies and Backup/Restore operations.
I've already known a lot about Backup/Restores, but...