An interesting customer question explained

While at a customer today I was given an interesting question. The individual was writing reports and needed to have right-justified, zero padded fields. He was investigating the FORMAT function which was introduced in SQL Server 2012. He had heard some mumblings that the FORMAT function was not as performant as good ole number stuffing….

0

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

Next on the Menu – event file target deep dive

In this SQL Snacks™ we will examine the event file target. Along the way we will unlock the magic of the Extended Event viewer UI in SQL Server Management Studio. Again this is longer than most SQL Snacks™ so the video will be in two parts. In the companion SQL Snacks™ this week we will examine the steps necessary to create…

0

Next on the Menu – Ring Buffer Target Deep Dive

In this SQL Snacks™ we will examine the Ring Buffer Extended Event target. Arguably the most flexible of the targets (despite a few of its shortfalls) we will use it to start the examination of the suite of targets available to us. In a future SQL Snacks™ we will examine the file target which is very…

0

Thanks to your feedback – SqlCommandFilters has been improved!

Thanks to reader EricEJ I have added an extension method to SqlCommandFilters which means instead of coding the call like this // Explicit usage //SqlCommandFilters.Parameters.Parameterize(ref cmd); you can now call it like this // Extension method on SqlCommand cmd.Parameterize(false); To do so requires two changes to the Parameters class first you need to modify the…

0

Next on the Menu – a reusable pattern for parsing Xevent data

In this SQL Snacks™ I will demonstrate a simple, three step process for writing a Transact-SQL script that can parse your Extended Event Session data. Then, in the upcoming SQL Snacks™ I will examine each target type individually with demo code for you to use.  

0