Why Do All Funnel Charts Look The Same?
Something recently occurred to me. I’ve been researching chart and dashboard
design standards for an article I’m working on, and the...
2011-01-12
665 reads
SQL Server BI Blog
What’s Going On at Microsoft?
Last week Donald
Farmer announced that he was leaving his long-time position as Microsoft’s lead
BI technology evangelist for QlikTech, a small...
2011-01-11
707 reads
Rich Embedded Text Formatting in Reports
I’ve recently come to realize what a truly remarkable feature it is to be able to
format report text using simple...
2011-01-11
774 reads
Building Reports and Analytics on Dynamics CRM – Lessons (Being) Learned
In concept, designing reports is such a simple thing… you connect to a data source,
write a SQL query, optimize the...
2011-01-05
946 reads
Blogging on Blogging
So I must confess that my blogging efforts to date have been on the impersonal side
– perhaps even a bit...
2010-12-31
1,448 reads
Happy Holidays
I hope everyone is enjoying the holidays. To everyone in the SQL Server community,
Merry Christmas and Happy New Year. Spend...
2010-12-27
968 reads
Dashboard and KPI Design–the Definitive Industry Standard
First of all, the title is intended to be
a little tongue-in-cheek – just a little bit. I’ll explain. Last week
while I...
2010-12-15
434 reads
Preventing Subscriptions from Blocking Interactive Report Executions
A consulting client recently asked how they could resolve a capacity-planning issue
on their production report server. They manage a busy...
2010-12-15
650 reads
Are You Ready to Move to SharePoint for Microsoft BI?
I’m interested in hearing your response to this question. Microsoft is investing
aggressively in delivering Business Intelligence as a holistic platform...
2010-11-24
532 reads
Self-service Reporting in SQL Server “Denali”
Project “Crescent” is the name currently used to describe the new self-service reporting
capability to be released in the next version...
2010-11-14
612 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