by bobtaylor29708 | May 9, 2011 | Uncategorized
As promised, I have released my SQL Server Compression Estimator tool to http://ssce.codeplex.com/ One of the most exciting additions to SQL Server 2008 was the capability to apply data compression. The benefits are many including reduced disk I/O and memory...
by bobtaylor29708 | May 9, 2011 | Uncategorized
As the world moves to a global economy, it becomes more and more important to capture time information with respect to Coordinated Universal Time (UTC). This format captures the date and time along with a time zone offset (offset values range from -14:00 to +14:00)....
by bobtaylor29708 | May 5, 2011 | Uncategorized
Watch for the announcement of the soon to be released Compression Estimator Tool. This tool will simplfy the examination of a database, and the selection of objects that would benefit the most from the application of compression techniques. I expect to release this to...
by bobtaylor29708 | May 2, 2011 | Uncategorized
Share Many Microsoft SQL Server DBAs automate as many of their day to day processes as possible, freeing them to attend to higher impact activities. To do so, many DBAs leveraged two undocumented system stored procedures, namely...
by bobtaylor29708 | May 2, 2011 | Uncategorized
The wait is finally over! The SQLDiag Configuration Tool has been released. One of the most heavily used tools in the SQL Server Premier Field Engineer’s tool belt is PSSDiag. It is maintained by Microsoft’s Customer Service and Support organization (CSS)...
Recent Comments