#sql

Articles tagged with #sql

SQL Server Stored Procedure Design for Flexible Record Lookup
Using CTEs and JSON to Support Multiple Matching Strategies
Jul 10, 20255 min read34
Identifying Stored Procedures Created or Modified Within a Date Range in SQL Server
As part of rewriting the documentation for my custom API, I needed to test each endpoint to ensure it behaved as expected, including validating both input and output. During this process, I discovered that several existing stored procedures required ...
Jun 18, 20253 min read42
Filtering and Exporting SQL Stored Procedures with PowerShell
When managing SQL Server stored procedures, there are times when I need to quickly generate scripts for them, usually for backups, migrations, a specific client or functionality, or documentation. In this document, I show how I use T-SQL and PowerShe...
Mar 25, 20255 min read13
Some Random SQL Error Handling Techniques for Reliability and Transactional Integrity
Error handling is an important part of writing SQL code. Whether working with stored procedures, triggers, or transactions, proper error handling ensures that database operations remain reliable, maintainable, and capable of handling unexpected situa...
Feb 24, 20259 min read14
Understanding SQL Transactions: Implicit vs Explicit
And the nuances of transaction management in SQL Server
Dec 27, 20245 min read57
SQL Admin Scripts
A Practical Toolkit for Managing Servers and Databases
Dec 17, 202411 min read16