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