Drop That Schema
An often under utilized or maybe even mis-utilized feature of SQL Server is a database object schema. In the event of...
2017-11-09 (first published: 2017-10-27)
2,241 reads
Blog Posts
How to be a successful innovator
Let’s say you have some obscure list of career goals for the year and one of those is to be...
2017-11-09
311 reads
How to Upgrade an AG Cluster to Windows 2016
Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016. The best...
2017-11-09
165 reads
How to Upgrade an AG Cluster to Windows 2016
Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016. The best...
2017-11-09
78 reads
Information Measurement with SQL Server, Part 2.3: Thermodynamic and Quantum Entropies
By Steve Bolton
…………When I was about 12 years old, I suddenly discovered football. Many lessons still awaited far in the...
2017-11-09 (first published: 2017-10-31)
1,506 reads
Launching SQL Server on Linux in Single User Mode
There was a question this morning on the SQL Server Community Slack channel from SvenLowry about how to launch SQL Server on Linux in Single User Mode. Well you’ve...
2017-11-09
4 reads
Things I Learned from Speaker Idol 2017 at the SQL PASS Summit
I was lucky enough to serve as a judge for the Speaker Idol competition at the SQL PASS Summit conference this year. One of the great thing about watching...
2017-11-09
7 reads
Columnstore Indexes – part 115 (“Bulk Load API and Pressure”)
Continuation from the previous 114 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is dedicated to the...
2017-11-08
397 reads
Connecting to an Azure SQL Databases
Connecting to an Azure SQL Databases is pretty simple and straight forward,as long as you know what you need in...
2017-11-08
340 reads
Contained Databases setup
Last weekI wrote about what is a contained database, the benefits and challenges, today as promised I'll show you how...
2017-11-08
247 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