aveek22

Browsing SSAS Instance over the internet

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 […]

5 (3)

2019-12-31

3,132 reads

How to filter non-existing records in SQL

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. […]

4 (6)

2019-11-04

5,710 reads

Modular ETL Architecture Design in SSIS

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 […]

4 (2)

2019-10-21

11,618 reads

A User-Defined Function returns more rows

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 […]

4 (5)

2019-10-14

3,987 reads

Blogs

Unit Testing & Intelligent Query Processing

By

Actually, these two topics don’t have anything to do with one another. I just...

Daily Coping 31 Mar 2010

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Replaying Workloads to a different Database

By

One of the features I was asked to implement for WorkloadTools is the ability...

Read the latest Blogs

Forums

SSRS report font settings

By Tomys

Dear team, Hope all are safe and doing well, We have a Windows Server...

How to find Last Record with multiple results

By dzirkelb

In Access, there is a LAST function, which simply allows you to do a...

Arithmetic overflow error converting expression to data type nvarchar.

By cbrammer1219

Is there a way to find the field this error is being generated by?...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Cloud Time

See possible answers