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

Getting Nexus 7 Connected To Windows 7

Have trouble getting your new Nexus 7 connected to Windows so you can move some media files over?
Install the drivers...

IIS Express Quickie Command-line

This is a reminder to my future self for how to quickly start IIS Express from the command-line on 64-bit...

PASS Summit 2012 - Done!!!

Thursday afternoon
Thursday afternoon concluded with How to run SSRS in Sharepoint integration mode, Enriching Tabular with DAX and Monitoring SSAS....

PASS Summit 2012 Review

Life is finally returning to normal after a great week in Seattle for PASS Summit 2012.  The entire year is...