Mala Mahadevan

My name is Malathi, a.k.a Mala - I am a DBA turned BI/Data Science person, working with SQL Server since 6.5. I am also founder of the Louisville SQL Server user group, organizer of 8 SQL Saturdays, Regional mentor for northeast, and 14-year PASS conference attendee. In my spare time I love to garden, travel, read, paint, and do yoga.

SQLServerCentral Article

Formatting T-SQL Scripts using ScriptDOM and PowerShell

Well-formatted scripts are always easier to maintain and enhance readability to high degree. Formatting standards are an important part of coding standards anywhere and if not, they need to be. If there are a large number of scripts this can add up to a significant amount of time needed to maintain them. It is also […]

4.4 (5)

2021-08-27

6,626 reads

SQLServerCentral Article

Querying database schema using graph tables

SQL Server 2017 introduced the concept of graph data tables as part of the SQL Server database engine. With SQL Server 2019, there were some enhancements like ‘shortest path’ function and constraints on edge tables that make this feature more usable – although it is far from a full-fledged graph database. Graph tables are essentially […]

4.2 (5)

2019-12-23

14,530 reads

SQLServerCentral Article

Querying Temporal Tables

Temporal tables a.k.a Table Versioning was introduced in SQL Server 2016 and is an easy, convenient way to track changes to data. A good introduction to temporal tables can be found here. One of the key advantages of versioning tables is easy of querying – or getting a ‘single pane of glass’ look of how […]

5 (2)

2019-07-29

12,467 reads

Blogs

Resources for Architecting Zero Downtime Deployments

By

I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...

Daily Coping 23 Mar 2023

By

Today’s coping tip is to focus your attention on the good things you take...

SQL Bits 2023 Recap

By

I had an amazing time adventuring to Wales with other members of the data...

Read the latest Blogs

Forums

Best way to ETL on large tablle with columnstore index

By SQL_Surfer

I have a table with 489M rows and growing. The reason we had to...

Unable To Create Transactional Replication - Microsoft SQL Error 20026

By maroju1

Hi All, This is Naveen Maroju. My previous DBA was created distribution database later...

Grouping the first letter in a string

By sathishkm

Hi All, I have the column of data in SQL Server. Here  I need...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Cloud Diagrams

See possible answers