Create Display Sub Folder for Tabular SSAS Measures
If you have a SSAS tabular cube with a large number of measures in a particular measure group, you may want to group specific measures into display sub-folders. Display...
2014-05-13
12 reads
Blog Posts
Debugging a SQL Server query with WinDbg
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-05-13
2,301 reads
Does SQL Server do a CHECKDB during an instance restart?
When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server...
2014-05-13 (first published: 2014-05-07)
2,393 reads
SQL Server Debugging with WinDbg – an Introduction
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-05-13 (first published: 2014-05-05)
5,501 reads
The 3 Factors That Will Get You a Job You’ll Love
It’s T-SQL Tuesday time, and this month’s host, Boris Hristov (blog|twitter) chose the topic of interviews.
Over the time as a...
2014-05-13
720 reads
T-SQL Tuesday #54: An Interview Invitation
It’s time for another T-SQL Tuesday! This month’s blog party is hosted by Boris Hristov (blog | twitter) and the subject...
2014-05-13
774 reads
T-SQL Tuesday #54–Interviews and Hiring
It’s the May T-SQL Tuesday, and this time it’s a great one. This month the host is Boris Hristov (@BorisHristov)...
2014-05-13
1,144 reads
Verizon PCI and Data Breach Investigation Reports
If you deal with security and especially credit cards it’s worth spending an hour or two to read the 2014...
2014-05-13
441 reads
Add Node to Windows Server 2008 Cluster
Steps : Add Node to Windows Server 2008 Cluster
1) Open Cluster Administration wizard > Right click on Windows Cluster & select Add Node
2)...
2014-05-12
1,887 reads
Boost the performance of the VMware vSphere Web Client
Ever since it was released, the vSphere Web Client is not the most responsive of web GUIs. After some digging,...
2014-05-12
425 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