This article explains how to calculate the important statistical functions, MEAN, MEDIAN, and MODE, in both T-SQL and DAX.

Reviewing Your Past Efforts

by Steve Jones

SQLServerCentral

Career Growth

Today Steve starts a mid year review of his career goals and encourages you to do the same.

Enterprise Insights from the 2020 State of Database DevOps report

by Additional Articles

Redgate

DevOps and Continuous Delivery (CI/CD)

17% of Enterprise respondents in this year's State of Database DevOps survey reported that DevOps has been adopted across all projects in their organization. This year’s State of Database DevOps report gave us some great insights into the landscape of Database DevOps. Kendra Little walks us through those insights specific to Enterprise organizations.

Introduction to Azure SQL Database Auto-Failover Groups

by Additional Articles

Database Journal

Azure SQL Database offers a number of resiliency features that deliver a mix of high availability and disaster recovery capabilities

New: 2020 State of Database DevOps report

by Press Release

Redgate

DevOps and Continuous Delivery (CI/CD)

Now in it’s 4th year, the State of Database DevOps report continues to deliver valuable insights. In the report, you will learn multiple tactics to improve the quality of database code deployment, whether it is by changing the type of environment used for development, enhancing your code review practices, or your change management/approval practices.

Data Orchestration

by Steve Jones

SQLServerCentral

Steve talks data virtualization in the age of growing data sets and larger workloads

Exploring the DATE Functions in SQL

by aveek22

SQLServerCentral

Learn more about using the DATEADD function in SQL...

But the Database Worked in Development! Checking for Duplicates

by Additional Articles

SimpleTalk

DevOps and Continuous Delivery (CI/CD)

As developers should not have access to production data, it’s possible that duplicate values can sneak in during migrations. In this article of the series, Phil Factor demonstrates a way to check for duplicates when unique constraints are disabled.