Virtual Lab – Creating Differencing Disks

This is part of my series on building a virtual lab for use with SQL Server and Windows. You can...

McIntosh MT5 #stayclassysandiego

Making or assembling electronics in America may be the next big trend in tech, but it’s nothing new for McIntosh....

Annoying Recruiters

In a follow-up to my blog post Low-rate recruiters – The bane of my existence, Michael Bramante (website) wrote me a...

Sometimes Cheaper Makes Sense / Mastering the Basics Always Does

It’s good to remember that the ideas and challenges of mastering a craft – any craft – have been around a while....

Restoring Filegroup backups on another server, and why it won’t work…

We have 2 different SQL Servers which both have a copy of the AdventureWorks2012 database in Full recovery mode.
One of...

The Strange Story About the MERGE that Killed the Cluster

I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a...

101 Whiskies to Try Before You Die #whiskey

In his new book “101 Whiskies to Try Before you Die” whisky expert Ian Buxton poses the fun challenge of...

Attach Database “Operating System Error 5 (Access is denied)” MSSQL Server 2012.

When I try to attach mdf file I got following error below.

Solution:

There are multiple solutions to this

1    1.    Move .mdf and .ldf to SQLServer install directory Data folder...

Review: 2013 Land Rover LR4 Overland Journal Edition

The guys at Overland Journal know how to adventure, and adventure well. Their magazines can be found both on coffee...

Restoring Filegroup backups on another server, and why it won't work...

We have 2 different SQL Servers which both have a copy of the AdventureWorks2012 database in Full recovery mode.
One...