My Interview at Data Platform Geeks 2017
Dear All, Earlier this year in August, I had the privilege of speaking at Data Platform Summit 2017 at Bangalore. As always a terrific experience to hangout, interact and...
2017-12-23
4 reads
Blog Posts
SQL Saturday Nepal 2017
I had the honor to visit Nepal and participate in SQL Saturday Nepal 2017. You can visit the event website...
2017-12-23
481 reads
An Identity Crisis: Is it Profiler or is it Extended Events?
I have been working on this article for far longer than one might think is necessary for something of this...
2017-12-22
116 reads
An Identity Crisis: Is it Profiler or is it Extended Events?
Despite it being new, it seems there are a handful of "facts" already published about it that may or may not be accurate. Due to that, I want to...
2017-12-22
6 reads
Creating and Using Failover Groups in Azure DBaaS – Part 1
Introduction
Hello everybody! Welcome back! One of my favorite features in Azure SQL DBaaS is Failover Groups. I have been working...
2017-12-22
153 reads
Design Concepts For Better Power BI Reports Part 4: The Squint Test
Data visualization should be iterative. You should get a good initial draft put together and then check to make sure...
2017-12-22
778 reads
Is the traditional data warehouse dead?
There have been a number of enhancements to Hadoop recently when it comes to fast interactive querying with such products...
2017-12-22
1,751 reads
Is the traditional data warehouse dead?
There have been a number of enhancements to Hadoop recently when it comes to fast interactive querying with such products...
2017-12-22
101 reads
Live on Channel 9 with ReadyRoll
I was interviewed in Redmond a couple months ago and the video was just published. I show and demo some...
2017-12-22 (first published: 2017-12-07)
1,735 reads
More Beginner / Fundamentals Content
Not surprisingly, there are folks who want beginner / fundamentals presentations and blog posts.
I put up the poll based on a...
2017-12-22 (first published: 2017-12-05)
1,895 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