Browse by Tags

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

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.

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

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

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

Thanks to CodePlex member masteroz who pointed out conidtions where the resulting SQL script generation resulted in syntax errors. It's all fixed now and available in V1.0.3.0 on http://ssce.codeplex.com boB

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

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

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

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

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 CodePlex by early next week... ...

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) and has a very nice configuration...