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;

/* topics */

Topics

.NET

Feb 6, 2022 Avoid SQL Injection with EF Raw Queries
Oct 26, 2021 Preventable MARS Connection Leaks
Jul 27, 2020 TransactionScope Considered Annoying
Apr 7, 2020 Extract Numbers from a String using SQLCLR

Availability Groups

Apr 7, 2021 AG Routing Problems
Jun 22, 2020 A Bug with AG Health Checks
May 21, 2020 Prevent Unexpected Failovers When Patching AGs
Dec 3, 2018 Troubleshooting an AG Failure

Azure

Jun 15, 2020 RESOURCE_GOVERNOR_IDLE in Azure
Mar 23, 2020 SQL Server Options in Azure

Database Design

Jul 11, 2022 Putting Files in a Database
Nov 10, 2020 Migrating datetime to datetimeoffset
Sep 11, 2020 Confusion When Not Specifying Nullability
Apr 28, 2020 Max Data Types in ASP.NET Core Identity Schema

Deadlocks

Jul 5, 2018 Mysterious Parallel Deadlock
Jun 29, 2018 Locks on System Tables
May 10, 2018 Deadlock Victim Choice in SQL Server - An Exception?

Debugging

Dec 1, 2023 Sneaky async void Leads to ASP.NET Core Crash
Oct 23, 2023 Using PerfView to Diagnose High CPU in an ASP.NET App
Dec 16, 2019 Some Thoughts on Using WinDbg

Internals

Aug 27, 2020 Unusual THREADPOOL Waits
Jun 5, 2019 Transactions Don't Start At BEGIN TRAN
Dec 19, 2018 What Does the sql_exit_invoked XE Mean?

ORM Queries

Apr 19, 2022 ORM Queries: Too Many Includes
Jan 25, 2021 ORM Queries: Too Many Roundtrips
Apr 29, 2019 ORM Queries: Premature Materialization (Part 3)
Apr 24, 2019 ORM Queries: Premature Materialization (Part 2)
Apr 23, 2019 ORM Queries: Premature Materialization (Part 1)
Apr 14, 2019 ORM Queries: Problematic Lazy Loading
Feb 14, 2019 ORM Queries: SELECTing All Columns
Feb 12, 2019 ORM Queries: Too Much NULL Checking

Other Stuff

Nov 8, 2022 What Makes Production Code?
May 5, 2020 My (Mostly Technical) Podcast Recommendations
Jun 26, 2019 A Year of Learning and Helping
Jul 25, 2017 Setting Up a New Blog with Jekyll on Windows

Query Performance

Aug 21, 2019 Analyzing Estimates from the CSelCalcAscendingKeyFilter Calculator
May 27, 2019 Stats I/O: Not as Precise as You Think
May 19, 2019 A Parallel Nested Loops Join Optimization
May 6, 2019 CXCONSUMER As a Sign of Slow Parallel Joins
Jan 26, 2019 Writes During SELECT Queries - Auto Stats Update
Dec 13, 2018 The Case of the Missing Predicate
Jun 21, 2018 Feature Request: Explain Why Indexes Were Skipped

Query Store

Dec 6, 2018 Timing of the Automatic Query Store Purge
Nov 22, 2018 Manually Clearing the Query Store

SSDT Problems

Aug 14, 2018 SSDT problems: Table Rebuilds
Jul 12, 2018 SSDT problems: Deploying the Same Change Over and Over

Talks

Mar 17, 2021 My Session at New Stars of Data 2021
May 22, 2019 SQL Saturday Atlanta in Review

tempdb

Dec 18, 2019 Invisible tempdb Killer
Sep 17, 2019 Version Store Usage for ONLINE Column Operations
Jul 17, 2019 Can You Fail To Spill To tempdb?