SQL Server Monitoring: What queries should you monitor?
I previously wrote about measuring wait statistics. This matters a lot, because you can track historically what wait statistics are...
2019-02-02
377 reads
"A connection timeout has occurred on a previously established connection to availability replica"
I previously spent some time troubleshooting this issue at one client, and then having encountered it twice more this year, I figured I'd include it in a blog post....
2019-02-01
6,293 reads
Modern Hardware with 64 CPUs
In today’s world, more often then not you might run into systems that have large beefy hardware. Hundreds of gigabytes...
2019-02-21 (first published: 2019-02-01)
2,483 reads
SQL Server 2017 Reporting Services: The Basics Part 2
Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time...
2019-02-22 (first published: 2019-02-01)
3,074 reads
Financial Advice for Techies
I’m not writing a post here on how to manage your money, but I will point you to Troy Hunt’s...
2019-02-22 (first published: 2019-02-01)
2,906 reads
How many plans are in the plan cache for a stored procedure?
It depends on where you’re looking and how many statements are in the stored procedure.
Let’s take a look at some...
2019-01-31
563 reads
How Does DBCC CHECKIDENT Really Work When Resetting the Identity Seed (RESEED)?
(last updated: 2019-01-31 @ 22:45 EST / 2019-02-01 @ 03:45 UTC )
Today’s “Question of the Day” on SQL Server Central, Cleaning up the...
2019-02-20 (first published: 2019-01-31)
6,333 reads
Azure Notebooks – a nice little tool.
Gday,
I’ve been playing with Azure notebooks lately and have found them invaluable as
A teaching aidA test sandboxI’ve been using Python...
2019-01-31
1,105 reads
How To Check How Far Behind Your SQL Server Log Shipping Secondary Is
Log shipping is one of the simplest and most bulletproof methods to get SQL Server to replicate data to a...
2019-02-21 (first published: 2019-01-31)
2,767 reads
Index maintenance freebies
I didn’t expect anything for free in index maintenance. After all, it takes a lot of CPU and transaction log...
2019-02-20 (first published: 2019-01-30)
2,435 reads
Blogs
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers