Happy Independence Day America and 10 Years Packt Publishing!
If you are in the USA, I hope you take some time today to enjoy your family and friends and...
2014-07-04
657 reads
DataOnWheels
T-SQL Window Functions – Part 2: Ranking Functions
This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...
2014-06-26
1,246 reads
T-SQL Window Functions – Part 1: The OVER() Clause
This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...
2014-06-26
2,736 reads
Exploring Excel 2013 for BI Tip #16: Exposing “Values” from a Tabular Model
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2014-06-19
1,170 reads
Exploring Excel 2013 for BI Tip #15: Locking Slicer Position
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2014-06-23 (first published: 2014-06-18)
4,293 reads
A Month, Almost Two Months Offline–Was the Silence Deafening?
The past couple of months has been very busy at home and at work so I have fallen behind a...
2014-06-18
699 reads
Techfuse, a New Laptop, and How Microsoft Azure Helped Save the Day
On Tuesday, April 22, I had the opportunity to speak at the Techfuse conference in Minneapolis. I was presenting a...
2014-04-24
682 reads
Oracle Tips for MSBI Devs #6: Supporting SSAS Tabular Development
As SQL Server Analysis Services Tabular Models become more popular, models will use Oracle databases as sources. One of the...
2014-04-14
1,114 reads
Ten Years and Counting …
On March 8, 2014, I reached ten years of service at Magenic Technologies. When I started in 1999 (don’t do...
2014-03-14
812 reads
Setting Up Tabular Models on Windows Azure
In my last post, I discussed how to set up Oracle in Windows Azure. During a customer call, there were...
2014-03-12
2,744 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