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

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

Denali — Day 1: Tempdb Compatibility – Bug?

Denali — Day 1: Tempdb Compatibility – Bug?

 
I have installed sql server 2012 express and evolution edition on my personal laptop, and...

How to execute a package from another package?

I hear you. You’ll use the Execute Package Task. This mechanism of executing one package from another is popularly knows...

Creating a Sequence in SQL Server 2012

Sequences are a new object in SQL Server 2012 that generate just what the name implies: a sequence of numbers....

How to Configure Database mail

In my daily job as a SQL Server consultant I go to a lot of places, many days on the...

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

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

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

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