SQLRally 2012 Registration Open
The Professional Association for SQL Server and the North Texas SQL Server User Group have been working hard behind the...
2011-11-30
1,485 reads
Blog Posts
Start Documenting Your Day! Why Now?
I read a post about documenting your day by Steve Jones, here is where culture insists i write a few words about...
2011-11-30
1,531 reads
TechEd Comes to Orlando in June 2012
Just saw the official announcement MS TechEd will be in Orlando June 11-14, 2012, at the Orange County Convention Center....
2011-11-30
1,559 reads
2011-11-30
1,480 reads
The process could not read file due to OS error 3
When configuring a subscription to a publication in SQL Server, on initialization it is common to encounter the error:
The process...
2011-11-30
43,191 reads
Tuesday Hardware Tidbits, Nov 29, 2011
Since Microsoft is moving to core-based licensing for SQL Server 2012 Enterprise Edition, with a minimum of four physical core...
2011-11-30
944 reads
Using OFFSET and FETCH
Introduction
Many times while developing our applications we feel the need of pagination, where our User Interface (UI) has to list...
2011-11-30
9,797 reads
WAN Optimization Evaluation Review–Part 1
We are evaluating a WAN optimization vendor and have so far installed the appliance at the primary site and end-user’s...
2011-11-30
1,894 reads
What's in a name? SQL Server Magazine becomes SQL Server Pro.
SQL Server Magazine Reveals New Name for the Brand
Did you hear the news? SQL Server Magazine has a new...
2011-11-30
7,480 reads
CONCAT() – SQL Server 2012
With SQL Server 2012 a new string function is born – CONCAT(). The output is a string, as the result of...
2011-11-29
1,070 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