Friday, June 13, 2025

Case Sensitivity in XML Extraction (Part II)

›
     In my previous post I showed an elegant way to extract case sensitive data from an XML, but what if we'd like to use that method to...
Saturday, April 26, 2025

Case Sensitivity in XML Extraction

›
I recently encountered an interesting issue where XML elements had similar names but differed in character capitalization. Lets show it via ...
Friday, February 7, 2025

SSIS: REPLACENULL does not support (DT_DBTIMESTAMP2,7)

›
 Using the " REPLACENULL " functionality frequently in the "Derived Column" component, the "Conditional Split"...
Thursday, January 30, 2025

SSIS warning message about SSAS Cube processing: "Operation completed with XXX problems logged"

›
If you process SSAS cubes via SSIS packages you might notice a weird message like " Full Processing:Warning: Server: Operation complete...
Monday, May 13, 2024

Caveats of using an Expression for SQL Script in SSRS.

›
Why : Most of the time, when you want a flexibility of your SQL query you can use parameterization. However there might be a situation when ...
Sunday, February 7, 2021

Monitoring Analysis Server (SSAS) using Spotlight (Quest Software)

›
 This post is just answering two simple questions: 1. Can Quest Software's Spotlight successfully monitor SQL Server Analysis Server? 2....
Monday, July 27, 2020

SSRS. Use of Lookup type functions.

›
There is a lot of blog posts in the Internet about how to use Lookup and other functions of this type in SSRS. It is very straight forward ...
5 comments: