Consider All the Possibilities When Troubleshooting

When you are troubleshooting, the rule is if you've checked the obvious possibilities and still haven't solved the problem, it's...

Currency Conversion in Tabular Model Using DAX

Roughly a year ago, I implemented currency conversion logic in multidimensional cubes using measure expressions (as well as using the...

DBCC Commands for SQL Server

DBCC Commands:
DBCC commands are most useful for
performance and troubleshooting.

The DBCC Commands are used in Maintenance, Informational use, Validation on a
database,...

Central Subscriber Model Explained

The majority of SQL Server Replication topologies are based on the Central Publisher model, which is comprised of a single...

Bananas For SQLSaturday

I was catching up on reading today and saw that Instructables had a how-to on “tattooing” a banana, also called...

Day 22 of 31 Days of Disaster Recovery: Which DBCC CHECK Commands Update Last Known Good DBCC

The end of the day is quickly approaching as I finish this blog post. This is day 22 in my...

Windows 8 In 25 Minutes

Here’s a quick plug for The Missing Windows 8 Instructional Video. I watched it and learned quite a few things,...

Speaking at VMware Partner Exchange on February 24

I am pleased to announce that I am speaking at VMware’s Partner Exchange for their CI1464 – Virtualizing Microsoft SQL Server...

Day 21 of 31 Days of Disaster Recovery: Who Deleted That Data?

Welcome back for day 21 of my 31 Days of Disaster Recovery series. Today I want to talk about trying...

Cumulative Update – 2 for SQL Server 2012 Service Pack 1 Is Now Available !

The 2nd cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 2 contains all...