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
10,957 reads
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 […]
2019-12-31
3,545 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,265 reads
2019-10-28
5,463 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
11,962 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,064 reads
Blogs
What you need to know About Azure SQL backup
Most of DBA are coming from On-premise Database Servers they know very well How...
Social: Respecting Names
By Steve Jones
This is a non-technical post, and my opinion. If you don’t want to read...
Proud to present at this year’s VMworld 2020 conference
By kleegeek
I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is...
Forums
10 dead due to fire breaks out at hotel used as COVID care facility
A fire broke out in a hotel in Vijayawada in Andhra Pradesh on Sunday...
How to be an MVP
Comments posted to this topic are about the item How to be an MVP
Ask SSC