New Toy: The Brydge iPad Keyboard – Updated

Finally a REAL keyboard for my iPad!
I can’t tell you how long I’ve wanted a real keyboard that my iPad...

NY SQL Server User Group Meeting - Bill Pearson

Thursday, November 29, 2012, brings us the November
meeting of the NY SQL
Server User Group, with BI expert, SQL MVP and...

should I use clustering on a VM?

ok, I'm going to keep this high level and simply share my opinion.
I am not prescribing anything.
If you want prescriptive...

Significant Achievements

As a few of you know, I took the Microsoft Certified Master (MCM): SQL Server 2008 lab at this year’s...

The Last DBCC CHECKDB Date and Restores

I ran across a question on Twitter recently where someone asked about the DBCC CHECKDB date after a restore. For...

Tip: OVER and PARTITION BY

I like to repost this blog about once a  year, because you really really need to know about windowing functions....

WIT Wednesday

On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...

Are Your Protecting Your DB Backups?

Folks have cited the recent InformationWeek article on how South Carolina's Department of Revenue was hacked because the SC state government...

Billing rates – other side of the fence

The following is a guest post by Tim Morgan from Sullexis in response to a resent blog of mine:
Thanks for letting...

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