Non-unique indexes that COULD be unique

In my last post I showed a query to identify non-unique indexes that should be unique.
You maybe have some other...

Final Day for Power BI Voting, Can I Have Your?

Today is the final day for the Power BI Contest voting and I could use your help to move on...

Your own personal space

Somewhere to relax, get away from it all (by all I mean pesky Developers wanting code deployed on a bleeding...

2013 with You & SQL Server

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:
The concert hall at the Sydney...

It May Be Necessary Re-enable Service Broker After Baremetal Restore

After the restore of a database, or perhaps a bare-metal restore of a Windows server running SQL Server, unique IDs...

Database Project Versioning

SSDT 2010, 2012 with TFS integration brought about a couple of different options when you are looking to version your...

SSIS Training class by Andy Leonard

Andy Leonard (b | t | l | f) of Linchpin People, has announced a new training class called ‘From Zero to SSIS‘. The first class...

New SSIS Training Class from Andy Leonard

Andy Leonard (b | t | l | f), a good friend of mine from Linchpin People, has announced a new training class...

Have You Studied SQL Server Enough?

Photo Credit – yum9me
SQL Server is a fairly big and complicated product.  There are quite a few areas that you can...

SQL Server Quickie #10 – Forwarding Records

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...