Tech Ed 2012 – A 20th Anniversary Celebration. Wish you were here!

Tech Ed has been wonderful this year, a chance to meet up with old friends, make new old friends and talk about SQL Server. My session DBI410 – SQL Power Tools: Enhance Your Effectiveness with Extended Events was well attended with much interest and great questions. Thanks to those of you who attended. Please be…

1

The holidays are over – back to work!

I plan on releasing the next installment of The Extended Events series on Monday so watch for that. I finished up my work as the technical reviewer on William Stanek’s book Microsoft SQL Server 2012 Pocket Consultant – the ISBN is 978-0-7356-6376-3 which will be released at the end of February.  

1

Power Tools: Instruction Manual

Just like any good tool man, whenever you get a new tool  The first thing you should do is to read the instruction manual and familiarize yourself with the general operation of the tool. During this first installment, we will do just that. As mentioned we are going to dive into the components that make…

0

Power Tools: SQL Server 2012 Extended Events

In this series I will examine an important tool in the DBA’s toolbox – Extended Events While Extended Events were present in SQL Server 2008 and SQL Server 2008 R2, they were not widely adopted as a DBA tool. This was partially due to the fact that prior to SQL Server 2012, there was no UI…

1

The Tool Man brings you Power Tools…

Starting on December 1st 2011, I will be publishing a series of blog posts that are deep dives into the ‘Power Tools’ that ship with SQL Server 2012. The first series will focus on Extended Events (XEvents) which allows the DBA to perform tasks, troubleshoot problems, and understand the internal workings of SQL Server like…

0

SQL Diag Configuration Tool Version 1.0.1.0 has been released

This release fixes a potentially serious bug which could produce mal-formed XML. Please get the latest version from CodePlex – http://sdct.codeplex.com If you are interested in the gory details follow along. I use a DataSet object to read the xml file by using the DataSet.ReadXml method. This makes it easy to map the hierarchical structure…

0

Compression Estimator V1.0.2.0 is now available

Thanks to feedback from you, I have released version 1.0.2.0 of Compression Estimator. This is really a minor release. I was filtering databases in the Database drop-down list based on compatability level. this is not necessary, since even databases in 9.0 compatability level can take advantage of compression. So instead, when I list available SQL…

0

Compression Estimator V1.0.1.0 Now Available

Thanks to all for your feedback. Version 1.0.1.0 is now released and it contains the following changes: The Connect To SQL Server dialog now supports typing in a server instance name. You can also select Browse for more to do the original network search for available SQL Servers The Connect To SQL Server dialog now…

0

Shifting to UTC time by using the datetimeoffset data type

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). Many implementations prior to SQLServer 2008 do not have that…

0