The Year in Review - 2009th

Steve Jones looks back at 2009 and examines some of the predictions he made at the beginning of the year.

Scripting in SSIS – Part 1

Learning to script is a valuable skill for a DBA. Learning to script is invaluable for an SSIS developer and MVP Andy Warren starts a new series that examines the basics of adding scripts to your packages.

Crash and Burn

A recent crash of the popular Coding Horror blog brings the responsibility of backups to the front of today's editorial. See if you agree with Steve Jones and his take on backups and restores.

Crash and Burn

A recent crash of the popular Coding Horror blog brings the responsibility of backups to the front of today's editorial. See if you agree with Steve Jones and his take on backups and restores.

Crash and Burn

A recent crash of the popular Coding Horror blog brings the responsibility of backups to the front of today's editorial. See if you agree with Steve Jones and his take on backups and restores.

How To Get a Count of SQL Connections BY IP Address

These queries (which work on both SQL Server 2005 and 2008) are very handy if you want to know who...

Little info about Resouce DB (SQL Server 2008-2005)

Little info about System Resource Database in (SQL Server 2008/2005)

The fifth system database in both versions (SQL Server 2008 - 2005)...

Top 10 steps to optimize data access in SQL Server. Part I (Use Indexing)

’ll focus on the issues that you need to follow to make sure that you have done everything that you could do to optimize the data access codes you have written or you are going to write in future. The Database Administrators (DBA) also has great roles to play in optimizing and tuning the database performance. But, optimization scopes that fall into a DBA’s area are out of scope for these articles.

Resolving User Security Identifier (SID) Discrepancy in Read-Only Databases

Many experienced DBAs understand the issues with matching up users and logins in a restored database. But what do you do when the database is read only? New author Tychang Chen brings us a technique that can help.

Auditing in SQL Server 2008

Auditing is not only used to ensure internal compliance with authorization rules, it is increasingly used to comply with new legal compliance requirements. This article provides a detailed walkthrough for using SQL Server 2008's new inbuilt Audit feature.