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)

You rated this post out of 5. Change rating

2020-04-21

41,256 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)

You rated this post out of 5. Change rating

2020-02-04

22,506 reads

Blogs

Focus on Core Skills

By

Core skills depends on the position, but the point is that ensuring you have...

A New Word: Zverism

By

zverism – n.  the wish that people could suspend their civility and indulge in...

SQL Server Source Control on a $0 Budget

By

The Source Control Dilemma Every DBA has been there. Trying to keep track of...

Read the latest Blogs

Forums

Move Files SSIS Task

By water490

Hi I have a task in my SSIS package that moves files from source...

Migrating mission critical database from SQL on Prem to Azure SQL

By Mikael Åkerblom

We are migrating our environments to Azure, it will be a mix of SQL...

The Inefficiencies of Kubernetes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Inefficiencies of Kubernetes

Visit the forum

Question of the Day

The Backup Space Needed

How do I calculate the amount of space needed for I/O buffers during a backup operation?

See possible answers