SQL Saturday #28 (Baton Rouge) – All about User Groups
This year at SQL Saturday #28 we will be featuring a User Group Booth alongside the Sponsor booths. The User Group...
2010-06-29
1,566 reads
Patrick LeBlanc
MDX Puzzle #1 Solution
OK, are you ready to start the MDX journey. In MDX Puzzle #1 posting I presented you with the challenge...
2010-06-28
880 reads
MDX Puzzle #1
MDX Puzzle #1
Recently, I embarked on a mission to become proficient at writing MDX queries. This is a challenge, as...
2010-06-22
683 reads
SQL Saturday #28 (Baton Rouge) Announcements
Register: Click Here
Submitted Sessions: Click Here
Twitter: @SQLSatBR
On August 14, 2010 at Louisiana State University SQL Saturday #28 will be held. ...
2010-06-22
500 reads
SSRS R2 - Naming Excel Worksheet Tabs
I was recently asked if it was possible to name an excel tab based on a page in a reporting...
2010-06-21
2,707 reads
Insert Unknown Row to Dimension Table
When building a warehouse there is a common practice of adding an Unknown row to the Dimension tables. For me,...
2010-06-15
1,419 reads
Parameterized Report using a Stored Procedure
Download Sample Project: Parameterized Report
In a recent forum post on BIDN.com a person asked how to filter the result on...
2010-06-13
2,266 reads
Upcoming SQL Lunch Events
We are scheduling more and more events daily on the SQL Lunch. Just as a reminder here are a few...
2010-06-10
520 reads
SQL Saturday #22 Pensacola Recap
Saturday I drove up to Pensacola for SQL Saturday #22. Me and several others from Baton Rouge, including my two...
2010-06-08
701 reads
Inventory SQL Servers with CLR Function
In an enterprise with several SQL Server instances it is pivotal that you keep track of each instance and its...
2010-06-02
724 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