Master Data Services (MDS): Bug deleting an attribute

UPDATE on 11/28/2012:  I had this same error when trying to delete a model.  Fortunately, SQL Server 2012 SP1 has...

Parallel Data Warehouse (PDW) How-To: Using BACKUP and RESTORE DATABASE on PDW

Before we get to the backup and restore syntax, its worth noting that the Parallel Data Warehouse (PDW) appliance architecture offers...

SharePoint dependencies

Microsoft has made a big push the last few years to have all its end-user BI tools integrate with SharePoint,...

SQL Server: Sending Email in HTML Table Format Using TSQL

As part of our DBA life , we have to configure many alert or statistical  mails which gives an idea about...

Tale of detaching a database which was enabled for replication!

In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.

Almost all...

Webcast on SQL Server Auditing on October 9th

Idera will be re-broadcasting that I recorded earlier in the year on meeting audits with SQL Server. It's scheduled for...

2012 PASS Board of Directors Elections - It's Time To Vote!

It's time once again to vote for the 3 candidates we feel will best represent the SQL Server community with...

Blog Changes

I have made a few changes to the blog over the past couple weeks The changes have come about as...

Dealing with orphaned users

The Scenario:
You just restored a production database on a development server. You’ve told the developers that it’s restored, and you...

Get a Free SQL Server Indexing Book

What would you say if I offered you the best indexing book on the market for SQL Server 2012?
Wow, right?...