Presenting “PowerShell: Automating SQL Stats Collection”

On 10th Oct 6.30 PM, I will be presenting “PowerShell: Automating SQL Stats Collection for Performance Tuning”@ at San Francisco...

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

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

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

SharePoint dependencies

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

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

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

Finally, it has happened…

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

Jacksonville Code Camp 2012

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

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