RIP Brian Moran
When someone older than you dies, it’s sad, though I feel that I can cope. I hold memories dear, I appreciate the time I had with an individual, and...
2021-07-11
214 reads
Blog Posts
AI is going to be everywhere and in everything
I recently was a part of GestaltIT’s AI Field Day and have been thinking heavily about artificial intelligence (and by extension, machine learning and deep learning) lately. I put...
2021-07-09 (first published: 2021-06-28)
256 reads
Command Line Report with SQL Compare 14
I wrote recently about the use of the command line in SQL Compare 14 to find differences for specific items. Now I want to actually see the changes to...
2021-07-09 (first published: 2021-06-28)
173 reads
Daily Coping 9 Jul 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-07-09
10 reads
Azure Container Instance and SQL server part 2
In the last post we built an image of SQL server 2019 Linux hosted in Azure Container Instance for fast access to SQL server. So, your next question is...
2021-07-08
66 reads
Azure Resource Manager Template
Azure Resource Manager (ARM) Template is a cloud automation API for deploying Azure resources such as VM, database, network and storage services repeatedly with little(more...)
2021-07-08
49 reads
Daily Coping 8 Jul 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-07-08
35 reads
How to Fix SQL Database Error 8961?
Running DBCC CHECKDB or DBCC CHECKTABLE on a database may report error 8961. Such a situation could occur while changing the data type of a table column from “ntext...
2021-07-08
15 reads
Add DBCC INPUTBUFFER to Your Performance Tuning Toolbox
A command I like to use when performance tuning is DBCC INPUTBUFFER. If you have ever run sp_whoisactive or sp_who2 to find out what sessions are executing when CPU...
2021-07-07
22 reads
Centralized vs decentralized data architecture
One of the biggest differences between the Data Mesh and other data platform architectures is a data mesh is a highly decentralized distributed data architecture as opposed to a...
2021-07-07 (first published: 2021-06-30)
1,278 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
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...
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