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 ...

🎯 What is TSQL.APP? TSQL.APP is an innovative web application framework that enables developers to build complete business applications using primarily T-SQL and SQL Server. It represents a paradigm ...

So it came up that several of our devs are writing their TSQL entirely in code using ADO.NET and submitting their queries that way.<BR><BR>Initially the idea was sprocs for all inserts, updates, etc..

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...