SSIS Training class by Andy Leonard
Andy Leonard (b | t | l | f) of Linchpin People, has announced a new training class called ‘From Zero to SSIS‘. The first class...
2014-01-30
1,792 reads
Tim Radney
How to reset the SA password in SQL Server
Getting locked out of a SQL Server can happen in a number of ways. You could inherit a server that...
2013-11-28 (first published: 2013-11-21)
5,885 reads
Children at Technical Conferences
I have had the pleasure of taking my son with me on a number of trips where I was a...
2013-10-22
828 reads
Recovering the tail end of the transaction log
Knowing a great deal about backup and recovery is key to any DBA’s career. Most of us fully understand the...
2013-10-02
1,285 reads
Why I am not an MVP
On October 1st the emails went out notifying existing MVP’s in the Oct cycle if they were fortunate enough to...
2013-10-02
760 reads
PASS Elections part two
Tim Ford is running for a seat on the PASS Board of Directors and has my vote. Yes I think...
2013-09-24
596 reads
PASS Elections
I as well as many others have a decision to make on who I am voting for the PASS Board...
2013-09-23
581 reads
Get OS Counter Memory Available Mbytes Using TSQL
I have been working recently in making sure that max memory is configured for the hundred plus database servers I...
2013-09-20
1,152 reads
Professional Etiquette When Sending Mass Email – Use BCC:
<begin soap box rant>
Time and time again I find myself having to email people to remind them about how and...
2013-08-30
1,348 reads
SQL in the City 2013 US Tour
It was a huge honor to be chosen for the 2013 US tour of SQL in the City. Red Gate...
2013-08-30
1,196 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