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 plan on sharing soon here on boB ‘The Tool Man’ Taylor blog.

1. Connect To SQL = Have you ever wanted to be able to connect to a SQL Server from your C# application? I will be releasing the source code for a customizable Connect To SQL Server dialog that you can use in your C# projects. Simply over-ride one method, and provide an icon and bitmap in the derived constructor and voila! you have a connection dialog that supports Windows Authentication, SQL Server Authentication, Active Directory Integrated and Active Directory Password authentication mechanisms.

 

ConnectToSQL

 

2. SqlCommandFilters -Do you consume a lot of dynamic SQL generated from  web page inputs? Worried about SQL Injection? Or are you using the new Always Encrypted and need to have your SqlCommand text parameterized? Then watch for SqlCommandFilters – as simple as one static method call and your command test is now fully parameterized and re-written.

Please let me know if this will be useful to you… It leverages the Microsoft.SqlServer.TransactSql.ScriptDom  and is very cool…

SqlCommandFilter usage

 

3. Teaser -  This one may or may not get published here… I am working with the Product Group on a new technology that will allow you to emulate CDC on SQL Azure Database! If this is interesting to you please drop me a line and let me know. The more interest there is, the more I can push to get this into the product!