Subscribe to this blog
Archives: November 2011
SQL Server 2012 Master Data Services Error: The required .svc handler mappings are not installed in IIS.
Microsoft SQL Server 2012 Release Candidate 0 (RC 0) has a confirmed issue with Master Data Services configuration. The following error is raised by the Master Data Services Configuration Manager when launched:
Before creating an MDS web application, you must correct the following errors:
Internet Information Services (IIS) is not…
0 comments, 510 reads
Posted in Business Intelligence & SQL Server Decaffeinated on 29 November 2011
SQL Saturday 86 BI Edition Tampa 2011: Afterthoughts
Wow! Just Wow! That’s all I can say to describe how great SQL Saturday 86 was on November 5th in Tampa, FL . I got so much positive feedback from every attendee, speaker and sponsor. Food was great, sessions were amazing, speakers were first class! I have to say thanks… Read more
0 comments, 401 reads
Posted in Business Intelligence & SQL Server Decaffeinated on 16 November 2011
The CASE of the missing non-NULL T-SQL Error: None of the result expressions in a CASE specification can be NULL.
Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my CASE statements. The error received was:
None of the result expressions in a CASE specification can be NULL.
It was a long T-SQL script (and a long night) and could… Read more
3 comments, 420 reads
Posted in Business Intelligence & SQL Server Decaffeinated on 16 November 2011