Different ways to move Sql Server file location

Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons,...

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

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

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

Time Zones

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

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

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

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

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

SQL Internals Reading Data Records Part 6: Variable Length Data

Welcome back Dear Reader to Part 6 on our series of how to read a Data Record.    In Part 1...