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
170 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
433 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
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
883 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
396 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
49 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
950 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
591 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,437 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers