01010100 01101000 01101001 01110011 00100000 01100010 01101100 01101111 01100111 00100000 01101001 01110011 00100000 01101101
01101111 01110011 01110100 01101100 01111001 00100000 01100001 01100010 01101111 01110101 01110100 00100000 01100011 01101111
01100100 01100101 00101100 00100000 01100010 01110101 01110100 00100000 01100001 01101100 01110011 01101111 00100000 01100001
01100010 01101111 01110101 01110100 00100000 01101111 01110100 01101000 01100101 01110010 00100000 01110011 01110100 01110101
01100110 01100110 00100001 00100000 01001010 01101111 01110011 01101000 00100000 01110100 01101000 01100101 00100000 01000011
01101111 01100100 01100101 01110010 00101110 00100000 01010100 01101000 01101001 01110011 00100000 01100010 01101100 01101111
01100111 00100000 01101001 01110011 00100000 01101101 01101111 01110011 01110100 01101100 01111001 00100000 01100001 01100010
01101111 01110101 01110100 00100000 01100011 01101111 01100100 01100101 00101100 00100000 01100010 01110101 01110100 00100000
01100001 01101100 01110011 01101111 00100000 01100001 01100010 01101111 01110101 01110100 00100000 01101111 01110100 01101000
01100101 01110010 00100000 01110011 01110100 01110101 01100110 01100110 00100001 00100000 01001010 01101111 01110011 01101000
00100000 01110100 01101000 01100101 00100000 01000011 01101111 01100100 01100101 01110010 00101110 00100000

; int add(int a, int b)   [x86-64]
0000  55          push rbp
0001  48 89 e5    mov  rbp, rsp
0004  89 7d fc    mov  DWORD PTR [rbp-4], edi
0007  89 75 f8    mov  DWORD PTR [rbp-8], esi
000a  8b 55 fc    mov  edx, DWORD PTR [rbp-4]
000d  8b 45 f8    mov  eax, DWORD PTR [rbp-8]
0010  01 d0       add  eax, edx
0012  5d          pop  rbp
0013  c3          ret

/* the same idea, in C */
#include <stdio.h>

int add(int a, int b) {
    return a + b;
}

int main(void) {
    printf("%d\n", add(2, 3));
    return 0;
}

// the same idea, in C#
using System;

public static class Program
{
    static int Add(int a, int b) => a + b;

    public static void Main()
    {
        Console.WriteLine(Add(2, 3));
    }
}

-- and finally, T-SQL
CREATE FUNCTION dbo.Add (@a INT, @b INT)
RETURNS INT
AS
BEGIN
    RETURN @a + @b;
END;
GO

SELECT dbo.Add(2, 3) AS Result;

/* archive */

Archive

2023

Dec 1, 2023 Sneaky async void Leads to ASP.NET Core Crash Debugging
Oct 23, 2023 Using PerfView to Diagnose High CPU in an ASP.NET App Debugging

2022

Nov 8, 2022 What Makes Production Code? Other Stuff
Jul 11, 2022 Putting Files in a Database Database Design
Apr 19, 2022 ORM Queries: Too Many Includes ORM Queries
Feb 6, 2022 Avoid SQL Injection with EF Raw Queries .NET

2021

Oct 26, 2021 Preventable MARS Connection Leaks .NET
Apr 7, 2021 AG Routing Problems Availability Groups
Mar 17, 2021 My Session at New Stars of Data 2021 Talks
Jan 25, 2021 ORM Queries: Too Many Roundtrips ORM Queries

2020

Nov 10, 2020 Migrating datetime to datetimeoffset Database Design
Sep 11, 2020 Confusion When Not Specifying Nullability Database Design
Aug 27, 2020 Unusual THREADPOOL Waits Internals
Jul 27, 2020 TransactionScope Considered Annoying .NET
Jun 22, 2020 A Bug with AG Health Checks Availability Groups
Jun 15, 2020 RESOURCE_GOVERNOR_IDLE in Azure Azure
May 21, 2020 Prevent Unexpected Failovers When Patching AGs Availability Groups
May 5, 2020 My (Mostly Technical) Podcast Recommendations Other Stuff
Apr 28, 2020 Max Data Types in ASP.NET Core Identity Schema Database Design
Apr 7, 2020 Extract Numbers from a String using SQLCLR .NET
Mar 23, 2020 SQL Server Options in Azure Azure

2019

Dec 18, 2019 Invisible tempdb Killer tempdb
Dec 16, 2019 Some Thoughts on Using WinDbg Debugging
Sep 17, 2019 Version Store Usage for ONLINE Column Operations tempdb
Aug 21, 2019 Analyzing Estimates from the CSelCalcAscendingKeyFilter Calculator Query Performance
Jul 17, 2019 Can You Fail To Spill To tempdb? tempdb
Jun 26, 2019 A Year of Learning and Helping Other Stuff
Jun 5, 2019 Transactions Don't Start At BEGIN TRAN Internals
May 27, 2019 Stats I/O: Not as Precise as You Think Query Performance
May 22, 2019 SQL Saturday Atlanta in Review Talks
May 19, 2019 A Parallel Nested Loops Join Optimization Query Performance
May 6, 2019 CXCONSUMER As a Sign of Slow Parallel Joins Query Performance
Apr 29, 2019 ORM Queries: Premature Materialization (Part 3) ORM Queries
Apr 24, 2019 ORM Queries: Premature Materialization (Part 2) ORM Queries
Apr 23, 2019 ORM Queries: Premature Materialization (Part 1) ORM Queries
Apr 14, 2019 ORM Queries: Problematic Lazy Loading ORM Queries
Feb 14, 2019 ORM Queries: SELECTing All Columns ORM Queries
Feb 12, 2019 ORM Queries: Too Much NULL Checking ORM Queries
Jan 26, 2019 Writes During SELECT Queries - Auto Stats Update Query Performance

2018

Dec 19, 2018 What Does the sql_exit_invoked XE Mean? Internals
Dec 13, 2018 The Case of the Missing Predicate Query Performance
Dec 6, 2018 Timing of the Automatic Query Store Purge Query Store
Dec 3, 2018 Troubleshooting an AG Failure Availability Groups
Nov 22, 2018 Manually Clearing the Query Store Query Store
Aug 14, 2018 SSDT problems: Table Rebuilds SSDT Problems
Jul 12, 2018 SSDT problems: Deploying the Same Change Over and Over SSDT Problems
Jul 5, 2018 Mysterious Parallel Deadlock Deadlocks
Jun 29, 2018 Locks on System Tables Deadlocks
Jun 21, 2018 Feature Request: Explain Why Indexes Were Skipped Query Performance
May 10, 2018 Deadlock Victim Choice in SQL Server - An Exception? Deadlocks

2017

Jul 25, 2017 Setting Up a New Blog with Jekyll on Windows Other Stuff