Backup History

This is a quick rewrite of the script I just posted a few days ago.  The script had a few...

Get Performance Counters from within SQL Server

I think most DBAs know that you can use the Windows Performance Monitor to capture performance metrics for your SQL...

How to create site directly in new content db

Hey Friends,

Sometime when we build a new SharePoint site or site collection. We may feel to create in a new...

On the Advantages of DateTime2(n) over DateTime

Starting with SQL 2008, we database developers started becoming more familiar with datetime2.  Sometimes folks need convincing though, so here...

SQL Server Policy Based Management Alerts

SQL Server Policy Based Management Alerts

Problem

Policy-Based Management is used to enforce standards on SQL Servers and it's great. But not...

HDInsight, Finally

See this:

That’s right. The install worked. All I had to do was get a completely clean server set up. No...

Last Weeks Top 10 “Reading” Links #9

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out...

Lost in Translation – Deprecated System Tables – sysprocesses

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...

MDX #22 – What to use for explicit sorting on dimensions

I often think that I am lucky to work in a profession that I enjoy very much. It makes everything...

MDX #23 – “Hello World!” Lesson in MDX

Almost every tool we learned has some sort of “Hello World!” tutorial lesson.
So here comes the “Hello World!” lesson in...