by bobtaylor29708 | Jan 9, 2019 | boB 'The Tool Man' Taylor, Extended Events, Power BI, SQL Server 2016, SQL Server 2017, SQL Server Management Studio, SQL Server Tools
With the retirement of the MSDN blog platform, I will now be blogging here at www.sqlbobt.com. If you are reading this, then you have already found me 🙂
by bobtaylor29708 | Oct 2, 2018 | boB 'The Tool Man' Taylor, Query Data Store, SQL Server Management Studio, SQL Server Tools, Uncategorized
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...
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....
Recent Comments