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

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:

How To Get High Quality Information About Query Performance

Elisabeth Redei shows us how you can use the profiler, dynamic management views and SQLNexus to get high quality information about your query performance

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:

Is CHECKDB A Necessity?

I'm often asked by professionals whether CheckDB is still recommended on SQL2k8. SQL is calculating a checksum to avoid physical page corruption since 2k5. However in my experience (starting with SQL 7.0) I’ve never been able to clearly say that CheckDB is ...

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:

Understanding backups and log-related Trace Flags in SQL Server 2000/2005 and 2008

Kimberly Tripp is giving a play by play from 2000 to 2005/2008 to discuss the differences and what's changed and why those changes were significant. The biggest changes were between 2000 and 2005.

Here we are with another mesmerizing 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:

All indexes are unique

Gail Shaw tells us about the uniquefier which makes indexes unique

Performance impact: a large number of virtua...

Here we are with another fascinating episode of the SQL Friday, The Best SQL Server Links Of The Past Week show. I can't believe it is week 10 already, if I continue like this I will be retired soon.....or just tired without the re prefix.

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

Shrinking is a popular topic...

Mike explains some concepts about shrinking and the transaction log