Automatic page repair with SQL Server Mirroring

Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring...

Checking Your Main BIOS Version

As some of you may know, I spent four years in the U.S. Marine Corps back during the Reagan administration....

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

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 Configure Database mail

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

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

May Question: How soon will you begin implementing SQL Server 2012?

Now that SQL Server 2012 has been released, this month’s question is “How soon will you begin implementing SQL Server...

Notes from SQLSaturday #107 in Houston

I’ve deliberately waited a bit to write this after the event, just to see what stood out after a week...

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