Month: May 2020

How to create and fire a SQL Server Trigger

When implemented correctly, SQL Server Triggers are a powerful mechanism for adding useful functionality to a database without the need to change any application code. In this article, I look at what a SQL Server Trigger is, a template for defining a new Trigger and possible use cases. A few facts You may already be…

Protecting access to gRPC services with Auth0

InAPIs

Having already introduced the concept of gRPC services and having walked through how to consume a gRPC service using .NET Core, I’m now going to cover the next most fundamental topics; authentication and authorization. For production applications, your API endpoints are normally going to be available publicly and therefore they need to be protected from…

Month: May 2020

How to create and fire a SQL Server Trigger

Protecting access to gRPC services with Auth0

How to print SQL Server messages to the output immediately

Introduction to the SQL Server MERGE statement

Operating on data via a SQL Server Stored Procedure efficiently with Table-Valued Parameters using C#