Continuation from the previous 92 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Given that currently the Batch Execution Mode...
2016-12-28
968 reads
It’s said that “promises are made to be broken”. Surely database administrators don’t fall in that category? It’s that time...
2016-12-28
687 reads
In designing a proper ETL architecture, there are two key questions that must be answered. The first is, “What should...
2016-12-28
767 reads
I saw a question posted recently about someone that had disabled TDE and was still having issues restoring a backup....
2016-12-28
2,171 reads
Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found...
2016-12-28
1,519 reads
How SQL Server uses Windows Virtual Accounts and local groups
Managed Service Accounts (MSAs) and Virtual Accounts were introduced in Windows...
2016-12-28
2,386 reads
I love SQL Prompt. This might be my favorite tool from Redgate Software and just when I thought it couldn’t...
2016-12-27
666 reads
SQL Server’s new Query Data Store is a brilliant option for databases if you are a DBA or have to...
2016-12-27
604 reads
Last week I posted a brief survey about working the holiday. To those who normally are not required to work...
2016-12-27
379 reads
I recently worked on a project for fraud. This project needed to relate 67 million accounts to one another “Kevin...
2016-12-27
1,303 reads
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Comments posted to this topic are about the item 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