Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

MDS and Best Practice Analyzer new features were introduced in sql...

Exercise in the Margins

This article about exercising when you can is really interesting. It contains a number of hints about exercising and fitting...

From the Labs of SQL Prompt

I love SQL Prompt as an add-in for SSMS. The intellisense is very handy for me and I’ve gotten used...

How to restore the tail end of a transaction log

Have you ever tried to restore a backup over an existing database and receive an error stating the tail of...

SQL Server – Cannot resolve collation conflict

A friend of mine contacted me through email today having a very common problem with a query he had written....

The Done Stamp

I’m fond of replying with “done” when a task is complete, no need for anything more elaborate. I’ve been experimenting...

Denali – Day 24: True Black Box Recorder – sp_server_diagnostics

Denali – Day 24: True Black Box Recorder – sp_server_diagnostics

Earlier sql server was having diagnoses tool.

Default trace.

SQLDiag

And other tools but could not...

It’s OK To Eat Alone

There’s a lot to be said for the philosophy of Never Eat Alone, using meals as a great time to...

Recently Used Tables and Databases

Recently developed these queries to assist with the evaluation of development or sandbox environments.  Sometimes disk space demands that old...

SQLServerCentral.com Track Offered at 2012 SQL Server Connections in Las Vegas this Fall

As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections...