Sean Drew

Application Developer/Architect @ Maxor National Pharmacy Services

Boston Joined on Dec 8, 2024 http://www.seandrew.info

Cover image for Writing C# Code Like a Klingon

Sean Drew

Aug 19

Writing C# Code Like a Klingon

#csharp

4 min read

Want to connect with Sean Drew?

Create an account to connect with Sean Drew. You can also sign in below to proceed if you already have an account.

Create Account

Already have an account? Sign in

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

Sean Drew

Jul 30

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

#csharp

7 min read

Cover image for Refactoring Repetitive Model Validation in ASP.NET Core

Sean Drew

Jul 16

Refactoring Repetitive Model Validation in ASP.NET Core

4 min read

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

Sean Drew

Jul 14

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

8 min read

Cover image for SQL Server Stored Procedure Design for Flexible Record Lookup

Sean Drew

Jul 10

SQL Server Stored Procedure Design for Flexible Record Lookup

#sql

5 min read

Cover image for Dynamic API Dispatching in C#

Sean Drew

Jun 24

Dynamic API Dispatching in C#

#csharp #api

5 min read

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

Sean Drew

Jun 18

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

#sqlserver #sql

2 min read

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

Sean Drew

May 30

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

#csharp #c #aspnet #dotnet

5 min read

Cover image for Filtering and Exporting SQL Stored Procedures with PowerShell

Sean Drew

Mar 25

Filtering and Exporting SQL Stored Procedures with PowerShell

#sql #sqlserver #powershell

4 min read

Cover image for Some Random SQL Error Handling Techniques for Reliability and Transactional Integrity

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

4 min read

Cover image for Launching Executables and Switching Focus in Delphi

Sean Drew

Jan 21

Launching Executables and Switching Focus in Delphi

#delphi #pascal

4 min read

Cover image for Automating Multi-Channel Client Notifications with a Custom Windows Service

Sean Drew

Jan 17

Automating Multi-Channel Client Notifications with a Custom Windows Service

8 min read

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

Sean Drew

Jan 15

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

#api #csharp #mvc

6 min read

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

Sean Drew

Jan 9

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

#powershell

3 min read

Cover image for DevExpress - Simplifying Server-to-Client Data Transfer with ASPxCallback JSProperties

Sean Drew

Jan 6

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

#aspnet #aspdotnet #devexpress #csharp

4 min read

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

Sean Drew

Jan 4

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

#aspnet #aspdotnet #devexpress

6 min read

Cover image for Working with Matter Team Membership Using the IntApp Walls API

Sean Drew

Jan 1

Working with Matter Team Membership Using the IntApp Walls API

#c #intapp #csharp

6 min read

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

Sean Drew

Dec 27 '24

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

#sql #sqlserver

5 min read

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

Sean Drew

Dec 26 '24

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

#csharp #api #json

14 min read

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

Sean Drew

Dec 18 '24

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

3 min read

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

Sean Drew

Dec 18 '24

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

#csharp

4 min read

Cover image for PowerShell Script Collection: Automation and Solutions for Everyday Tasks

Sean Drew

Dec 13 '24

PowerShell Script Collection: Automation and Solutions for Everyday Tasks

#powershell

7 min read

Cover image for Handling URL Parameters in C# Across Application Types

Sean Drew

Dec 12 '24

Handling URL Parameters in C# Across Application Types

#api #mvc #web

3 min read

Cover image for Simplifying Workflow Execution with Action Mapping in C#

Sean Drew

Dec 11 '24

Simplifying Workflow Execution with Action Mapping in C#

#csharp

3 min read

Cover image for Redirects Made Simple in ASP.NET MVC: Using RedirectToAction

Sean Drew

Dec 11 '24

Redirects Made Simple in ASP.NET MVC: Using RedirectToAction

#mvc #csharp

2 min read

Cover image for Simplifying Multiple Condition Checks in C# ForEach Loops

Sean Drew

Dec 10 '24

Simplifying Multiple Condition Checks in C# ForEach Loops

#csharp

3 min read

Cover image for A Brief Guide to Implementing Pagination in a C# Endpoint

Sean Drew

Dec 10 '24

A Brief Guide to Implementing Pagination in a C# Endpoint

#api #csharp #sqlserver

2 min read

Cover image for High-Level Glossary of Essential API Terms for Developers

Sean Drew

Dec 10 '24

High-Level Glossary of Essential API Terms for Developers

#api

3 min read

Cover image for Efficient Temporary Storage in SQL: Ditching Cursors for Table Variables

Sean Drew

Dec 9 '24

Efficient Temporary Storage in SQL: Ditching Cursors for Table Variables

#sql #sqlserver

3 min read

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

Sean Drew

Dec 9 '24

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

#sql #sqlserver

14 min read

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

Sean Drew

Dec 9 '24

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

#sql #sqlserver

9 min read

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

Sean Drew

Dec 9 '24

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

#sql #sqlserver

3 min read

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

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

Cover image for Boosting SQL Query Flexibility with CROSS APPLY

Sean Drew

Dec 9 '24

Boosting SQL Query Flexibility with CROSS APPLY

#sql #sqlserver

2 min read

Cover image for Transforming Nested JSON into Usable Data with SQL CROSS APPLY

Sean Drew

Dec 9 '24

Transforming Nested JSON into Usable Data with SQL CROSS APPLY

#sql #sqlserver

3 min read

Cover image for Handling Recipient SMS Replies with Twilio and .NET

Sean Drew

Dec 8 '24

Handling Recipient SMS Replies with Twilio and .NET

#twilio #csharp #api

2 min read

Cover image for Gathering Keypad Input in Voice Calls with Twilio and .NET

Sean Drew

Dec 8 '24

Gathering Keypad Input in Voice Calls with Twilio and .NET

#twilio #csharp #api

3 min read

Cover image for Sending Voice Messages with Twilio and .NET

Sean Drew

Dec 8 '24

Sending Voice Messages with Twilio and .NET

#twilio #csharp #dotnet

3 min read

Cover image for Sending SMS with Twilio and .NET

Sean Drew

Dec 8 '24

Sending SMS with Twilio and .NET

#twilio #csharp #dotnet

2 min read

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

Sean Drew

Dec 8 '24

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

#csharp #dotnet #classes

4 min read

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

Sean Drew

Dec 8 '24

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

#sql #sqlserver

4 min read

Cover image for Asynchronous Data Retrieval with SQL Stored Procedures in C#

Sean Drew

Dec 8 '24

Asynchronous Data Retrieval with SQL Stored Procedures in C#

#sql #sqlserver #csharp

3 min read

Cover image for Isolation Levels In SQL: A Brief Overview

Sean Drew

Dec 8 '24

Isolation Levels In SQL: A Brief Overview

#sql #sqlserver

2 min read

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

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

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

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

Cover image for Efficient Data Exchange: Leveraging SQL JSON Results with C#

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?