Blogging for Beginners

Last week at the PASS Summit, I had several conversations with several different aspiring bloggers, and found myself saying the...

Rules of Holes #6: Don't Draw Others Into the Hole with You

In the Fifth Rules of Holes, you were encouraged to seek help from others in order to extricate youself from...

Explore file physical structure - fixed length row

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 = 3072KB , FILEGROWTH = 1024KB...

Master Data Services Web Services API Error

In Master Data Services (MDS), I received an error when using C# code in the script task in SSIS 2012...

Lost in Translation – Deprecated System Tables – sysopentapes

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

PASS SQL Saturday World Map

I had the pleasure of helping Karla Landrum (@Karlakay22) for the PASS Summit 2012 by creating two dashboards: SQL Saturday...

PASS Summit 2012 – Networking

I was fortunate to attend my 4th PASS Summit. For the past 4 years I have flown out to Seattle...

Login issues with WSS 3.0 || Moss2007 || SharePoint2010

Hey Friends,
Sometime when we build a SharePoint server we can face issues with login. The login prompt keeps on asking...

Top 5 Books on SQL Server 2008 Business Intelligence

Carrying on with book week and answering the question I’m often asked about what books I;d recommend to learn about...

[video] Inside Tempdb - Bob Ward

Boris Hristov shared this with me ages ago and I still haven't watched it yet (it is a few hours...