From the category archives:

SQL Server

The Top 10 SQL Server 2008 Features for the DBA

February 2, 2009

The SQL Server Customer Advisory Team (SQLCAT) just posted a great article listing some of the best new SQL Server 2008 features for the DBA. Here they are:

Activity Monitor
SQL Server Audit
Backup Compression
Central Management Servers
Data Collector and Management Data Warehouse
Data Compression
Policy-Based Management
Predictable Performance and Concurrency
Resource Governor
Transparent Data [...]

Read the full article →

SSIS Resources

January 29, 2009

***UPDATED 2/10/2009 – Added links***
***UPDATED 2/23/2009 – Added MSDN SSIS Forum and Jeff Wharton’s link list.***
Last Thursday I gave a talk at the Oregon SQL Server Developers Professional Association and promised to post some Integration Services resources.
SSIS Best Practices
SQLCAT – Top 10 SQL Server Integration Services Best Practices
Matthew Roche – SSIS Best Practices, Part 2
Jamie  [...]

Read the full article →

SQL Server Interview Blunders

January 16, 2009

I just read Jason Massie’s new Capt. Varchar(MAX) comic. If you have spent much time interviewing SQL Server candidates I’m sure this will bring back some memories.
I was helping a company phone screens candidates for a Senior DBA position a while back. We went through such a bad string of candidates that the three of [...]

Read the full article →

SQL Server Blogs I Read

January 7, 2009

I was playing around with Google Reader and found that you can publish a list of feeds in a specific folder. I thought it might be useful to share the list of SQL Server blogs I’m subscribed to. Since the list is being pulled from Google Reader is will stay up to date as I [...]

Read the full article →

PASS Community Summit 2008 Events Calendar

November 14, 2008

The Professional Association for SQL Server Community Summit is next week. I’m will be there, presenting three exam prep sessions. This will be my first time presenting at a conference so I’m a little nervous, and very excited!
There are quite a few events happening surrounding the conference, but information is pretty spread out. I decided [...]

Read the full article →

Next Entries →