Using a DMK in TDE
When you setup TDE, you need to create a DMK (Database Master Key) in the master database if one doesn’t...
2017-02-02
785 reads
Blog Posts
Where is that Preemptive Wait coming from? Database Ownership and Performance: a journey through SQL Server internals with XEvents, Windbg and Wireshark
(EN)In this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when doing some tests with Natively Compiled Stored Procedures.
(DE) In...
2017-02-02
23 reads
Availability Group on SQL Server 2016
The Challenge
One of our clients in the gaming industry wanted to set up a high availability solution in their data...
2017-02-01
2,277 reads
Changing what SSMS opens on startup
When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and...
2017-02-01
778 reads
Columnstore Indexes – part 97 (“Working with Strings”)
Continuation from the previous 96 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
After many years of using & fighting the...
2017-02-01
655 reads
Improve performance by replacing temp tables with memory optimized tables - Part 1
There are many cases where you will be using temp tables, and many of us are trying to seek for...
2017-02-01
6,887 reads
My backup and SLEEP_BPOOL_FLUSH
I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more...
2017-02-01
816 reads
Running SSMS 2016 in Read Uncommitted Mode
Back in July when we received the first official release of SSMS not tied to an engine release we got...
2017-02-01 (first published: 2017-01-25)
2,033 reads
SCOPE_IDENTITY() or @@IDENTITY
I've seen a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from...
2017-02-01 (first published: 2017-01-27)
3,224 reads
Speaking at SQL Konferenz 2017
I’m heading back across the Atlantic this February for SQL Konferenz. This is an intimate SQL Server event in Darmstadt...
2017-02-01
563 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers