SSDT and Friends - .net meetup video
I did a talk at the london .net meetup if you want to get an overview of what SSDT is...
2017-02-10
370 reads
Blog Posts
SSDT and Friends - .net meetup video
I did a talk at the london .net meetup if you want to get an overview of what SSDT is and how to get started then I would recommend...
2017-02-10
4 reads
Using Extended Events in Azure
Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace,...
2017-02-10 (first published: 2017-02-06)
1,302 reads
YouTubing Down the SQL Server River
I recently stumbled on a YouTube channel from one of my favorite SQLPeople - she is sharp (and an MCM) and...
2017-02-10
598 reads
Consumption Based Architecture for Modern Data Analytics
Throughout many years of working with BI solutions and data warehouse solutions, we have strived to put all the data...
2017-02-09
657 reads
Getting Started with Power BI: Getting Data (Part 2 of 3)
This is part 2 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-09
172 reads
Monitoring SLAs with SQL Monitor Reporting
Proactive Reporting for SQL Server
If you’re a return reader of this blog you know I write often about monitoring and...
2017-02-09 (first published: 2017-02-04)
2,048 reads
Opening the PowerShell ISE from Explorer
This is a cool productivity trip, and one that I ran into by accident. I had heard that I could...
2017-02-09
1,732 reads
Speaking at Triad Developer’s Conference
I am honored to have been recommended by a colleague and selected as a speaker for the Triad Developer’s Conference...
2017-02-09
362 reads
SQL: Different ways to generate sequence
There was a question from the op regarding adding a new column to a query output by generating the cyclic...
2017-02-09 (first published: 2017-02-06)
2,515 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