SQL Server Techniques

 Using the " REPLACENULL " functionality frequently in the "Derived Column" component, the "Conditional Split"...

If you process SSAS cubes via SSIS packages you might notice a weird message like " Full Processing:Warning: Server: Operation complete...

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 ...

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 ...

After you build Power BI dashboard you want to make sure that everything is set as it supposed to be. Or, you are troubleshooting PBI dash...

By doing heavy calculations with big integer numbers I've hit Power BI whole number limit, which is "9,007,199,254,740,992". ...

Power BI is not always friendly to BI developer and you need to do some work around to get what you need. Here is a simple case: The Pro...

Got a request from a customer earlier today about very strange error: Something went wrong Unable to load the data model for your Power...

Just want to introduce a sample Power BI report with some Power Query use. Description:  - A single Power BI file " PassSummit_Sche...