SSRS 2016: Great and Getting Better
Although I’ve been a regular user of SQL Server Reporting Services since it was released in the mid-2000s, I’ve done...
2016-12-18
414 reads
Although I’ve been a regular user of SQL Server Reporting Services since it was released in the mid-2000s, I’ve done...
2016-12-18
414 reads
The SSIS catalog comes packaged with a rich set of built-in reports that give those monitoring Integration Services a window...
2016-12-17
413 reads
In my last post I shared how to build a package in SSIS to perform simple file archive (zip) operations....
2016-12-16
582 reads
Today we have a guest editorial from Tim Mitchell that talks about security and communications with your customers. Ultimately it pays to be open and honest.
2016-12-15 (first published: 2013-12-17)
400 reads
Of the very many things SQL Server Integration Services does well, one of its shortcomings is that it does not...
2016-12-15
396 reads
Built into the SQL Server Integration Services catalog is the ability to run a validation without actually executing the package....
2016-12-14
678 reads
One of my favorite testing features of SSIS is also one of the most underutilized. SSIS data taps were introduced...
2016-12-13
418 reads
I’ve written quite a bit about the benefit of externalizing changing values in SSIS packages. Moving static values such as...
2016-12-12
348 reads
It’s that time of the year again – the Festivus season is upon us! In the next few weeks, families all...
2016-12-12
300 reads
There are several ways to execute SSIS packages that have been deployed to the SSIS catalog, and my favorite way...
2016-12-02 (first published: 2016-11-28)
3,945 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Ship A1 Auto Transport is a reliable provider of services who delivers safe and...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
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