Working with dynamic SQL is all well and good, but avoid the risks that can lead to your code being susceptible to a SQL injection attack. As much as making your T-SQL work smarter for you, a la ...

In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...

Develop complex T-SQL queries, Stored Procedures, and Triggers. Assist in the design of the relational database architecture for new development projects. Develop new / alter existing SQL objects ...