SQL Server Storage Internals Part 1 - Basics

 While learning query tuning topics, I got a chance to understand anatomy of data page and different types and levels...

Upgrading to SQL Server 2008 - a comprehensive checklist.

 
There are many considerations and much preparation to do, when a company decides that it is ready to upgrade their...

iPads for Christmas

There's a contest going on, today through Friday, and you can win a copy of SQL Monitor from my employer...

SQL Server 2005 SP4

Last year I submitted a Connect item for SQL Server 2005 SP4. Quite a few people supported this item and...

All Things Awesome and MidnightDBA-y – 12/9/2010

Here’s the rundown of what we were up to last week
Friday night at 11pm CST we present another wildly appealing...

December PASSMN Meeting This Week

Getting SQL Server for
Christmas! Happy holidays and seasons greetings! 
Let PASSMN put a little SQL and PowerShell in your...

SQL Standards

Three posts, three critical rants. It's time to be constructive.

I was given the responsibility to decide on the SQL development...

SQLPSX 2.3.1 Release

We’ve released a minor update to SQLPSX which includes several bug fixes as well as two new modules. Here’s an...

SSIS: great idea, but buggy as heck.

Oh SSIS, how I love and hate you.

As DBA at my company, I don't actually develop much in SSIS. But...

RTFM365, Week 1

Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t...