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.

SQLServerCentral Article

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

18,372 reads

SQLServerCentral Article

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

12,767 reads

Blogs

What’s my MAC Address in a Command Prompt?–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

You don’t need a blockchain

By

After writing several posts about a neat feature in Azure SQL called system-versioned ledger...

Daily Coping 27 Oct 2021

By

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

Read the latest Blogs

Forums

Error connecting using AlwaysON Listener

By Arsh

Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...

How to get feature key and feature value separated $ based on part id ?

By ahmed_elbarbary.2010

I work on sql server 2012 i need to get featurekey and feature value...

Setting Up SQL Server 2019 for Optimal Performance

By water490

Hi I have a very large database (600GB) that I am looking at creating. ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers