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

4,623 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,066 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

11,422 reads

Blogs

Daily Coping 30 Nov 2021

By

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

Fail activity in Azure Data Factory and Why would I want to Fail

By

(2021-Nov-30) I heard a story about a young person who was asked why she was...

Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger

By

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

Read the latest Blogs

Forums

Can't figure out why SQL 2012 SP3 Express installation is failing

By axpresbom

One of the software we use requires SQL 2012 express, but installation fails every...

Connecting to listener lands on secondary node

By Divine Flame

Hi Folks, I have been observing a weird issue. We have one SQL 2017...

MSSQL Replication

By CliveG

Hi, I am using the following: 2 x freeradius servers on Redhat 2 x...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers