SQL Lunch #68 – Designing Your First Power View Report

Next week I will be speaking on designing your first Power View report for SQL Lunch.  Be sure to join me...

Baton Rouge SQLSaturday #150 & Tech Day .Net 1 track

August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. LSU has offered...

Book: Expert Performance Indexing for SQL Server 2012

After about a year of work and a month of waiting, the book I wrote with Ted Krueger (Blog | @Onpnt)...

Retrieving password policy settings for SQL login accounts

Today, I wrote the following query for our internal audit report for SAS70. This query provides all the necessary details...

Service Broker Adventures: Stucked Queue Monitors

This week I'm in London helping a client with its large scale Service Broker deployment,
mainly troubleshooting some strange problems with...

SQLSaturday #122, Louisville

Date: July 21, 2012
Session: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve...

SQLSaturday #164, Cleveland

Date: August 18, 2012

Session 1
Title: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe...

SSIS 2012 Change Data Capture (CDC) Control Task

Change data capture was introduced in SQL Server 2008 and has been pretty popular ever since. The basic concept behind...

Time Zones

Why don’t we have a function like the one in this article to convert from time zone to time zone?...

Back Across the Pond

This coming weekend is SQL in the City – London 2012. Friday, July 13, and Saturday, July 14, I’ll be at...