Emulating GETDATE() on Azure SQL Database GETDATE() always uses the UTC time zone on Azure SQL Database which can be a compatibility issue for applications that assume that GETDATE() is using a different time zone....

a friday release! free sql performance monitoring for the people! lots of bug fixes and improvements in this one. as always, check the release notes and readme, and use github for questions, comments, concerns, and support: github.com/erikdarlingd...

reading and wondering why people are so mean to databases: learn.microsoft.com/en-us/sql/sq...

Get AI-Ready With Erik: A Little About Cross Table Searches Get AI-Ready With Erik: A Little About Cross Table Searches https://youtu.be/iSlJfLeQZNs Video Summary In this video, I delve into the exciting... https://erikdarling.com/get-ai-ready-with-erik-a-little-about-cross-table-searches/

you'd think that a file called readme would encourage people to read it. funny, that.

y'all wanna see a dead body? meta.stackoverflow.com/questions/43...

Get AI-Ready With Erik: A Little About Finding Related Content https://61f.985.myftpupload.com/get-ai-ready-with-erik-a-little-about-finding-related-content/

Get AI-Ready With Erik: A Little About Finding Related Content Get AI-Ready With Erik: A Little About Finding Related Content https://youtu.be/3epbC77nZKw Video Summary In this video, I delve into user... https://erikdarling.com/get-ai-ready-with-erik-a-little-about-finding-related-content/

they grow up so fast! hard to believe it's already been a week. 1500 downloads so far (thanks mom!) github.com/erikdarlingd...

Get AI-Ready With Erik: A Little About VECTOR_DISTANCE https://61f.985.myftpupload.com/get-ai-ready-with-erik-a-little-about-vector_distance/

Get AI-Ready With Erik: A Little About VECTOR_DISTANCE Get AI-Ready With Erik: A Little About VECTOR_DISTANCE https://youtu.be/PjGjAl3mNL4 Video Summary In this video, I discuss vector distance measures in the... https://erikdarling.com/get-ai-ready-with-erik-a-little-about-vector_distance/

Today's YouTube video will be a little late because of an ongoing partial electricity outage.

Get AI-Ready With Erik: A Little About Generating Embeddings Get AI-Ready With Erik: A Little About Generating Embeddings https://youtu.be/X8GR74avgWs Video Summary In this video, I dive into the world of... https://erikdarling.com/get-ai-ready-with-erik-a-little-about-generating-embeddings/

SQL Server Performance Office Hours Episode 48 SQL Server Performance Office Hours Episode 48 https://youtu.be/-4P_obO0q4A Hi Erik, Happy New Year! On my SQL Server production system, the top waits include CMEMTHREAD... https://erikdarling.com/sql-server-performance-office-hours-episode-48/

I had Claude work on some stuff while I took my wife on a date. We're not a thrup (officially). github.com/erikdarlingd...

Get AI-Ready With Erik: A Little More About Vector Types https://61f.985.myftpupload.com/get-ai-ready-with-erik-a-little-more-about-vector-types/

Add a DMV that explicitly lists preview features in current build feedback.azure.com/d365communit...

If you were waiting for CU1 before testing out my new free SQL Server monitoring tool, here it is: github.com/erikdarlingd...

Get AI-Ready With Erik: A Little More About Vector Types Get AI-Ready With Erik: A Little More About Vector Types https://youtu.be/KFzV4ltXaBA Video Summary In this video, I delve into the new vector types... https://erikdarling.com/get-ai-ready-with-erik-a-little-more-about-vector-types/

If you use SQL Prompt, be careful after updating to SSMS 22.3. The assembly version was changed from v17.100.0.0 to v18.100.0.0 and SSMS will hard crash if you try to connect Object Explorer because SQL Prompt has v17 hard coded. You can still connect query tabs without a crash, though.

Get AI-Ready With Erik: A Little About The StackOverflow Demo Database Get AI-Ready With Erik: A Little About The StackOverflow Demo Database https://youtu.be/uRwQ8Wnnag0 Video Summary In this... https://erikdarling.com/get-ai-ready-with-erik-a-little-about-the-stackoverflow-demo-database/

Announcing Free SQL Server Performance Monitoring That Doesn't Suck Announcing Free SQL Server Performance Monitoring I built a free, open-source SQL Server performance monitoring tool. Two editions, no licensing...

Get AI-Ready With Erik: A Little About Embeddings Get AI-Ready With Erik: A Little About Embeddings https://youtu.be/t3fBHXHSa8M Video Summary In this video, I dive into the world of embeddings and their importance in... https://erikdarling.com/get-ai-ready-with-erik-a-little-about-embeddings/

I am going to learn how to SQL with @erikdarling.com. Check out "Advanced T-SQL Triage: The Art of Fixing Terrible Code". A #DataSaturdayChicago Pre-Con Event! www.eventbrite.com/e/advanced-t...

Get AI-Ready With Erik: A Little About Vectors and Distances Get AI-Ready With Erik: A Little About Vectors and Distances https://youtu.be/WuJgexJvt1A Video Summary In this video, I dive into the exciting... https://erikdarling.com/get-ai-ready-with-erik-a-little-about-vectors-and-distances/

#DataSaturdayChicago is coming up sooner than we realize. Here’s @sqlbek.bsky.social‘s post about all the reasons you don’t want to miss it: sqlbek.wordpress.com/2026/02/09/d...

SQL Server Performance Office Hours Episode 47 SQL Server Performance Office Hours Episode 47 https://youtu.be/DQrdeI8_-Q8 I have a query that is timing out after 30 seconds and is mostly waiting on pagelatch_sh. It's a... https://erikdarling.com/sql-server-performance-office-hours-episode-47/

i'm testing out claude code for code review tasks. here's a release for all you crazy kids out there who like sizzling hot new robot code on a friday: github.com/erikdarlingd...

Column Store, Delta Store, and More Column Store, Delta Store, and More https://youtu.be/OPdFoK9Rutw Video Summary In this video, I delve into some fascinating aspects of columnstore indexes and the Delta store in SQL Server,... https://erikdarling.com/column-store-delta-store-and-more/

Merry Christmas from Santa and Definitely Not Erik Merry Christmas from Santa and Definitely Not Erik https://youtu.be/EIMFErSu9DQ Would you believe Erik Santa forgot to turn off this coupon? Going Further If this... https://erikdarling.com/merry-christmas-from-santa-and-definitely-not-erik-2/

More LOBs, More Locks (in SQL Server) More LOBs, More Locks (in SQL Server) https://youtu.be/GkpEug8U7DE Video Summary In this video, I delve into the intriguing world of large object (LOB) data and its impact on locking... https://erikdarling.com/more-lobs-more-locks-in-sql-server/

Query Store Hint and Plan Guide Annoyances in SQL Server Query Store Hint and Plan Guide Annoyances in SQL Server https://youtu.be/ABhwGX0zNfo Video Summary In this video, I delve into some of the frustrations... https://erikdarling.com/query-store-hint-and-plan-guide-annoyances-in-sql-server/

As of this morning, I am on the job market, #OpenToWork, or however that is designated here. 🙂 I’m immediately looking for a new position, and my DMs are open. Thanks network!

SQL Server Performance Office Hours Episode 46 SQL Server Performance Office Hours Episode 46 https://youtu.be/FOOiJ17T3E0 The missing index DMVs keep recommending the same index with 15+ included columns that would... https://erikdarling.com/sql-server-performance-office-hours-episode-46/

it's 5 on a friday which means it's time to file a bug report: developercommunity.visualstudio.com/t/Copying-an...

New Course: Get AI-Ready With Erik! New Course: Get AI-Ready With Erik! https://youtu.be/BLVss-kx3oY Video Summary In this video, I introduce a new course titled "Get AI Ready with Erik," designed to help you navigate the... https://erikdarling.com/new-course-get-ai-ready-with-erik/

In Defense Of Merge: Non-Deterministic Updates https://erikdarling.com/in-defense-of-merge-non-deterministic-updates/

Love Your Data Types: Dates https://erikdarling.com/love-your-data-types-dates/

Love Your Data Types: Strings https://erikdarling.com/love-your-data-types-strings/

check out microsoft doing cooler stuff with postgres than they do with sql server: www.youtube.com/watch?v=BJxr...

SQL Server Performance Office Hours Episode 45 https://erikdarling.com/sql-server-performance-office-hours-episode-45/

Dear SQL DBA: AI SQLServer2025 https://erikdarling.com/dear-sql-dba-ai-sqlserver2025/

bit Obscene: SQL Server 2025 Developer Features https://erikdarling.com/bit-obscene-sql-server-2025-developer-features/

bit Obscene: SQL Server 2025 Availability Groups https://erikdarling.com/bit-obscene-sql-server-2025-availability-groups/

Updating Video Posts With Summaries and Transcripts https://erikdarling.com/updating-video-posts-with-summaries-and-transcripts/

bit Obscene: SQL Server 2025 Standard Edition https://erikdarling.com/bit-obscene-sql-server-2025-standard-edition/

bit Obscene: SQL Server 2025 IQP Features https://erikdarling.com/bit-obscene-sql-server-2025-iqp-features/

we used to be a proper country. youtu.be/7_SAMrDnXOE?...

Fun Query Plan Friday https://erikdarling.com/fun-query-plan-friday/

Stored Procedure IF Branching and Deferred Compilation In SQL Server https://erikdarling.com/stored-procedure-if-branching-and-deferred-compilation-in-sql-server/