Daily Coping 12 Feb 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-02-12
17 reads
Blog Posts
Published Azure Arc-Enabled Data Services Revealed
I’m super proud to announce that Ben E. Weissman and I have published Azure Arc-Enabled Data Services Revealed available now at Apress and your favorite online book sellers! Buy...
2021-02-12 (first published: 2021-02-05)
134 reads
Release Your Inner Synapse
I don’t know about you, but as Microsoft has produced the Azure Synapse platform, I see a plethora of needs that could be fulfilled by it. Being in a...
2021-02-12 (first published: 2021-02-08)
333 reads
Added another 3 new PowerShell functions for reports on Power BI Report Server
I finally did it. I created a function I’ve been wanting to be able to use for *years*. Test-RsRestItemDataSource is here. I can’t tell you how many times I’ve...
2021-02-11 (first published: 2021-02-03)
589 reads
Build a Beautiful Site in the WordPress Mobile Apps with Predesigned Page Layouts
We think you'll love the new Starter Page Layouts feature.
2021-02-11
6 reads
Daily Coping 11 Feb 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-02-11
8 reads
Friend of RedGate 2021
This past month RedGate graciously allowed me to be a part of their Friend of RedGate program. It’s been a great seven year run with this program and I...
2021-02-11
18 reads
Set up connection from Azure Data Factory to Databricks
Both, Azure Data Factory and Azure Databricks offer transformations at scale when it comes to ELT processing. On top of that, ADF allows you to orchestrate the whole solution...
2021-02-11 (first published: 2021-02-04)
224 reads
Azure SQL DB – Troubleshooting CPU issues
When you have the need to find out real time what is causing high CPU issues within your Azure SQL Database, there is nothing better than using TSQL and...
2021-02-10
215 reads
Daily Coping 10 Feb 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-02-10
9 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers