31 Days of SSIS – Data Flow Breakpoints?! (3/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. In yesterday’s post I...
2011-01-04
544 reads
Blog Posts
31 Days of SSIS – Folder Structures (4/31)
31 Days of SSIS
Hopefully by now you’ve read the introductory post for the 31 Days of SSIS series that I...
2011-01-04
422 reads
Capturing the Execution Plan
One last post on execution plans and Profiler (at least for now)
When trying to check a query’s execution plan, the...
2011-01-04
1,390 reads
Filling in Data Potholes Redux: Tally Tables vs CTEs
In A Previous Installment
Re-Ducks
… our heroine (that’s me) rediscovered CTEs, specifically in the recursive style. That was in my post...
2011-01-04
1,116 reads
Finding last database growth date and time
A file growth operation on a database server is a extremely expensive operation. Many Performance problems correlate to a Data...
2011-01-04
490 reads
Invitation to T-SQL Tuesday #014
Hello and welcome to the first T-SQL Tuesday of 2011!
2010 was a great year for T-SQL Tuesdays, dreamed up and...
2011-01-04
1,290 reads
Making an Operations Manager Module
Operations Manager 2007 R2 ships with Operations Manager Shell which is simply a provider with associated cmdlets for working with...
2011-01-04
853 reads
MCM Live Blog – Week January 3
Watching videos?! Su-ure!
Surprisingly it’s now my fourth week of blogging about the things that I’m doing to study for the...
2011-01-04
270 reads
MCM Prep - Only ONE Transaction Log File
Unlike for data files, SQL Server does not use multiple files for the transaction log in any way that improves...
2011-01-04
776 reads
MCM Prep – Only ONE Transaction Log File
Unlike for data files, SQL Server does not use multiple files for the transaction log in any way that improves...
2011-01-04
786 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