Maidenhead SQL Server User Group – 9th July with Alex Whittles and John Martin

Another month and another evening of top quality free SQL Server goodness for those living/working in the Maidenhead area of...

SQL Saturday Orlando: LAST CALL for Speakers

Hello Dear Reader!  I just wanted to write to Thank All of you for the submissions to SQL Saturday 232...

Connecting Ruby 1.9.2 to Microsoft SQL Server on Windows

Ok, before I continue to next step, I really want to put down something about it. Especially  about ‘how to...

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