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. […]
2021-11-26 (first published: 2019-11-04)
15,761 reads
Introduction This article will help you install the Docker Desktop for Mac. Before we show that, let us start by understanding what the Docker Desktop software can do for you. To understand Docker, we need to understand what a container is. If you remember a few years ago, the only way of deploying application code […]
2021-04-20
1,528 reads
This article is focused on beginners who have already started writing SQL queries and are now diving deep towards more data processing and complex queries in SQL. When we talk about data processing, an important concept that comes to our mind is performing ETL workloads to a data warehouse. ETL is a very complex topic […]
2021-01-26
4,886 reads
This article explains how to get started with PostgreSQL on AWS.
2020-12-15
1,744 reads
This article covers how to install PostgreSQL on the macOS.
2020-11-19
3,751 reads
Learn how you can fix the duplicated key error in SSAS without editing the source data.
2020-05-05
8,073 reads
Introduction In this article, I'll explain the use of the RANKX function available in DAX. The RANKX is a sortation function which is capable of performing a quite complex sorting and ranking based on the groups and values available in the dataset. It returns the ranking of a particular number available in each row of […]
2020-03-12
20,252 reads
This article explains a way to use labels (last year, YTD, etc.) for report parameters.
2020-03-05
6,879 reads
2020-02-27
23,584 reads
When the database design is not great, you may have to write some creative queries to get what you need.
2020-02-17
3,466 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WA:08218154393 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur, Daerah...
WA:08218154393 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers