MDX Puzzle #3 Solution
Download Script
Sorry that it’s taken me so long to write this post, but I have been a little busy with...
2010-07-15
691 reads
Patrick LeBlanc
Free T-SQL Training - SQL Lunch #25 (Transact-SQL Development and Deployment)
Join SQL Server MVP, Andy Leonard, tomorrow on the SQL Lunch to learn some snappy tips and tricks on Transact-SQL...
2010-07-13
626 reads
Speaking at Greater New Orleans .Net User Group (GNO.NET)
This week I will speaking at the Greater New Orleans .Net User Group. My topic is Introduction to the SQL...
2010-07-12
678 reads
SQL Saturday #28 “Refer a Friend Contest”
With all the MSDN give away contests, I decided to add another. Here are the official rules for the twitter...
2010-07-12
562 reads
Free SSRS Training – SQL Lunch #23 (SSRS R2 – Shared Datasets & Report Parts)
Join SQL Server MVP, Patrick LeBlanc, next week on the SQL Lunch to learn about Share Datasets and Report Parts...
2010-07-09
1,552 reads
Free SSIS Training - SQL Lunch #24 (Looping in SSIS)
Join Brad Schacht this week on the SQL Lunch to learn about Looping in SSIS. Go to SQL Lunch and...
2010-07-07
600 reads
MDX Puzzle #2 Solution
MDX Puzzle #2 Solution
Download Script
This puzzle was a little more challenging than the first, but it was definitely fun and...
2010-07-06
1,059 reads
MDX Puzzle #3
The next puzzle comes from a BIDN.com forum post. Here are the requirements:
Columns: Internet Order Quantity and Percentage Of Total...
2010-07-06
519 reads
SQL Server MVP - Are you kidding me?
I received an email today stating that I had been selected as a Microsoft SQL Server MVP for 2010. This is my...
2010-07-01
724 reads
MDX Puzzle #2
Now that we have our feet wet, let’s get started with the next puzzle. In this puzzle we will write...
2010-06-30
1,449 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