Next on the Menu – A new tool! xel2sql

Based on a request by Microsoft Test Consultant Robert George, this SQL Snacks™ along with a tool I am releasing to the community will allow you to run a Transact-SQL workload on Azure SQL Database, capture the xel files to Azure Blob Storage, and then process them to produce an executable Transact-SQL Script that duplicates…

0

Next on the Menu – Why is that recompiling?

In this short SQL Snacks™  we will look at a question that arose while I was at a customer site. While running load tests we were seeing abnormally high numbers of recompiles vs. compiles. Knowing that this could lead to higher CPU consumption we investigated. Thanks to Forrest McDaniel @TSQLAddict for the basis of this SQL Snack™…

0

Next on the Menu – XE Profiler

In this short SQL Snacks™  we will examine a feature introduced in SQL Server Management Studio V17.3 – namely the XE Profiler which will make our lives considerably easier when configuring XEvent capture for a test run.

0

Next on the Menu – counter, histogram, and pair matching targets

In this SQL Snack™ I will examine the three remaining targets (I don’t plan on covering the ETW sync target as it is out of scope for this series). The counter, histogram and pair matching targets are very simple and straight forward to use and consume. In the next SQL Snack™ I will examine a new…

0

Next on the Menu – event file target for Azure SQL Database

In this SQL Snacks™ we will examine the techniques required to implement the file target for an Azure SQL Database. We will also examine the differences in the Extended Event system between on premises and Azure SQL Database. The link with the instructions for creating Azure Blob Storage can be found here. As I mentioned in the SQL…

0

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