SQL Server 2012 SP1 CU1 Is Now Available !

The 1st cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...

SQL Server 2008 SP3 CU8 Is Now Available !

The 8th cumulative update release for SQL Server 2008 Service Pack 3 is now available for download at the Microsoft...

Lost in Translation – Deprecated System Tables – sysobjects

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...

Newsletter

Back in the old days before this blog when I was publishing a website instead that has long been consigned...

Using Facebook to extend/enhance your blogging

I read a blog a few months ago by Ramkumar Gopal (blog) in which he had setup a Facebook page...

MDX #21 – Days in a month

ParallelPeriod() function is very useful when we need to present data side-by-side for two parallel periods
ParallelPeriod() function is often used...

MDX #20 – Last Data Date

Need to check the last time when our ETL processes ran successfully
Data warehouse developers routinely query the last data date...

Notes from SQLSaturday #168 in Tampa

I made a quick trip to Tampa for #168 this past weekend. It was a “BI Edition” and it felt...

Explore file physical structure - Delete

1. Create sample db

use master
go
CREATE DATABASE [test] ON  PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 2048KB , FILEGROWTH = 1024KB...

Lost in Translation – Deprecated System Tables – sysusers

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...