Non-SQL Tips and tricks – #tsql2sday 127 Rollup
I was thrilled to host TSQL Tuesday this month (#127) and I my prompt was non-SQL tips and tricks. Now ... Continue reading
2020-06-26 (first published: 2020-06-16)
496 reads
Blog Posts
Publish ADF from code to service easily
Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good news for you. There is a new tool in the market. It’s a task for...
2020-06-26
53 reads
Create a Build with YAML for SQL Change Automation in Azure DevOps
I used to make fun of YAML because I was scared of it. I still make fun of YAML, but I’m not scared of it anymore now that Rob...
2020-06-25
113 reads
Creating a Repository from VSCode–#SQLNewBlogger
I’ve been working with a few different git clients, and trying to write some articles to help people get started. As I do this, I thought it was interesting...
2020-06-25 (first published: 2020-06-10)
360 reads
New Management Hub in Azure Data Factory
I wanted to manually start an Azure-SSIS Integration Runtime in ADF, so I went to the edit section and then to connections. But instead of showing me my linked...
2020-06-25 (first published: 2020-06-11)
284 reads
Azure Data Studio SQL Notebook for Diagnostic Queries
Diagnostic Queries
Glenn Berry has long been known for producing the definitive diagnostic query set for various SQL Server versions. Between his amazing work and my favorite Brent Ozar First...
2020-06-24
20 reads
Azure SQL Database Networking
Have you realised the changes Microsoft have made to the firewall and networking section of Azure SQL Database? I found this quite stealthy and took me by surprise. I...
2020-06-24
12 reads
Azure SQL Database Query Editor
I was working on a couple of Azure databases the other day. One was an Azure SQL DB and the ... Continue reading
2020-06-24
167 reads
Bringing Redgate Streamed Down Under
Next week is the Redgate Streamed APAC Edition, on July 2. At least, July 2 in Australia. I’m still not sure what time it will be for me, and...
2020-06-24
3 reads
OPENJSON and CROSS APPLY
OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that will return metadata about the JSON document or we...
2020-06-24 (first published: 2020-06-09)
6,845 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers