SqlCommandFilters–a tool for every toolbox

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 currently parameterized You have a web application that builds all SQL input from elements on…


Connect To SQL… a utility for C# programmers

You are writing a tool for SQL programmers by using C#, SQL Management Objects etc. You need to connect to a SQL Server instance and so you need to code a way to ask for the Server name, user credentials and so on. Why rewrite it each and every time? Simply add boB ‘The Tool…


It’s been awhile…

I have started a new role as a Data Platform Solution Architect in the Health and Life Sciences vertical at Microsoft. Its been hectic, but fun. I am finally getting a bit of time to work on some projects that have been on the back burner for a while. I have several series that I…


CSI: Replication–the mysterious vanishing row

I have been working with a customer on an interesting situation. On occasion they have replication issues. Examining the error we see many errors that state: The row was not found at the Subscriber when applying the replicated command So we need to understand why the row was not found. (cue TV show music)…. CSI:…


Registration for Advanced Certification Programs is easier than ever!

The Advanced Certification team at Microsoft is pleased to announce a new,streamlined registration process for individuals applying for the MicrosoftCertified Master (MCM) or Microsoft Certified Architect (MCA) trainingprograms. In an ongoing effort to improve your overall registration experience, theAdvanced Certification team at Microsoft is transitioning our currently hostedregistration portal to a new system managed exclusively…


Episode 2 Now Live!

The second episode of the web reality show Be the Next Microsoft Employee  #bethenext is now live! Check it out here…. http://www.microsoft.com/learning/en/us/certification/bethenext.aspx There are several other suppliemental videos here: (Two magic tricks and one interview) The interview https://www.youtube.com/watch?v=EX01IjM1B7Y&feature=youtu.be   Links to my magic stuff http://borntolearn.mslearn.net/btl/b/bethenext/archive/2012/07/27/bob-taylor-making-magic-on-be-the-next.aspx https://www.youtube.com/watch?v=Fx8v-a46Z6Q&list=PLD5747260918AE95C&index=11&feature=plpp_video https://www.youtube.com/watch?v=Ekj0XTIEHPI&list=PLD5747260918AE95C&index=12&feature=plpp_video      


Guest Judge For Be The Next Microsoft Employee

I’m a guest judge on new reality show, #bethenext Microsoft Employee, for a #SQLserver challenge! Sneak-peek: aka.ms/bethenext


Tech Ed 2012 – A 20th Anniversary Celebration. Wish you were here!

Tech Ed has been wonderful this year, a chance to meet up with old friends, make new old friends and talk about SQL Server. My session DBI410 – SQL Power Tools: Enhance Your Effectiveness with Extended Events was well attended with much interest and great questions. Thanks to those of you who attended. Please be…


Its been a while for a new tool…

Watch for the announcement at Tech Ed and Tech Ed Europe! The new tool will be named SQLPie. I would love to hear thoughts on what it might be boB


I have contributed to two new upcomgin MSPress Titles

I was the technical reviewer for William Stanek’s SQL Server 2012 Administrator’s Pocket Consultant I am currently the techmical reviewer fpr tje Tranining Kit for Exam 70-462 Administering Microsoft SQL Server 2012 Database. Due to an illnes I am also now an author for this title. Be sure to check them out when they are available.