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)

You rated this post out of 5. Change rating

2021-08-27

7,896 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)

You rated this post out of 5. Change rating

2019-12-23

14,897 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)

You rated this post out of 5. Change rating

2019-07-29

13,646 reads

Blogs

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Adding Git LFS Support – #SQLNewBlogger

By

I got this message recently while committing some changes: This post shows my work...

EightKB 2024

By

EightKB is back! The biggest online SQL Server internals conference is back in 2024…it’s...

Read the latest Blogs

Forums

Downside to running a query in parallel

By water490

I am a SS rookie.  To me it seems like running a query in...

What Every DBA Should Know about Always On Readable Secondaries

By SQLSACT

Comments posted to this topic are about the item What Every DBA Should Know...

Filestream on Linux

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Filestream on Linux

Visit the forum

Question of the Day

Filestream on Linux

I want to implement a Filestream table on SQL Server 2022 running on Linux. Can I do this?

See possible answers