Resources from the PASS community this coming month
Even though it is December, I noticed a lot going on for FREE in the PASS Microsoft Data Technology community....
2017-11-30
605 reads
The Smiling DBA
IT Dev Connections 2017
The IT Dev Connections conference was in San Francisco, CA this week. While I did not spend any time as a tourist, I did mingle with attendees and speakers....
2017-10-25
8 reads
IT Dev Connections 2017
The IT Dev Connections conference was in San Francisco, CA this week. While I did not spend any time as...
2017-10-25
385 reads
SSAS Tabular DirectQuery–No Hierarchies in Dimensions
I recently was testing DirectQuery to see the reporting differences in a Tabular Model. After Deploying to a development server and analyzing in Excel, the hierarchies for the Date...
2017-09-29
78 reads
SSAS Tabular DirectQuery–No Hierarchies in Dimensions
I recently was testing DirectQuery to see the reporting differences in a Tabular Model. After Deploying to a development server...
2017-09-28
878 reads
Elect The Next PASS Board Members
The PASS board elections are coming up and there is a twitter chat event to ask questions to the candidates before you vote. Both tweeter events will be on...
2017-09-13
8 reads
Elect The Next PASS Board Members
The PASS board elections are coming up and there is a twitter chat event to ask questions to the candidates...
2017-09-12
504 reads
Analysis Services Series on SQLShack
Please visit SQLShack.com for new articles on many facets of SQL Server. I have been trying my best to document how to create SQL Server Analysis Service databases with...
2017-08-17
24 reads
Analysis Services Series on SQLShack
Please visit SQLShack.com for new articles on many facets of SQL Server. I have been trying my best to document...
2017-08-16
741 reads
SQLSaturday Baton Rouge #628 2017
Come join around 500+ attendees and speakers learning and networking at the LSU College of Business – Business Education Complex on Nicholson Drive Extension in Baton Rouge on Saturday...
2017-07-21
3 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