About

I am a geek, husband, father, geocacher & gratuitous consumer of satellite signals (not in that order). I’ve been in IT professionally for over two decades doing web development,...

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

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

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

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

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

Speaking at Oracle Training Days

A first for me. I’m attending a non-SQL Server event, trying to bring a little knowledge of my platform to...

Power View and Reporting Services

There has been an active discussion thread on Chris Webb’s blog about the similarities & differences between various Microsoft BI & reporting...

Logins vs Users

Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....

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