Windows Server 8 Hyper-V Lab boot from VHD

Choosing the Right Microsoft Reporting Technology Part 2: Excel

This post is a continuation of a series started to help you understand each of the Microsoft presentation layer tools...

Configure Anti-Virus on your SQL Server

This week I had an application team report the error “SQL Connection Lost”.  Fortunately they also reported the exact times...

Date Dimension Script with Fiscal Year

One dimension you can be positive will always make it’s way into your data warehouse is the Date dimension.  Over...

First SQL Server 2012 Launch Event

I asked a few questions on twitter this morning after a friend of mine said they were have problems downloading...

How to log off remote desktop users from a remote machine ?

When you try to log on to a  remote server on emergency to perform some task , it may throw an...

Introduction to SharePoint BI Webinar Tomorrow

Tomorrow at 11AM Eastern time I will be presenting a FREE webinar for Pragmatic Works (website) on Introduction to SharePoint...

Most DBAs Don’t Seem to Know that Transaction Logs Can be Tuned

I was very surprised to see the results of my latest poll, which asked “When was the last time you...

Moving MSDB to new location

In recent past we have a situation where in we required to move MSDB, Model and Master databases to new...

Notes from the February 2012 MagicPASS Meeting

I was back at MagicPASS last week to do a presentation, my first time with the group at the new...