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

T-SQL: CASE Statement

For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...

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

HDInsight, Finally

See this:

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