Time for another episode of the SQL Friday, The Best SQL Server Links Of The Past Week show.

Here is what I found interesting this past week in SQL Land:

Backup Log with Truncate_Only

Brent Ozar (without Hulk hands) explains in a video why backup log with truncate_only is a dangerous command with serious consequences. Learn why this might not be the best way to free up drive space on your SQL Server.

Time for another episode of the SQL Friday, The Best SQL Server Links Of The Past Week show, the Good Friday edition.

Here is what I found interesting this past week in SQL Land:

Updated Errors may occur after configuring Analysis Services to use Kerberos authentication on Advanced Encryption Standard Aware Operating Systems

The PSS ...

Time for another episode of the SQL Friday, The Best SQL Server Links Of The Past Week show.

I skipped last week because of some mysterious reason. Here is what I found interesting this past week in SQL Land:

The death of datetime?

Bart Duncan explains why you should almost always use DateTimeOffset instead of Datetime

Who ...

Time for another episode of the SQL Friday, The Best SQL Server Links Of The Past Week show.

Here is what I found interesting this past week in SQL Land:

A DBA utility database in every SQL Server instance?

Linchi Shea writes: I was reading Louis Davidson’s post earlier today, and what he said below caught my attention:

I am a big believer in having the database be as self contained as ...

Time for another episode of the SQL Friday, The Best SQL Server Links Of The Past Week show.

Here is what I found interesting this past week in SQL Land:

SQL Server 2008 Auditing Resources

Lara Rubbelke points us to some good SQL Server 2008 Auditing Resources

Spatial Indexes in SP1, almost no hints required...