Problem Developing OLAP cubes have always been fascinating to me. Right after completing the development of a data warehouse, my next line of action often becomes setting up Analysis Services for the warehouse. Although, there are multiple client tools readily available in the market to perform some analysis on this SSAS Server, sometimes it is […]
2019-12-31
3,132 reads
Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]
2019-11-04
5,710 reads
2019-10-28
5,363 reads
Overview of ETL Architecture In a data warehouse, one of the main parts of the entire system is the ETL process. ETL is the system that reads data from the source system, transforms the data according to the business logic, and finally loads it into the warehouse. While fetching data from the sources can seem […]
2019-10-21
11,618 reads
The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, the row count significantly increased to 826K. There were no other changes made […]
2019-10-14
3,987 reads
Actually, these two topics don’t have anything to do with one another. I just...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
One of the features I was asked to implement for WorkloadTools is the ability...
Dear team, Hope all are safe and doing well, We have a Windows Server...
In Access, there is a LAST function, which simply allows you to do a...
Is there a way to find the field this error is being generated by?...
Ask SSC