Iterating Over Calculated Tables using Power Query
Problem Many of us are already aware of the loopin...
2020-04-07
7,708 reads
gourishankar
Mean Median Mode using SQL and DAX
This article explains how to calculate the important statistical functions, MEAN, MEDIAN, and MODE, in both T-SQL and DAX.
2020-02-28
24,967 reads
Database Normalization in SQL with Examples
Gouri Shankar provides an overview of normalizing a database.
2020-02-18
61,111 reads
Introduction to PIVOT operator in SQL
Learn how to use the PIVOT operator in SQL in a step-by-step manner.
2020-02-06
11,587 reads
Blogs
Microsoft Announcement: Microsoft Fabric
Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which...
Introduction to SQL Server Query Store
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...
Flyway with Multiple Folders
By Steve Jones
A customer asked about how they could organize their migration scripts in different ways...
Forums
Access db
Access db wanting to move sql server, how much control does business have over...
Iterate Through Tables, Using a Control Table w/ a List of Tables to Process?
I'm trying to create an SSIS package that will query a master control table...
Ask SSC