Importing a SQL Server 2008 Analysis Services Database
Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to...
2009-11-03
1,052 reads
Blog Posts
Kick xp_sendmail to the curb
With the advent of SQL Server 2005 and 2008, mail in the database engine has changed dramatically. Previously you had...
2009-11-03
1,419 reads
My First PASS Experiences
Getting to Seattle
I started my travels to the PASS Summit at about 9:30 am (EST) on Sunday and arrived at...
2009-11-03
711 reads
PASS Day –1 (Monday) at PASS Summit 2009
Started the day with a long walk, then off to Top Pot doughnuts for coffee with Don Gabor, Jack Corbett,...
2009-11-03
378 reads
PASS Summit - Bob Muglia
President of server tools at Microsoft, Bob Muglia, he overseas Windows Server, Systems Center, Hyper-V, and of course, SQL Server....
2009-11-03
731 reads
Pass Summit 2009 - Live Blogging
I'm blogging from the PASS Summit 2009, making notes as the keynotes unfold. This is my second year doing it...
2009-11-03
326 reads
PASS Summit 2009 - Ted Kummert
After Bob Muglia, Ted Kummert came on stage. He's the senior VP of the server tools division and works for...
2009-11-03
941 reads
PASS Summit 2009 - Wayne Snyder
The opening remarks of the first day are typically from the President of PASS. Wayne Snyder, the outgoing president started...
2009-11-03
933 reads
PASS Summit 2009 Day – 0
Monday at the PASS Summit. It’s always a big day. This year it’s the eve of the Summit and the...
2009-11-03
752 reads
PASS Summit 2009 Day 1 Keynote Live Blog
(Note: Updates are listed newest first)
10:15 AM – And we're done! The rooms empty out to grab spots at the first...
2009-11-03
744 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