Every ebook from Apress for $15

Query Performance Tuning. Grant Fritchey. $15. If this doesn’t excite you, nothing will. Apress is offering every e-book for just $15...

Free One Week Passes to PluralSight

As you may know, SQLskills has been creating a lot of great new courses about SQL Server for Pluralsight. Nearly...

Last Weeks Top 10 “Reading” Links #8

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out...

Migrating SQL Server Databases that use Database Master Keys

There’s a lot of things to consider when migrating databases between SQL Server instances. I want to provide some tips...

Reducing the size of the distribution database & improving transactional replication performance: Part 2

The impact of having data sitting in the distribution database that doesn’t need to be there can be significant.  The...

SQLIO Analyzer Latency Divide by Zero Issue Corrected

A special thanks goes to Daniel Angerer (t) for suggesting an improvement that corrected the divide by zero error that one...

Time Pass With Transaction Log - Part 4 DDL

In this article,  We are going to CREATE/ ALTER/ DROP a table and observe transaction log records created for those DDL statements.
Our...

Treat Yourself to Knowledge

There’s a one day sale going on at Apress today, 11/26/12. All their eBooks are $15. This means you can...

Ybor City Farmers Market, Dogs, Kids, and Observations

Last weekend I was in Tampa for SQLSaturday #168 and made sure to make some time for family. The most...

Explore file physical structure - IAM

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