Being careful in SSAS to not make a cube/dimension unprocessed
A big headache in SSAS, especially when dealing with a large cube, is making a change that when deployed, causes...
2012-05-21 (first published: 2012-05-16)
3,137 reads
A big headache in SSAS, especially when dealing with a large cube, is making a change that when deployed, causes...
2012-05-21 (first published: 2012-05-16)
3,137 reads
I see a lot of confusion on what exactly is the difference between a data warehouse and a data mart....
2012-05-14
30,936 reads
I have previously blogged about Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server Reference...
2012-05-02
2,670 reads
I received this error the other day when trying to process a particular SSAS cube:
Error 18 File system error: The...
2012-04-30
2,900 reads
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at Houston SQLSaturday.
Here is the PowerPoint presentation: Scaling...
2012-04-22
921 reads
As a follow-up to my SQL Server 2012: New Certification Info, Microsoft Learning has announced the certification tracks for the SQL Server...
2012-04-18
7,441 reads
I will be speaking at the Houston SQLSaturday this upcoming Saturday (April 21st). Below is info on my session, which...
2012-04-16
627 reads
SQL Server Data Tools (SSDT) is a Business Intelligence Development Studio (BIDS) replacement, meaning it has a suite of Visual...
2012-04-13
11,494 reads
I blogged previously that when you are a consultant or contractor, you can sometimes be faced with the decision when...
2012-04-11
5,549 reads
When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when...
2012-04-09
1,956 reads
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
A bali trip is a dream vacation for travelers who want to experience beautiful...
A bali trip is a dream vacation for travelers who want to experience beautiful...
Comments posted to this topic are about the item Where Your Value Separates You...
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers