Geometry Objects in SQL Server using Latitude/Longitude coordinates
(2018-Mat-31) Support for spatial geometry functions was initially introduced in SQL Server 2008 and then it was greatly improved in...
2018-03-31
3,706 reads
Blog Posts
Azure SQL Database – Automatic Index Tuning
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven, so why not have auto indexed databases? This article...
2018-03-30
12 reads
Azure SQL Database – Automatic Index Tuning
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven,...
2018-03-30
869 reads
Azure SQL Database – Automatic Index Tuning
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven, so why not have auto indexed databases? This article...
2018-03-30
397 reads
Code that writes code
Code that writes code it one of the best productivity tips I can give you. And no, I’m not talking...
2018-03-30
525 reads
Configuration service database design pattern
In many cases, we are required to store configuration values for an application, application functionalities or user-specific parameters. Normally application-level...
2018-03-30
526 reads
Database Doing DevOps
DevOps. It’s one of the latest buzz words in many technical communities. Database Doing DevOps This phrase, however, is NOT...
2018-03-30
450 reads
I learned about the order of logical operations #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-03-30 (first published: 2018-03-22)
2,643 reads
Parsing the PASS Blog Posts about FY 19 and SQLSaturday
In February PASS President Grant Fritchey posted PASS Priorities FY 19 followed by An Open Letter to SQLSaturday Organizers, and then held...
2018-03-30 (first published: 2018-03-27)
1,706 reads
SQL .NET Requirements
SQL Server Install Requirements
SQL Server Installation requirements indicate .NET 3.5, 4.0, or 4.6 depending on the version. This is not including SSMS. At this point you shouldn’t use SSMS...
2018-03-30
11 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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...
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