How Do You Handle the Stress of Being a DBA?

This is a reprint of my editorial at SQLServerCentral.com. There is a lively discussion at the SSC forum on this...

Instant File Initialisation

I have been reading up on instant file initialization and I have read a couple of good blog posts by...

Part 3: Creating the SSC Maintenance Plan

Note: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could...

PASS Virtual Meeting - Zero to Cube in 60 Minutes

PASS Virtual Meeting

Speaker: Adam Jorgensen

Topic: Zero to cube in 60 Minutes

Date and Time: 1/22/2010 12:00 PM EST

Meeting URL: Join Meeting

Description:...

PayPeriod Matching

Recently I was asked to alter a report to pull different more meaningful data.  The particular report was pulling data...

PowerShell Script for Creating Indexes

I needed to create an identical index on a bunch of tables within one of my projects (yes, I know...

Speaking at European PASS

I just heard that two of my presentations have been accepted for the European PASS Conference 2010 in Neuss, Germany,...

Speaking at SQL Saturday Tampa and Richmond

Over the next two weekends there will be three SQL Saturday’s held, in Tampa (1/23), Boston (1/30) and Richmond (1/30).I...

SQL Server 2008 - Top Reasons to Upgrade.....

OK, you've seen many of these before, but if you haven't figured out its TIME to upgrade your SQL Servers to...

SQL Server 2008 R2 - official date

Since the August 2009 when the CTP ( Community Technology Preview) version was available, the Microsoft announced the offical release date...