November Question: What steps do you include in your database maintenance?

Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...

Rescheduled: SQL Lunch #42 - Auditing Database Permissions in SQL Server

Last Wednesday I woke up feeling under the weather with a hoarse voice. I wasn't up to doing the presentation...

Leaving (for) Las Vegas

Tomorrow I’m off to Las Vegas for SQL Connections. Since tomorrow is also T-SQL Tuesday #012, I’m writing a pre-trip...

“Wear Your SQL Saturday Shirt Day”

Over the past year there have been a number of SQL Saturday events.  These events have occurred across the country...

Vote for Our SQL Rally PreCon

VOTE VOTE VOTE VOTE VOTE VOTE VOTE!!!!!!!!!!
Vote here:  http://www.zoomerang.com/Survey/WEB22BD59JCQBT
Honestly, I want each of reading my blog to vote for our...

SQLServerCentral.com Track at SQL Server Connections This Week

If you are attending SQL Server Connections this week in Las Vegas, be sure to attend some of the sessions...

Database Security Best Practices for the Vigilant Database Administrator and Developer (Unabridged Edit)

Below is a longer version of the equivalent Technet Article  under Security TechCenter > Learn > Security Columns > MVP Articles >  Database Security Best PracticesThe security of...

Get Out The Vote

It’s actually kind of cool that SQL Rally voting for the pre-conference seminars and voting in the real(ish) world in...

I’m starting my own SQL Server Consulting business!

Beginning with tomorrow I’m no longer working for HP Austria, because I’m starting
my own SQL Server Consulting business. I’ve been...

Why do you use Sparse Columns ? (by Abi Chapagai)

What uses have you found for sparse columns in your databases?

SPARSE columns is a new feature in SQL Server...