SQL Intersection, Spring 2014

I am terribly jazzed to be involved with this amazing event, SQL Intersection. It’s featuring some truly amazing speakers presenting...

Impersonating a server level permission

Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s...

Last Backup Times per Database and Backup Type

This script displays the last date and time of each backup type for each database.
It’s useful when you need to...

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

When I right click on the database diagrams folder in SSMS to create new diagram. Following popup window open with error.

Solutions:
From the Message you can clearly see that the...

What is HDInsight?

There are two flavors of HDInsight: Windows Azure HDInsight Service and Microsoft HDInsight Server for Windows (recently quietly killed but...

Write The Perfect Question (Of The Day)

Have you ever voted against something only to be glad later you got out voted? Too many years ago the...

Approachable? Sometimes.

Deservedly so, I got called out for a bit of attitude I displayed in a recent blog post: Time for...

Reinstall SQL Server Performance Counters

I’ve had several instances over the last few months where I had to reinstall the SQL Server Performance Counters.  It...

How to Load Data from Excel in SSIS – 32-bit vs. 64-bit

Let's say you are developing an SSIS package on your dev box to load data from an Excel file to...

Spezialrabattaktionen: 22% zum Jubiläumsjahr der PASS Deutschland e.V für Sicherheits- XEvent Tracing, sowie SQL Server 2014 Seminare + 10% Microsoft TechNet Aktion für alle

Damit auch alle, die vor 2 Wochen nicht auf der SQL Konferenz in Darmstadt (www.sqlkonferenz.de) waren, oder nicht regelmäßig bei...