MDX Functions: TopCount
The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database. In the...
2012-03-12
2,256 reads
Bradley Schacht
Date Dimension Script with Fiscal Year
One dimension you can be positive will always make it’s way into your data warehouse is the Date dimension. Over...
2012-03-06
4,147 reads
Introduction to SharePoint BI Webinar Tomorrow
Tomorrow at 11AM Eastern time I will be presenting a FREE webinar for Pragmatic Works (website) on Introduction to SharePoint...
2012-03-06
623 reads
Speaking At SQL Saturday #110 in Tampa
I got word this week that one of my sessions for the upcoming SQL Saturday #110 in Tampa, FL was...
2012-02-10
430 reads
The Windows Search Engine Is Currently Disabled
If you have ever gotten this error message you may have been left scratching your head wondering why…kinda like me.
The...
2012-01-16
3,872 reads
Check Version of SharePoint 2010 Currently Installed
There are several ways to check the version of SharePoint 2010 currently installed in your environment. That about sums up...
2012-01-11
1,743 reads
The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.
You may fire up the SharePoint 2010 Management Shell (which allows you to run PowerShell commands to do cool SharePoint...
2012-01-05
2,235 reads
SharePoint 2010 Your Backup Is From A Different Version Of Microsoft SharePoint Foundation
Restoring a SharePoint site collection can be a pretty easy task. If your interested in how to do that check...
2012-01-04
1,562 reads
VirtualBox – Cannot Register the Hard Drive Because a Hard Drive with UUID Already Exists
Virtualization is awesome! It really helps when you are a developer. On my laptop I don’t even have SQL Server...
2011-12-21
5,391 reads
Mark a Disk Partition as Inactive
If you are like me then you like to reinstall Windows on your laptop every few months to keep things...
2011-12-20
895 reads
Blogs
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Forums
Where Your Value Separates You from Others
Comments posted to this topic are about the item Where Your Value Separates You...
Fixing the Error
Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Fixing the Error
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