Iterating Over Calculated Tables using Power Query
Problem Many of us are already aware of the loopin...
2020-04-07
5,695 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
9,898 reads
Database Normalization in SQL with Examples
Gouri Shankar provides an overview of normalizing a database.
2020-02-18
22,806 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
9,382 reads
Blogs
Daily Coping 24 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
DDL Trigger to log database level security commands.
In my last post I talked about reasons why your permissions might go missing....
Azure SQL Managed Instance Versions
By Arun Sirpal
Just a really quick FYI for the readers. If you are using Managed Instances...
Forums
value for the max date group by id
Hi everyone, I have data in my table as below date ...
Cannot log in to new SQL server
Hello, I'm fairly new to installing SQL 2019 standard and am having two issues....
Single Query Instead of a Cursor
Is it possible to rewrite this routine to be a single query, instead of...
Ask SSC