Presenting PowerShell: Automating SQL Stats Collection

Reblog: September 28 to October 4

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

SQL Azure–Failed to Update because the database is read-only

An error message for one of our many SQL Azure databases was brought to my attention today.
Msg 40628, Level 16,...

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