SQLCMD – Database Backup and Restore – Automation – Quickest and Simplest method

In today’s world we rely more on third party tools to do a Backup and Restore of databases. Most of...

Using a system function as a computed column within a table-value function….

Wouldn’t it be nice if SQL Server allowed this functionality? for instance if did the below:-

I get the above error....

Windows Failover Cluster Monitor

Windows Failover Clusters are fantastic, they provide High Availability for mission critical SQL Server instances and make my life as...

Introducing Python in Hadoop World

This blog is not for pure Python lover. In this article I will describe usefulness of Python in Big Data and Hadoop environment. To discover more about Python please...

Introducing Python in Hadoop World

This blog is not for pure Python lover. In this article I will describe usefulness of Python in Big Data...

Reblog: August 9 to August 15

This reblog post should have come out last Friday, but I was on vacation and I didn’t want any new...

SQL Saturday #235 New York City Wrapup

Today I had the pleasure of speaking at the SQL Saturday #235 in New York City. Talk about an absolutely...

24 Hours of PASS Q & A: Why are Bit’s Flipped?

http://bit.ly/16UyEPHHello Dear Reader.  Almost two weeks ago I delivered a presentation for the 24 Hours of PASS on SQL Server...

Boorish Behavior? No, Worse. Death Threats Against Developers/Designers.

I know DBAs and developers have a rocky relationship. However, I don't believe we go as far as some of...

Cannot find NT Service\MSSQL$SQL2012?

If you cannot find the virtual account used by the default settings installation of your SQL 2012 instance (in this...