UNDERCOVER TOOLBOX: Sp_ChangeJobOwnerShip – Changing Ownership in bulk.
How many times have you seen SQL Agent jobs with random ownership? It can be very frustrating when you are...
2017-09-25
175 reads
Blog Posts
Columnstore Indexes – part 113 (“Row Groups Merging Limitations”)
Continuation from the previous 112 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post serves as the continuation...
2017-09-24
437 reads
Instant File Initialization in SQL Server on Linux
Earlier this week Ned Otter (@NedOtter) brought up a question about Instant File Initialization on SQL Server on Linux, check...
2017-09-23
889 reads
Instant File Initialization in SQL Server on Linux
Earlier this week Ned Otter (@NedOtter) brought up a question about Instant File Initialization on SQL Server on Linux, check out the thread here. I was up way too...
2017-09-23
13 reads
SQL Server On Containers
On Sep 23rd 2.45 PM PST, I will be presenting 2 sessions on “SQL Server On Containers” @ at SQLSaturday San Diego, if...
2017-09-23
397 reads
How Do I Analyze a SQL Server Execution Plan?
A query is slow, and you figure out how to collect the query execution plan. Now what? In this video, I talk “big picture” about what execution plans are,...
2017-09-22
54 reads
How Mature are you in Database DevOps?
I remember seeing the Carnegie Mellon Software Capability Maturity Model (CMM) when I was in university. It was fascinating, and...
2017-09-22
952 reads
How To Update Visual Studio 2017
(AKA how I lost a morning)
Hello!
This morning I needed to update my version of SSDT, but before I could do...
2017-09-22
773 reads
Information Measurement with SQL Server, Part 2.2: The Rényi Entropy and Its Kin
By Steve Bolton
…………I kicked off this far-ranging series on using SQL Server to quantify information by discussing two of the...
2017-09-22
597 reads
Multi Script Removes 25 Database Limit
I woke up to a Slack message that alerted me to a post in one of our channels. An engineer...
2017-09-22 (first published: 2017-09-14)
2,438 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers