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
434 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
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
592 reads
SQL Server: The danger of large data types
Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data...
2017-09-22
420 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
951 reads
PASS Summit 2017 is Coming
The yearly PASS Summit is just around the corner, a little less than six weeks away. For those not familiar...
2017-09-22
348 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
50 reads
Restore BACPAC to SQL Azure
Hello!
2 posts in 1 day? When you’re hot, you’re hot!
I’m actually writing this one whilst I’m waiting for a BACPAC...
2017-09-22
362 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers