Skip to content

SQL Server According to Bob

Two guys who work on SQL Server

Search:

Docker
How It Works
Linux
Locking and Latching
Networking
SQL 2016
SQL 2019
SQL Server 2017
SQL Server BDC Hints and Tips
SQL Server Mysteries
Uncategorized

Docker

screen-shot-2018-04-23-at-2-09-35-pm-300x188-3

Take the SQL Server Mac challenge

When I graduated from college, one of the first computers I ever used was

Docker

Search

SQL Server Mysteries: The Case of TDE and Permanent Tempdb Encryption

SQL Server Mysteries

COUNTIF Function in SQL ⬅️➡️ SQL Server Way for Count Aggregate

How It Works

SQL Server on Linux: CU4 – NewSequentialId() – Uuid

Linux

SQL Server BDC Hints and Tips: Contained AGs, Ports, containedag_msdb, logs, …

How It Works

Unresolved Deadlock vs Scheduler Deadlock

Locking and Latching

SQL MYSTERIES: Tracing BCP Might Fool You

How It Works

Create Table – Disk vs In-Memory Optimized

SQL 2016

SQL Server for Linux Performance Monitoring Improvements

Linux

How It Works: SQL Server 2016 SSE/AVX Support

How It Works

How It Works: TSQL TRY/CATCH Behavior Fooled Me

How It Works

Negative Blocking Session Ids (-5 = Latch ANY TASK RELEASOR)

Uncategorized

SQL 2016 – It Just Runs Faster: TVPs with Spatial Column(s)

SQL 2016

SQL Server 🔎 Check if a String Contains a Substring

How It Works

SQL Server on Linux: Why Do I Have Two SQL Server Processes

Linux

SQL Server Linux: fsync and Buffered I/O

How It Works

© 2023 bobsql.com