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

Coming Soon! A Smaller, Leaner Database

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… Until then!

0

The Wait is Finally Over! SQL Diag Configuration Tool released on CodePlex

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 tool which allows a PFE to configure the…

0