Columbia Enterprise Developers Guild meeting tonight

If you're in or around the Midlands of South Carolina area, the Columbia Enterprise Developers Guild meets the 2nd Wednesday...

Quick tip: configure SQL Server authentication mode using T-SQL

SQL Server stores its authentication mode in the registry. The registry can be read and updated using the T-SQL commands...

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