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

SQLSat153 Recap

You may not know that this past Saturday ( October 20, 2012) was SQLSaturday 153 in Salt Lake City.  If you knew about it, awesome.  If you attended –...

SQLSat153 Recap

You may not know that this past Saturday ( October 20, 2012) was SQLSaturday 153 in Salt Lake City.  If you...