SQL Saturday #149 Session Materials

This past weekend I attended this year’s SQL Saturday in Minnesota. It was a good time, and it was on...

Create a portable virtual machine with OVF or OVA

Today a great client asked me how to export a VM to an OVF or OVA so he could transport...

Finally, it has happened…

Last month I blogged about my absence from the blogosphere.  If you want, you can read about it again – here....

Finally, it has happened…

Last month I blogged about my absence from the blogosphere.  If you want, you can read about it again – here.  Granted, it has been a month and I...

Jacksonville Code Camp 2012

Hello one, hello all. It has been quite a while since I have blogged. I am looking forward to starting...

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