#Summit14 Embarcadero Book Signing
The blessings continue as Embarcadero offered to support my new book by hosting a book signing and providing 100 copies...
2014-11-04
1,057 reads
Blog Posts
Cardinality Estimation in SQL Server
Each time you view a seek/scan operator in an execution plan, you may have noticed that there’s a value for...
2014-11-04
1,281 reads
Data Driven Subscription On A Budget, Part 2
Data Driven Subscriptions On A Budget – Part 2
Yes, this is Part 2, you can find Part 1 here to get...
2014-11-04
1,109 reads
Database Ghosts
Recently you may have seen my first article on this topic over at SQL Solutions Group. If not, here is...
2014-11-04 (first published: 2014-10-22)
7,084 reads
Emailing Disk Space Alerting With Powershell
A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening...
2014-11-04
4,903 reads
PASS Summit 2014 Diary – Day 2
It’s another beautiful day in Seattle. And by beautiful, I mean overcast and threatening rain. Today will be mostly consumed...
2014-11-04
769 reads
SQLSaturday Portugal Porto 2014 Recap
Incredibly as it sounds, it took us 2 years of work to get the 18th of October. It took a...
2014-11-04
194 reads
5 things to know about Databricks
Databricks is now available in both AWS and Azure so it’s getting a lot of buzz! Let’s discuss 5 things you should know about Databricks before diving in. 1. ...
2014-11-03
20 reads
Force only certain values to be unique
I thought of something rather interesting the other day while answering a question asking for help with some table structures....
2014-11-03 (first published: 2014-10-22)
6,574 reads
How to copy table structure only from a SQL Query ? Tip #69
Recently , one of my friends shared that some interviewer asked him a question “How to copy table structure only from...
2014-11-03
746 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