Archana

Archana has been working as a freelance consultant in the Microsoft Data Platform for the couple of years now. Prior to this, she has worked on other technologies like Oracle and OBIEE as a RPD Data Modeler. Her main areas of interests are Database Design, Modeling and Data Visualization. She also conducts short webinars for students who are new into this field. In her leisure, she likes to spend time in her kitchen and gardening.

Create Custom Functions in Power Query

Introduction Often at times, you may come across situations where you need to calculate a column repeatedly multiple times in the same Power BI report or across multiple reports. Although you can use the calculated columns to some extent, these are not robust and not reusable. In order to reuse the same piece of code, […]

5 (2)

2020-04-21

9,870 reads

Calculate Moving Averages using T-SQL in SQL Server

Introduction In Financial Data, analyzing the Moving Average (MA) is a very common practice. The direction of the moving average conveys important information about prices, whether that average is simple or exponential. A rising moving average shows that prices are generally increasing. A falling moving average indicates that prices, on average, are falling. This article […]

5 (4)

2020-02-04

10,172 reads

Blogs

T-SQL Tuesday #137–Notebook Uses

By

It’s actually my month to host T-SQL Tuesday, and I came up with the...

Daily Coping 13 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Converting a SQL Server Docker image to a WSL2 Distribution

By

Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...

Read the latest Blogs

Forums

Using Cluster Aware Update - Applying Windows Update to SQL Server part of AG

By curious_sqldba

Is there any official Microsoft documentation around why Cluster aware update cannot be used...

sql server 2019 standard edition intallation question

By juliava

for installation sql server standard edition for instance id should I put server name?...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers