Sean Drew - DEV Community

Sean Drew

Aug 19

Writing C# Code Like a Klingon

#csharp

1

4 min read

Sean Drew

Jul 30

Designing a SOLID, Layered ASP.NET Core Solution for Patient Lookup

#csharp

1

7 min read

Sean Drew

Jul 16

Refactoring Repetitive Model Validation in ASP.NET Core

4 min read

Sean Drew

Jul 14

Transitioning to JSON: Supporting Both Body and Query Parameters in ASP.NET Core

8 min read

Sean Drew

Jul 10

SQL Server Stored Procedure Design for Flexible Record Lookup

#sql

2

4

5 min read

Sean Drew

Jun 24

Dynamic API Dispatching in C#

#csharp #api

3

4

5 min read

Sean Drew

Jun 18

Identifying Stored Procedures Created or Modified Within a Date Range in SQL Server

#sqlserver #sql

1

2

2 min read

Sean Drew

May 30

Customizing Output Caching in ASP.NET Web Forms and C# APIs

#csharp #c #aspnet #dotnet

5 min read

Sean Drew

Mar 25

Filtering and Exporting SQL Stored Procedures with PowerShell

#sql #sqlserver #powershell

4 min read

Sean Drew

Feb 24

Some Random SQL Error Handling Techniques for Reliability and Transactional Integrity

#sql #sqlserver

7 min read

Sean Drew

Feb 11

Centralizing SQL Connection Handling with a DatabaseHelper Class

#aspnet #csharp #sqlserver

1

4 min read

Sean Drew

Jan 21

Launching Executables and Switching Focus in Delphi

#delphi #pascal

3

4 min read

Sean Drew

Jan 17

Automating Multi-Channel Client Notifications with a Custom Windows Service

8 min read

Sean Drew

Jan 15

Dynamically Extracting Endpoint Names and Attributes from a Custom C# MVC API

#api #csharp #mvc

1

6 min read

Sean Drew

Jan 9

File Comparison Made Easy: Detecting New and Changed Files with PowerShell

#powershell

1

3 min read

Sean Drew

Jan 6

DevExpress - Simplifying Server-to-Client Data Transfer with ASPxCallback JSProperties

#aspnet #aspdotnet #devexpress #csharp

1

4 min read

Sean Drew

Jan 4

DevExpress - Enhancing ASP.NET Web Forms with the ASPxGridView Control

#aspnet #aspdotnet #devexpress

6 min read

Sean Drew

Jan 1

Working with Matter Team Membership Using the IntApp Walls API

#c #intapp #csharp

1

6 min read

Sean Drew

Dec 27 '24

Understanding SQL Transactions: Implicit vs Explicit and the nuances of transaction management in SQL Server

#sql #sqlserver

1

5 min read

Sean Drew

Dec 26 '24

Consuming and Processing JSON Stream Data in an API Webhook using C#

#csharp #api #json

1

14 min read

Sean Drew

Dec 18 '24

Understanding the Dictionary<TKey, TValue> Class at a Glance

3 min read

Sean Drew

Dec 18 '24

Mastering List<KeyValuePair<TKey, TValue>> in C#: Practical Use Cases and Examples

#csharp

2

4 min read

Sean Drew

Dec 13 '24

PowerShell Script Collection: Automation and Solutions for Everyday Tasks

#powershell

2

7 min read

Sean Drew

Dec 12 '24

Handling URL Parameters in C# Across Application Types

#api #mvc #web

3 min read

Sean Drew

Dec 11 '24

Simplifying Workflow Execution with Action Mapping in C#

#csharp

3 min read

Sean Drew

Dec 11 '24

Redirects Made Simple in ASP.NET MVC: Using RedirectToAction

#mvc #csharp

2

2 min read

Sean Drew

Dec 10 '24

Simplifying Multiple Condition Checks in C# ForEach Loops

#csharp

3 min read

Sean Drew

Dec 10 '24

A Brief Guide to Implementing Pagination in a C# Endpoint

#api #csharp #sqlserver

2 min read

Sean Drew

Dec 10 '24

High-Level Glossary of Essential API Terms for Developers

#api

1

3 min read

Sean Drew

Dec 9 '24

Efficient Temporary Storage in SQL: Ditching Cursors for Table Variables

#sql #sqlserver

3 min read

Sean Drew

Dec 9 '24

From Chaos to Clarity: A Journey Through Random SQL Code: Practical Examples for Developers

#sql #sqlserver

14 min read

Sean Drew

Dec 9 '24

SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases

#sql #sqlserver

7

9 min read

Sean Drew

Dec 9 '24

Easily Display Record Counts in SQL Server Using COUNT(*) OVER()

#sql #sqlserver

3 min read

Sean Drew

Dec 9 '24

Enhancing Time Zone-Sensitive Business Engagement: SQL Logic for Business Hour Validation by Time Zone

#sql #sqlserver

7 min read

Sean Drew

Dec 9 '24

Boosting SQL Query Flexibility with CROSS APPLY

#sql #sqlserver

2 min read

Sean Drew

Dec 9 '24

Transforming Nested JSON into Usable Data with SQL CROSS APPLY

#sql #sqlserver

1

3 min read

Sean Drew

Dec 8 '24

Handling Recipient SMS Replies with Twilio and .NET

#twilio #csharp #api

2 min read

Sean Drew

Dec 8 '24

Gathering Keypad Input in Voice Calls with Twilio and .NET

#twilio #csharp #api

3 min read

Sean Drew

Dec 8 '24

Sending Voice Messages with Twilio and .NET

#twilio #csharp #dotnet

1

3 min read

Sean Drew

Dec 8 '24

Sending SMS with Twilio and .NET

#twilio #csharp #dotnet

1

2 min read

Sean Drew

Dec 8 '24

Defining and Using Classes in C#: A Simple Guide to Object Collections

#csharp #dotnet #classes

4 min read

Sean Drew

Dec 8 '24

Securing Data in SQL Tables Using Master Key, Asymmetric Key, and Symmetric Key

#sql #sqlserver

4 min read

Sean Drew

Dec 8 '24

Asynchronous Data Retrieval with SQL Stored Procedures in C#

#sql #sqlserver #csharp

3 min read

Sean Drew

Dec 8 '24

Isolation Levels In SQL: A Brief Overview

#sql #sqlserver

2 min read

Sean Drew

Dec 8 '24

Securing a REST API with JWT Authentication in C# Using AES-Encrypted Keys

#restapi #jwt #csharp #aes

4 min read

Sean Drew

Dec 8 '24

Passing an Array of Items to a SQL Stored Procedure Using XML from C#

#csharp #xml #sql #sqlserver

2 min read

Sean Drew

Dec 8 '24

Efficient Data Exchange: Leveraging SQL JSON Results with C#

#sql #sqlserver #json

4 min read

Writing Debut

Want to connect with Sean Drew?