by bobtaylor29708 | Jul 9, 2018 | boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Security, SQL Server 2016, SQL Server 2017, SQL Snacks™
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....
by bobtaylor29708 | Jul 2, 2018 | Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Tools, SQL Snacks™
This week’s SQL Snacks™ we will examine the available target types. As we have discussed in previous SQL Snacks™ targets are how the Extended Event system provides us output to examine. In the next series of SQL Snacks™ we will look at each individual target and...
by bobtaylor29708 | Jun 25, 2018 | boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Tools, SQL Snacks™
This week’s SQL Snacks™ is so nutritionally dense, I had to split it into two parts. (Actually MSDN limits size of media to 40MB). Next week’s SQL Snacks™ will focus on all of the various target types – and will point out the major differences...
by bobtaylor29708 | Jun 18, 2018 | boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Tools, SQL Snacks™, Uncategorized
In this SQL Snacks™ we will examine the architecture of the Extended Events system in SQL Server. In subsequent SQL Snacks™ we will examine the UI in SSMS as well as Transact-SQL scripts to analyze XEvents....
by bobtaylor29708 | Jun 11, 2018 | boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Snacks™
In this first ever SQL Meals™ we will start with an introduction to the Extended Events system in SQL Server. In subsequent SQL Snacks™ we will examine the architecture, the User Interface in SQL Server Management Studio, and specific use cases for Extended Events....
by bobtaylor29708 | Jun 11, 2018 | Uncategorized
In this first ever SQL Meals™ we will start with an introduction to the Query Data Store – SQL Server’s Easy Button. In subsequent SQL Snacks™ we will examine specific use cases that are enhanced by using Query Data Store. The next item on the menu will be...
by bobtaylor29708 | Jun 7, 2018 | boB 'The Tool Man' Taylor, Query Data Store, SQL Server 2016, SQL Server 2017, SQL Server Tools
As part of my new role in the Cross Domain Delivery test team I have been asked to create a video series that will focus on features of SQL Server that would be useful for test engagements. These will be categorized as either SQL Meals™ which will be around an hour...
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...
by bobtaylor29708 | Aug 24, 2016 | Always Encrypted, boB 'The Tool Man' Taylor, SQL Injection, SQL Security, SQL Server 2016, SqlCommandFilter, Tools
SqlCommandFilters is a utility assembly that will automatically parse your SqlCommand.CommandText and parameterize it for you. Why would you want to do this? Picture this You want to leverage SQL Server Always Encrypted, but you your queries are not...
Recent Comments