Blueprint for consulting riches
As a business intelligence architect consultant, I have met many people out there who are as good or better than...
2012-07-09
1,527 reads
As a business intelligence architect consultant, I have met many people out there who are as good or better than...
2012-07-09
1,527 reads
If you are using partitions in SQL Server, be aware that “partition switching” is a great feature to quickly truncate partitions...
2012-07-05
7,950 reads
In the multidimensional model in SSAS, there is a storage mode called relational OLAP (ROLAP), which is the multidimensional solution...
2012-07-02
1,355 reads
SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product that is new to SQL Server 2012. The...
2012-06-27
5,186 reads
The requirements for Power View state that it can only use tabular models as data sources. So if you want to...
2012-06-25
2,309 reads
All the videos for this popular conference are online or will be soon (69 of them). Take a look at the...
2012-06-20
1,124 reads
When using the Tabular model in SSAS, the deployment options screen offers four choices for “Query Mode”: DirectQuery, DirectQuery with...
2012-06-18
13,904 reads
Microsoft has posted ALL the session videos for TechEd North America 2012 and they are available for free! What a...
2012-06-15
1,045 reads
Microsoft SQL Server Master Data Services (MDS) is a Master Data Management (MDM) product from Microsoft. Master Data Services is...
2012-06-08 (first published: 2012-06-04)
20,628 reads
Having done a number of presentations, I have accumulated a list of items to go over before each presentation to...
2012-06-06
1,158 reads
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
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