Starting to Use Powershell

I have to admit that before the Powershell Challenge, I wasn’t really looking forward to using Powershell for much of...

Security, Compliance, and SQL Server – Recording Now Available

If you missed it live you get a second chance! http://www.mssqltips.com/sql-server-video/284/security-compliance-and-sql-server-video/. Had about 300 attend and more questions than we...

Uninstalling SSMS on Server Breaks SQL Powershell

I reviewed my daily report and saw that some jobs failed on six instances overnight, the common factor being that...

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...