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

Most Interesting People…

Here are the most interesting people I met at PASS Summit 2012   Mickey Stuewe (sqlmickey) Neil Hambly (neil_hambly) Bob Hovious Gail Shaw (sqlinthewild) Ed Watson (SQLGator)    ...

Most Interesting People…

Here are the most interesting people I met at PASS Summit 2012
 
Mickey Stuewe (sqlmickey)
Neil Hambly (neil_hambly)
Bob Hovious
Gail Shaw (sqlinthewild)
Ed Watson...

How to Use xp_delete_file to Purge Old Backup Files

Continuing on my recent trend of using undocumented stored procedures, this week I thought we can cover using xp_delete_file to...

Lost in Translation – Deprecated System Tables – syspermissions

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

Final 2012 Learning Opportunity

There’s still a little time left in the year. I know some businesses have allocated training budgets and if they...