SQL Saturday #150 Baton Rouge 2012
Baton Rouge SQL Saturday is Saturday, August 4!
We expect ~400 attendees at the brand new LSU Business Education Centre of...
2012-07-27
775 reads
Blog Posts
SQL Server 2008 R2 – Service Pack 2 now available
SQL Server Team, has announced the Service Packe 2 available for the SQL Server 2008 R2.
All the details are here
Stay...
2012-07-27
1,404 reads
SSRS – Using Lookup Function for Multiple Column Join
When SQL Server 2008 R2 was released several new Reporting Services expressions were made available that would help join multiple...
2012-07-27
4,382 reads
A Quick Guide to Expanding Database Files and IFI
This is a topic that’s been well covered, but in the interest of spreading good database practices, here’s a very...
2012-07-26
1,087 reads
Capacity considerations while moving SQL workloads to a Virtual world !
One of the most basic capacity considerations involved while planning to move SQL workloads to a virtual environment is to understand the...
2012-07-26
837 reads
Joining on NULLs
A problem I see on a fairly regular basis is that of dealing with NULL values. Specifically here, where we...
2012-07-26
1,799 reads
Last Call For Speakers for SQLSaturday Orlando
Our call for speakers for SQLSaturday #151 in Orlando closes on July 31, 2012. We’ve got room for a handful...
2012-07-26
593 reads
Retrieving Deadlock Graphs with Event Notification
Checkout my article (i.e. Retrieving Deadlock Graphs with Event Notification) that is published on SSWUG.org. This article shows the steps...
2012-07-26
2,917 reads
Working at Home Tips for Erin
A friend of mine, Erin Stellato (blog | @erinstellato) is about to change jobs. She’ll go from working in an office...
2012-07-26 (first published: 2012-07-23)
2,573 reads
Cross-Post: Set Milestones for Little Victories
This seemed appropriate to cross-post from Goal Keeping DBA given the editorial for today:
One of the first pieces of advice...
2012-07-25
1,093 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