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

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

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

Reblog: November 16 to November 22

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

Playing with Cython

Intro Recently, I came over Cython and started experimenting with it.  After some basic testing, I found several things of...

I’m Thankful for 978-1-84968-508-5

There are things that I’m thankful for this year. Yes, I also got a lot of setbacks but that wouldn’t...

Lost in Translation – Deprecated System Tables – sysperfinfo

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

thanks for Bud

My Dad died horribly three weeks ago in a fall after the power got knocked out during Hurricane Sandy. I...