SSIS version in SQL Server
Integration Services is the management interface for SSIS packages. SQL Server uses the “MsDtsSrvr.exe” for executing packages
To highlight the point,...
2011-09-22
1,067 reads
Blog Posts
SSRS – Dealing with truncating spaces
I apologize ahead of time on this post today because it will require lots of pre explanation and screenshots to...
2011-09-22
2,071 reads
An Informal Compendium of SSAS Errors, Part 1: Introduction
When practicing for my MCTS in SQL Server Analysis Services (SSAS) 2008 R2 last spring, I was shocked to receive...
2011-09-21
1,469 reads
An Informal Compendium of SSAS Errors, Part 2: Data Mining
This is the first in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-09-21
2,247 reads
Context-sensitive menus in PerformancePoint
Frequently I see a bit of confusion from business users when using an analytic grid on a dashboard in PerformancePoint. ...
2011-09-21
654 reads
MicroTraining: Performance Tuning Checklist
I’ve been playing a lot with Google+ and the Hangouts there. I love them. I think they’re opening up a...
2011-09-21
1,010 reads
Replication DDL Triggers
Because this was a problem that Google was zero help on and I did find a couple other people afflicted...
2011-09-21
2,185 reads
September 2011 SQL Server 2008 Diagnostic Queries
Its been a couple of months since I have released an updated version of my SQL Server 2008 Diagnostic Information...
2011-09-21
792 reads
September Performance Contest
This month SafePeak is sponsoring a contest centered around improving performance in SQL Server. The host of the contest is my friend Robert Pearl. You can read the announcement...
2011-09-21
5 reads
September Performance Contest
This month SafePeak is sponsoring a contest centered around improving performance in SQL Server.
The host of the contest is my...
2011-09-21
1,082 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