by bobtaylor29708 | Apr 15, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
This introduction video will explain the goals of this SQL Snacks™ series. We will examine why you might want to learn the Kusto Query Language and I will outline the subjects that will be covered in this series....
by bobtaylor29708 | Apr 9, 2019 | boB 'The Tool Man' Taylor, SQL Meals™, SQL Snacks™
After my return from vacation I will be starting a new SQL Snacks series, titled “A deep dive into the data lake with Kusto” where I will first show you the relevant Microsoft services such as Log Analytics that leverage the Kusto Query Language (KQL) as...
by bobtaylor29708 | Aug 20, 2018 | Azure SQL Database, boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Tools, SQL Snacks™, Tools
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...
by bobtaylor29708 | Aug 13, 2018 | boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Management Studio, SQL Server Tools, SQL Snacks™
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...
by bobtaylor29708 | Aug 6, 2018 | boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Management Studio, SQL Snacks™
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....
by bobtaylor29708 | Jul 30, 2018 | boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Management Studio, SQL Server Tools, SQL Snacks™, XE Profiler
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...
Recent Comments