Navigating Yukon - A First Look
Steve Jones takes a first look at the next version of SQL Server. It's been sitting for some time, but with the NDA lifted, here's some first impressions of the tools.
2003-12-09
7,845 reads
Articles
Worst Practice - Defining Rows that Exceed The Max Length
Andy started writing about worst practices a long time ago and returns this week with one that is short and sweet - why defining rows that exceed 8060 characters is a very bad idea and how you can avoid it.
2003-12-08
8,790 reads
Service Pack 1 for SQLCentric v.1.2.3 Now Available
This service pack contains bug fixed, plus enhancements including test email button, sorting, and drill down.
2003-12-08
653 reads
Sequential Numbering
Needing to number rows with a sequential id is a pretty common request. Sometimes it's because the user hasn't made the transition to 'set based' thinking, sometimes it really is a valid request (more or less!). Greg provides several different techniques to help you achieve sequential numbering.
2003-12-05
11,080 reads
Store Key - Storing Misc Data
This article proposes a system where extra data is stored in a simple row based table and retrieved using the 'store key'. It's not a new concept of course, but the author explains how and why he chose to implement. Feedback should be interesting!
2003-12-04
4,194 reads
Scaling Out
Kumar discusses the differences between scale up and scale out, then does a very good walk through of how to build a scale out solution.
2003-12-03
7,630 reads
New JDBC Driver for SQL
This is one of the vendors we met at PASS 2003. Their new driver is supposed to be faster than the driver provided by Microsoft AND supports NT authentication. Link takes you to a comparision chart of features. (Not Reviewed)
2003-12-03
1,622 reads
Indexed Views
Most of us know what it is, or do we? Chris works on a good definition and along with that, gets into a good look at the problems denormalization creates and talks about a pretty common form of it - the indexed view.
2003-12-02
12,289 reads
Notes about PASS 2003 and Other Stuff
Andy wrote up some notes about the recent PASS Community Summit, plans for next year, people we met, and much more.
2003-12-01
2,653 reads
Parameterizing Views
Views dont parameters, but sometimes you need them to act as if they do. Andy discusses views and how they encapsulate code and then offers an idea about how to alter the behavior of views on the fly. Controversial? Probably!
2003-12-01
8,537 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