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

Top 3 Books on Writing Transact-SQL (TSQL)

This weeks blog posts have been focusing on books that I have read, like and recommend for learning SQL Server...