Book Review – SQL Server Internals: In-Memory OLTP
In-Memory OLTP – a potential game changing technology
Every once in a while a technology comes out that has the potential to...
2015-02-24
618 reads
Anthony Nocentino Blog
Book Review – SQL Server Internals: In-Memory OLTP
In-Memory OLTP – a potential game changing technology
Every once in a while a technology comes out that has the potential to change things dramatically. In-Memory OLTP (Hekaton) is one...
2015-02-24
13 reads
Book Review – SQL Server Internals: In-Memory OLTP – Detailed Notes
Here are my unedited chapter notes:
Chapter 1Chapter 2Collation – current version requires BIN2 on character index columns. Best to do so...
2015-02-24
766 reads
Book Review – SQL Server Internals: In-Memory OLTP – Detailed Notes
Here are my unedited chapter notes:
Chapter 1 Chapter 2 Collation – current version requires BIN2 on character index columns. Best to do...
2015-02-24
14 reads
Standard SQL Server Build
Often I’m asked what is the best practice for a single SQL Server installation. Well, that is a tricky questions...
2015-02-11
485 reads
Standard SQL Server Build
Often I’m asked what is the best practice for a single SQL Server installation. Well, that is a tricky questions and the answer is it always depends. Let’s discuss...
2015-02-11
12 reads
Reflections as a consultant
Let’s just start withthe last three years have been fantastic! This blog post is a slight deviation from the technical...
2015-01-30
741 reads
Reflections as a consultant
Let’s just start with the last three years have been fantastic! This blog post is a slight deviation from the technical content on my blog. We’re going to focus...
2015-01-30
12 reads
Availability Group Read-only Routing
This morning at a customer site I was researching an issue where Availability Group read-only routing was not working correctly....
2015-01-25
3,443 reads
Availability Group Read-only Routing
This morning at a customer site I was researching an issue where Availability Group read-only routing was not working correctly. Quickly I was able to determine the issue was...
2015-01-25
18 reads
Blogs
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers