Monitor Query Statistics
One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task....
2015-03-10 (first published: 2015-02-26)
8,416 reads
Guy Glantser
SQL Saturday 360 in Israel
I had the pleasure to speak at SQL Saturday 360 in Israel. It was such a great event! We had...
2015-01-28
605 reads
I’m a SQL Server MVP!
I have been working with SQL Server for the past 17 years, and in the past few years I have...
2015-01-12
640 reads
Parameterization Part 7: Summary
This is a summary of the parameterization blog post series. If you read the previous posts in the series, then...
2015-01-12 (first published: 2015-01-08)
7,381 reads
SQL Server Developer Tips that Can Save Your XXX
Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for...
2014-12-16
803 reads
How to Handle Dynamic Rowsets
Sometimes you have a stored procedure that returns a rowset, and you need to insert the rowset into a temporary...
2014-12-04
1,562 reads
Parameterization Part 6: Simple vs. Forced Parameterization
This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan...
2014-11-27
7,538 reads
Working with Very Large Tables Like a Pro in SQL Server 2014
I presented my session – Working with Very Large Tables Like a Pro in SQL Server 2014 – in PASS Summit 2014....
2014-11-08
1,038 reads
Be Careful! Backups Can Bite You!
Here is a riddle for you…
You are requested to move a database from an old server to a new server....
2014-10-24 (first published: 2014-10-20)
7,595 reads
Parameterization Part 5: Two Common Mistakes
This is the fifth post in my Parameterization series. In previous posts I wrote about parameter sniffing and when it is...
2014-09-23 (first published: 2014-09-20)
8,981 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
Safe and Reliable Transport of Farm Machinery: Solutions of the Modern Agricultu
Ship A1 Auto Transport is a reliable provider of services who delivers safe and...
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