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 | 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 | 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 | Jul 12, 2018 | SQL Server 2016, SQL Server 2017, SqlCommandFilter, Tools, Uncategorized
Thanks to reader EricEJ I have added an extension method to SqlCommandFilters which means instead of coding the call like this [csharp] // Explicit usage SqlCommandFilters.Parameters.Parameterize(ref cmd); // you can now call it like this // Extension method on...
by bobtaylor29708 | Sep 8, 2016 | boB 'The Tool Man' Taylor, Connect to SQL Server, SQL Server 2016, SQL Server Tools, Tools
Just a quick note to let everyone know that the code has been published on CodePlex Simply search for ConnectToSQL or go to the project’s home page at www.cts.codeplex.com
by bobtaylor29708 | Sep 7, 2016 | boB 'The Tool Man' Taylor, Connect to SQL Server, SQL Server 2016, SQL Server Tools, Tools
Today we will examine the code that connects to our database and showcases the code used to determine the correct Authentication method 1: Cursor current = Cursor.Current; 2: Cursor.Current = Cursors.WaitCursor; 3: // Create our connection information for use by the...
Recent Comments