Determining Filegroup for a Table

Have you ever needed to figure out which filegroup your tables are located within?  If you had to do this,...

EXECUTE, not required, but advisable.

The other day one of the developers I work with gave me a script similar to this:
BEGIN TRAN
sp_rename 'tablename.columnname', 'newcolumnname'
COMMITHe...

Quick alert on servers which are not compliant for policies set using PBM

Last month I wrote about leveraging policy based management for regular DBA compliance checks. You can read that post here.
Policy based management(PBM) is indeed...

Speaking at the Business Analytics Conference, April 1-12 in Chicago

The email message earlier today said “Please note that the official schedule will be released tomorrow, February 6th, so please...

Using SkyDrive at Work for Collaboration - A Quick Start Guide

It seems that many of my projects in the past year or so have required sharing files with external business...

A Month of PowerShell – Day 5 (Scripting – Putting it together)

Welcome to Day 5 of my “A Month of PowerShell” series. This series will use the series landing page on...

Adding the Clustered Key To Your Nonclustered Index? Part 2

Of course, a rather obvious answer presents itself the next day.  After reviewing the actual environment that my colleague was...

Feb'2013 Chennai SQL Server UG Meet Is Scheduled

 Chennai SQL Server user group meet is scheduled for Feb'2013.
Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30...

Handling Null Values in SQL Server

What is NULL?

In SQL, A Null is an unknown or undefined value. Some interesting
operations on NULL.
--query                 --resultselect 3*NULL      --NULLselect 3+NULL     ...

I’m Speaking at ….

Last week I noted that I was speaking at the new SQL Intersection event. Hopefully I’ll see some of you...