OPASS is pleased to announce - SQLSaturday #49 - Orlando October 16th. Get it on your calendar now.
SQLSaturday #49 - Orlando is now live on the SQLSaturday web site. It will be held on October 16th at Seminole...
2010-04-22
405 reads
Blog Posts
PASS Summit Content Survey Results
The results of a survey conducted by the PASS organization have been posted (thanks to the Board for all their...
2010-04-22
634 reads
Rebuilding the Home Server
My Windows Home Server died a month ago, just as I was getting ready to leave the country. I didn’t...
2010-04-22
705 reads
Results of PASS Summit 2010 Content Survey Released
A few weeks back PASS sent out a survey to get input on how to shape the 2010 Summit agenda,...
2010-04-22
535 reads
SQL Server 2008 R2 reaches RTM
On April 21 Microsoft announced SQL Server 2008 R2 has been released to manufacturing.
The downloads on Technet/MSDN on May 3....
2010-04-22
403 reads
SQLSaturday 31 Chicago: Recap
Last weekend I had the distinguished pleasure of attending Chicago’s very first SQLSaturday event. Before I begin my recap I’d...
2010-04-22
658 reads
The Knowledge... (quote)
The quote about Knowledge, sure it is Albanian quote:
Learn the Knowledge but you'll never get rewarded by the God(All-llah) until...
2010-04-22
1,366 reads
What is a Good Way to Quickly Disable SQL Agent Job Schedules?
Introduction
I recently blogged about a Stored Procedure to Sequentially Run SQL Agent Jobs and have been meaning to blog about...
2010-04-22
456 reads
2010 Scripting Games
Since I've decided it's time for me to learn Powershell, naturally the best way to learn it is to dive...
2010-04-21
764 reads
A DMV a Day – Day 21
The DMV for Day 21 is sys.dm_os_ring_buffers, which is helpfully NOT described by BOL as:
The following SQL Server Operating System–related...
2010-04-21
2,585 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