Dynamically process SSAS Cube from SSIS package
Learn how you can modify an SSIS package to dynamically process SSAS cubes.
2020-01-13
4,163 reads
aveek22
Setting up Management Studio for remote SQL Server
Learn how to configure SQL Server and Windows to allow others to connect to an instance remotely.
2020-01-06
19,110 reads
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 […]
2019-12-31
3,892 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. […]
2019-11-04
6,928 reads
2019-10-28
5,522 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 […]
2019-10-21
12,302 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 […]
2019-10-14
4,120 reads
Blogs
Database DevOps Deployment to Azure–Webinar
By Steve Jones
You can register now, but on Dec 3, I have a webinar with Microsoft...
[PowerShell Newbie] Using Start-Transcript
By gbargsley
This week we are going to launch a blog series geared towards folks that...
My Experience on Geeks on Screen with Coffee
Last week on appeared on Geeks on Screen with Coffee which broadcast on YouTube...
Forums
Finding Thanks
Comments posted to this topic are about the item Finding Thanks
Python Static Methods
Comments posted to this topic are about the item Python Static Methods
Query SSISDB For Components
Evening All, I want to identify all SSIS packages deployed into SSISDB that contain...
Ask SSC