PASS Virtual Chapter Events: September & October 2014
PASS Virtual Chapter Events: September 2014
Join SQL Server professionals from around the world for free online technical training and networking...
2014-09-11
632 reads
Blog Posts
SQL Server: Converting binary data to a hexadecimal string
Problem
I have a requirement to convert the binary data inside a table column or variable to a hexadecimal string. Is...
2014-09-11
4,423 reads
SQL Server: Converting binary data to a hexadecimal string
Problem I have a requirement to convert the binary data inside a table column or variable to a hexadecimal string. Is it possible to directly convert the binary data...
2014-09-11
14 reads
September 2014 Las Vegas UG Meeting
Who is up for a little free learning this week? Besides the opulence and feast that was the 24 Hours of PASS (Summit Preview), we have more training in...
2014-09-10
1 reads
September 2014 Las Vegas UG Meeting
Who is up for a little free learning this week? Besides the opulence and feast that was the 24 Hours...
2014-09-10
672 reads
VMworld 2014 Wrap Up for Data Professionals
A few weeks ago I was fortunate enough to attend VMware’s VMworld 2014 conference in San Francisco, CA. The show...
2014-09-10
484 reads
[Off-Topic] Beating Childhood Cancer
Note: I feel this post is important enough to post across all my blogs.
September is Childhood Cancer Awareness Month here...
2014-09-09
550 reads
24 Hours of PASS Preview: Zero to Hero (I'm the Zero)
Hello Dear Reader! We are already away into the 24 Hours of PASS Summit Preview for 2014! I don't know...
2014-09-09
809 reads
Analysis Services Partitions
Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files....
2014-09-09 (first published: 2014-09-05)
7,444 reads
Clustered Columnstore Indexes – part 40 (“Compression Algorithms”)
Continuation from the previous 39 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
It’s time to take a look into the algorithms that Microsoft is...
2014-09-09
310 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