Sean Drew articles - 42 total
Dynamic API Dispatching in C#
A flexible way to handle changing JSON inputs without messy "if" or "switch" statements When...
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...
Customizing Output Caching in ASP.NET Web Forms and C# APIs
Efficient performance is essential for responsive, scalable web applications and one way to achieve...
Filtering and Exporting SQL Stored Procedures with PowerShell
When managing SQL Server stored procedures, there are times when I need to quickly generate scripts...
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,...
Centralizing SQL Connection Handling with a DatabaseHelper Class
For applications that rely on SQL Server connectivity for real-time data processing and high-volume...
Launching Executables and Switching Focus in Delphi
I am currently using Delphi to provide support, implement enhancements, and resolve bugs in legacy...
Automating Multi-Channel Client Notifications with a Custom Windows Service
My development of this Windows service stemmed from the need to automate and simplify client...
Dynamically Extracting Endpoint Names and Attributes from a Custom C# MVC API
Recently, I was asked whether a specific custom API endpoint functionality existed for a client....
File Comparison Made Easy: Detecting New and Changed Files with PowerShell
Recently, I was tasked with comparing two directory structures of two different project versions and...
DevExpress - Simplifying Server-to-Client Data Transfer with ASPxCallback JSProperties
When building interactive ASP.NET web applications with DevExpress controls, it is common to...
DevExpress - Enhancing ASP.NET Web Forms with the ASPxGridView Control
The DevExpress "ASPxGridView" control is a server-side control that allows you to display data from a...
Working with Matter Team Membership Using the IntApp Walls API
The IntApp Walls API is a powerful tool for managing ethical walls and securely controlling access to...
Understanding SQL Transactions: Implicit vs Explicit and the nuances of transaction management in SQL Server
In SQL, transactions are essential for ensuring data integrity, consistency, and reliability during...
Consuming and Processing JSON Stream Data in an API Webhook using C#
Recently, I was tasked with developing a custom webhook for our API that would consume a specific...
Understanding the Dictionary<TKey, TValue> Class at a Glance
Dictionary<TKey, TValue> is a collection in C# and a class that derives from the System.Object,...
Mastering List<KeyValuePair<TKey, TValue>> in C#: Practical Use Cases and Examples
In C#, List<KeyValuePair<TKey, TValue>> is a versatile collection type used to store...
PowerShell Script Collection: Automation and Solutions for Everyday Tasks
Over the years, PowerShell has proven to be an invaluable tool in simplifying complex administrative...
Handling URL Parameters in C# Across Application Types
Handling URL parameters is a common task in web and console applications, as they often carry...
Simplifying Workflow Execution with Action Mapping in C#
Efficiently managing workflows in code is essential for maintainability and readability, particularly...
Redirects Made Simple in ASP.NET MVC: Using RedirectToAction
In ASP.NET MVC, efficiently redirecting user requests between actions and controllers is crucial for...
Simplifying Multiple Condition Checks in C# ForEach Loops
Occasionally, you may need to iterate over collections and evaluate various conditions for each...
A Brief Guide to Implementing Pagination in a C# Endpoint
Pagination is a crucial feature in APIs that deal with large datasets, ensuring efficient data...
High-Level Glossary of Essential API Terms for Developers
This high-level glossary offers a very brief overview of the most commonly used terms and concepts in...
Efficient Temporary Storage in SQL: Ditching Cursors for Table Variables
(A Limited-Scope Solution to Replace SQL Cursors) Using a table variable is an excellent alternative...
From Chaos to Clarity: A Journey Through Random SQL Code: Practical Examples for Developers
In SQL development, we often encounter recurring challenges that can be addressed with small,...
SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases
Effective database management relies on having the right tools to streamline tasks and ensure optimal...
Easily Display Record Counts in SQL Server Using COUNT(*) OVER()
The SQL COUNT(*) OVER () analytic function is a powerful tool that allows you to include a total...
Enhancing Time Zone-Sensitive Business Engagement: SQL Logic for Business Hour Validation by Time Zone
In the context of Patient SMS, Voice, and Email engagement, I was responsible for ensuring that...
Boosting SQL Query Flexibility with CROSS APPLY
CROSS APPLY is useful SQL operator that lets you look up related information for each row in a table....