freedom

I was thinking back fondly of my Dad - who passed away during Hurricane Sandy - this past Father's Day. Of the...

Install Windows Server 2012 on VMWare Workstation 8

Sometimes we try an do things that just shouldn’t work.  Maybe they aren’t supported or there technology isn’t designed for...

SQL Server: Part 4 : All About SQL Server Statistics : Auto Update Statistics Threshold - Importance of Manual statistics maintenance

In the last post, we have discussed about the auto create and auto update property of the statistics. Do we really need to do manual statistics maintenance to keep...

SQL Server: Part 4 : All About SQL Server Statistics : Auto Update Statistics Threshold - Importance of Manual statistics maintenance

In the last post, we have discussed about the auto create and auto update property of the statistics. Do we...

Notes from the 2013 American Association of Woodturners Symposium

This was my first time attending the AAW Symposium, hosted by the American Association of Woodturners. Here are some quick...

trace flag for backup and restore operation

1. 3004
show the internal backup/restore operation for every step.
ex.
dbcc traceon(3004,3605,-1)
GO

3605 means output the message to errorlog. you can use 3604...

SQL Server Pro Article: Custom Programming to Enhance SSRS Reports

I’m very excited to see my first feature article published in SQL Server Pro Magazine titled Custom Programming to Enhance...

SQL in the City London 2013

Wow!
You’d think that an event might get a little worn by the third time you’re doing it. That maybe it...

T-SQL Tuesday #44 The Second Chance

Hello Dear Reader!  This is the first Tuesday of the month and you know what that means.  It’s time to...

SQL Server Data Tools (SSDT) – June 2013 update

SQL Server Data Tools (SSDT) has a new update:
VS 2010: June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0, November 2012 version:...