by bobtaylor29708 | Apr 10, 2020 | boB 'The Tool Man' Taylor, SQL Server Tools, SQL Snacks™
Recently my team needed to generate large databases for performance testing purposes of a tool. We were concerned with processing times, but not with statistics etc. NOTE: This is not a statistically interesting database. It is NOT for testing query performance!!! As...
by bobtaylor29708 | Feb 15, 2020 | boB 'The Tool Man' Taylor, SQL Server Tools, Tools
While revising some training I was trying to get a current list of the DMVs in SQL 2019. Our documentation no longer provides the jumping off point page to see them. So the Toolman grabbed his circular saw, tape measure and here you go! [sql] — put in the...
by bobtaylor29708 | Jun 10, 2019 | boB 'The Tool Man' Taylor, SQL Meals™, SQL Server 2016, SQL Server Tools, SQL Snacks™, TDC
I was presenting at SQL Saturday 893 in Virginia Beach this weekend and when demonstrating the code I accidentally chose TailSpinToys-US database. It turns out that schema names do not like dashes. So I have checked in changes to both the TDC Wizard C# project and the...
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, Tools
I had an interesting question from a customer that I am currently working with. They said, ‘In Azure SQL DB I can see the number of deadlocks very easily in a graphical manner – why can’t I do that on premises?’ I thought for a minute and a...
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...
Recent Comments