The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.  Read more...

We're featuring some interesting blog posts that we think have information you need to know. This one is from Paul Randal of SQL Skills, former storage engine lead for SQL Server. Do you know how the daylight savings time change will affect your computers?  Read more...

Most DBAs dread hearing that they need to restore a database to a point in time, especially if the database is a production database. However, knowing how to do this is of the utmost importance for a DBA's skill set. I'll walk you through the steps of how to restore a SQL Server database to a point in time to recover a data table.  Read more...

In the first part of his series on SQL Server Availability, new author Kumar Parthasarathi brings us a look at Database Snapshots in SQL Server 2005.   Read more...

Learn how to use ALERTs, a SQL Agent job and a stored procedure (SP) to create a copy of your critical database backups on another physical machine as soon as the database backups are created.  Read more...

Not the traditional overview here. Steve Jones takes a look at the various high availability technologies from a different perspective.   Read more...