by bobtaylor29708 | Apr 5, 2012 | Uncategorized
Here is a common scenario – you are performing a benchmark operation. You run your PerfMon file through the PAL tool (http://pal.codeplex.com). You are seeing massive disk queuing, high latency, high privleged processor time. You talk to your SAN engineers and...
by bobtaylor29708 | Mar 6, 2012 | Uncategorized
I was in Atlanta uyesterday speaking as part of the SQL Server Special Ops Tour – we had overflow audience. We had about 275 registered and 340 showed up! If you have to live in Columbus, OH I will be there on March 13th and in Boston, MA on March 28th…...
by bobtaylor29708 | Jan 5, 2012 | Uncategorized
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...
by bobtaylor29708 | Dec 12, 2011 | Uncategorized
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...
by bobtaylor29708 | Dec 2, 2011 | Uncategorized
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...
by bobtaylor29708 | Nov 28, 2011 | Uncategorized
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,...
by bobtaylor29708 | Aug 22, 2011 | Uncategorized
Kevin Kline of Quest Software writes a regular column titled ‘Tool Time’ (how is that for synergy). In the September issue he highlights my Compression Estimator. My wife and I spent almost three weeks touring Ireland and Scotland for our 20th anniversary....
by bobtaylor29708 | May 23, 2011 | Uncategorized
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
by bobtaylor29708 | May 20, 2011 | Uncategorized
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...
by bobtaylor29708 | May 17, 2011 | Uncategorized
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...
Recent Comments