#sqlblog — Bluesky Posts

3 months ago

Following on from my previous post...this next one dives into Performance Tuning KubeVirt for SQL Server

dbafromthecold.com/2025/12/11/p...

#sqlserver #kubernetes #sqlblog #containers

0 0 0 0

Andrew Pruski 🏴󠁧󠁢󠁷󠁬󠁳󠁿 🇮🇪

@dbafromthecold.com

4 months ago

Accelerated Database Recovery for tempdb in SQL Server 2025 Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous transaction rollback, and aggressive log truncation. A complete overview of how ADR achieve…

Accelerated Database Recovery for tempdb in SQL Server 2025

dbafromthecold.com/2025/10/31/a...

#sqlblog #sqlserver #sql2025

5 2 1 0

Monica Morehouse (Rathbun)

@sqlespresso.bsky.social

5 months ago

The Gang vs. Jason: Unmasking JSON’s Secrets in SQL Server 2025- Scooby Dooing Episode 7 Every Scooby-Doo adventure has its running gags. Shaggy and Scooby bolt from every ghost in sight, Velma’s always losing her glasses, and Scrappy jumps in yelling, “Let me at ‘em!” But in this episode, Scrappy’s favorite joke is about a villain he calls Jason. Of course, Jason isn’t really a monster at all—it’s JSON, the data type we’ve been wrangling inside SQL Server and pretty much everywhere else across our technology stacks.

The Gang vs. Jason: Unmasking JSON’s Secrets in SQL Server 2025- Scooby Dooing Episode 7-In #SQLServer2025, the gang finally unmasks Jason (JSON)! #DBA #PerformanceTuning #sqlblog #DataCommunity #sqlfamily #azure

7 1 0 0

Monica Morehouse (Rathbun)

@sqlespresso.bsky.social

6 months ago

Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4 One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved a mystery alone. Scooby and Shaggy could sniff out a clue between snacks, but it always took the rest of the Mystery Inc. gang to crack the mystery. Velma helped with her smarts, Fred with the traps, and Daphne with spotting the overlooked details—all of them used their skills to actually catch the villain.

Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4 -Scooby and Shaggy might trip over a clue while chasing down a snack, but it always took the entire Mystery Inc. crew to actually solve the case. #sqlserver #sqlblog #sqlfamily #azure #aws #rds

7 2 0 0

sqljared

@sqljared.bsky.social

6 months ago

Page Latch Testing - sqljared I want to test some methods for eliminating page latch waits. Let's set up a test environment with a few tables and make sure we get the waits we expect.

I've posted two blogs on testing methods of reducing page latch contention. I set up some tables for testing here (www.sqljared.com/blog/page-la...), then tested several approaches and provided results here (www.sqljared.com/blog/page-la...). #sqlfamily #sqlblog

2 1 0 0

Shane O'Neill

@sozdba.bsky.social

7 months ago

Ordering and Choices in PowerShell Ah! Hash tables! Ever since I saw a presentation by Anthony Howell ( Blog ), aka PoshWolf, about them, read the blog post by Kevin Marquette ( Blog ) about them, and was enlightened by multiple Pow…

Ah! It's nice to blog again!

Ordering and Choices in PowerShell

#powershell #sqlblog

nocolumnname.blog/2025/07/21/o...

2 0 0 0

sqljared

@sqljared.bsky.social

9 months ago

Five Useful Metrics in Query Store A discussion of some useful metrics and why they are valuable. One I only realized the utility of recently and wanted to share.

I've posted a new blog on metrics from Query Store and their relative value at www.sqljared.com/blog/useful-.... I only realized the value of one recently, so I wanted to point it out. #sqlfamily #sqlblog

9 6 0 0

Shane O'Neill

@sozdba.bsky.social

10 months ago

How SQL Server’s Compute Scalar Will Impede You Postgres Blogs We’re getting more and more Postgres instances at work. To get up to speed on Postgres, I’ve started to expand my RSS feed to include Postgres blogs. It was one of those …

New post is up. A short, rather silly one that I enjoyed writing.
And isn't that the main thing in the end?
...
No? It's not? Oh...

#sqlblog #sqlserver

nocolumnname.blog/2025/04/25/h...

1 0 1 0

Shane O'Neill

@sozdba.bsky.social

1 year ago

Getting SQL Server Version using dbatools Time to read: ~ 4 minutes Words: 730 The Initial IssueChecking under the function’s hoodUsing a dictionary insteadShift left?Using dbatoolsConnect-DbaInstanceGet-DbaDatabaseEnd I will discuss…

Getting #SQLServer Version using @dbatools.io

#SqlBlog #PowerShell

nocolumnname.blog/2025/03/06/g...

0 1 0 0

Shane O'Neill

@sozdba.bsky.social

1 year ago

T-SQL Tuesday 183 – Tracking Permissions Words: 593 Time to read: ~3 minutes PowerShell Scripts for Checking SQL Server Login SIDs Welcome back to T-SQL Tuesday, the monthly blogging party where we are given a topic and asked to write a b…

#tsql2sday post is done and up!

Let me know what you think #sqlblog.
#PowerShell Scripts for Checking #SQLServer Login SIDs

nocolumnname.blog/2025/02/11/t...

2 0 0 0

Patrick Keisler

@patrickkeisler.bsky.social

1 year ago

How to Convert FileTime to DateTime – Everyday SQL

How to Convert FileTime to DateTime - #sqlserver #sqlblog www.patrickkeisler.com/2024/11/how-...

0 0 0 0

sqljared

@sqljared.bsky.social

1 year ago

Page Latch Waits and Solutions - sqljared Page latch waits have two main causes. One is largely resolved in Microsoft SQL Server 2022, and here are some options for the other.

Pagelatch contention has two main causes; tempdb and the hot page issue. My blog at www.sqljared.com/blog/page-la... provides several possible solutions for the second. #sqlfamily #sqlblog

3 0 3 0

Patrick Keisler

@patrickkeisler.bsky.social

2 years ago

How to Test Trace Flag 3625 – Everyday SQL

How to Test Trace Flag 3625 #SQLServer #SQLblog www.patrickkeisler.com/2023/12/how-...

0 0 0 0

Patrick Keisler

@patrickkeisler.bsky.social

2 years ago

Get Certificate Details for SQL Encryption In-Transit Using PowerShell – UPDATED – Everyday SQL

Get Certificate Details for SQL Encryption In-Transit Using PowerShell – UPDATED #SQLServer #SQLBlog