Windows 8 First Impressions

I haven’t worked with Window 8 at all. I’m not a big beta tester, and it’s been a busy few...

You don’t like SQLTreeo price

Today is the first day when we turned SQLTreeo into a commercial product and your emails continue to flood into...

Another Stop-Gap Solution for the SQL Server 2012 Identity Crisis

                I haven’t seen this many fake ID’s since I was in college.

                Back on April 26, Grant Fritchey (of execution...

Discovering Binary Pages In Sys.Indexes

In a previous post, we looked at how to take the the binary page values in sysindexes and convert the...

Getting Started with Partially Contained Databases

Before SQL Server 2012, when we move or restore databases to a different SQL Server instance, then any logins associated...

More Thoughts on the Mac Air

I’ve been living with my Mac Air for a few weeks now, thought I’d share some quick thoughts:
I miss the...

perfcollect

This is one of my most closely held DBA secrets.
Do you use PAL? You should.
Clint Huffman is a golden god...

Policy-Based Management, How Sweet It Is

I have just recently changed employers and in doing so, I’ve changed my role from Data Architect to DBA/BI Developer. ...

Reported: VMware’s Oracle support goes 24/7 starting Q1 2013

Michael Webster from longwhiteclouds.com reported that VMware Global Support Services told him a few days ago that the Extended Oracle...

SQL Server Service Broker error database cannot be enabled

Problem
The SQL Server Database Engine returns the following error message after a service broker enabled database is restored to the...