I was using LEN() to troubleshoot an issue I was having with a dynamically constructed string truncating while inserting into an NVARCHAR(MAX) column. Since I know that NVARCHAR(MAX) has...
2020-07-22 (first published: 2020-07-14)
1,535 reads
At last week’s presentation to the Edmonton SQL Server user group, I spoke at length about the many extensions that are available for Azure Data Studio, and was asked...
2020-07-22
59 reads
You should always seriously consider enabling this feature. This is part of the ADS suite – Advanced Data Security and I will show you how good this pro-active service...
2020-07-21
136 reads
Recently I have been able to work with our development teams to not create new databases. There are several reasons for me making this request of the teams. The...
2020-07-21
14 reads
I’ve 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...
2020-07-21
14 reads
Azure Synapse is the new Generation of SQL DW (Azure SQL Data Warehouse), that is launched in the past year In November 2019 the First announced for Azure SQL...
2020-07-21
10 reads
A little while back, I offered up a one-liner to scan your SQL Server instances and report which ones are out of date. But what if you need to...
2020-07-21
19 reads
A little while back, I offered up a one-liner to scan your SQL Server instances and report which ones are out of date. But what if you need to...
2020-07-21
163 reads
2020-07-21
9 reads
2020-07-21
10 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers