I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2020-05-13 (first published: 2020-04-29)
588 reads
I’m excited to announce I’ll be speaking at the virtual GroupBy conference this year. Thanks everyone who voted! I’ll be speaking at the European day on May 12th at...
2020-05-06
16 reads
When working with Azure Data Factory, it’s possible you have multiple ADF environments. For example, you can have one for dev, one for test and one for production. Unfortunately,...
2020-04-21 (first published: 2020-04-08)
350 reads
GroupBy is a virtual conference, for the community and by the community. Content is focused on the Microsoft Data Platform. Speakers can submit sessions for two events: GroupBy Europe...
2020-04-14
17 reads
Sometimes in life you have to do things you really don’t like to do. Such as extracting data from a SharePoint List. Usually I use SSIS and the OData...
2020-04-07
1,200 reads
WARNING: do not do this in production. A quick blog post on a SSMS trick: how to quickly edit data. Sometimes you directly want to manipulate data without having...
2020-04-02
48 reads
Okay, the title of this blog post could also have been “SUMX returns unexpected results with duplicates”. The results only seem incorrect because an incorrect assumption might have been...
2020-03-02 (first published: 2020-02-27)
483 reads
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2020-02-04
50 reads
This year I’ve been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine people have been nominated as well, you can check...
2020-01-27 (first published: 2020-01-21)
224 reads
This year I’ve been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine people have been nominated as well, you can check...
2020-01-21
6 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
I need to delete rows from both the temporal main and history tables. The...
Comments posted to this topic are about the item When SQL Server Central Went...
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('tim', 'tom')
Assume preview features are enabled. See possible answers