Speaker Issues: The Quandry of Double Submitting

This is in response to yesterday’s Twitter conversation, and subsequent blog by Eddie Wuerch, about submitting to more than one...

Thank God I Chose SQL Server part II: How to Improperly Install Oracle 11gR2

As part of my ongoing effort to teach by bad example and pass on what little I’ve learned about programming...

The 2012 Powershell Scripting Game(shows) in review

Over the past few weeks, those around me know that I’ve been talking a lot about Powershell, how much it...

When Will You Upgrade to SQL Server 2012?

This is a reprint from my editorial in Database Weekly. Also, check out the May Question of the Month, as...

Blogging Tools: BlogDesk Review

As a blogger, you have several options available to you when it comes to writing posts.  You can write them...

Changing DB_CHAIN Can Clear the Plan Cache

If you make changes to the settings of a database, it can cause the procedure cache to be cleared. Microsoft...

Generate restore script automatically by backup history table

I wrote a store procedure which could generate restore script automatically by backup history table. it can help you select...

Less Energy through Better Design

When I attended SQL Saturday #131 at the Chandler Gilbert Community College, I was struck by a few design elements...

Locked out of SQL Server.

This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql...

SQL Saturday #131 Recap

This past weekend I attended a SQL Saturday in the desert. SQL Saturday #131 was held in Phoenix, AZ

It’s April,...