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.

Blog Post

Introducing ScriptDOM

I’ve been meaning to get a series of blog posts started on this topic. A twitter conversation from yesterday finally pushed me to it. Last year, I was tasked...

2022-02-04 (first published: )

556 reads

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,998 reads

Blog Post

Crocs and Naps….

I was planning a blog post for a TSQL2sday..instead would up writing an obituary blog post for a dear friend who passed on yesterday. Brian Moran was among the...

2021-07-23 (first published: )

345 reads

Blog Post

Data dictionary script

I restarted speaking with New Stars of Data today – I gave a talk on Database documentation. Below is the script I created to pull metadata into an excel...

2021-03-16 (first published: )

694 reads

Blog Post

Old but not gone…

I am part of a weekly talk show we run at the TriPASS user group, called ‘Shop Talk’. Shop Talk was the brainchild of Kevin Feasel, our key user...

2021-02-25 (first published: )

371 reads

Blogs

The Basics of TRY CATCH Blocks–#SQLNewBlogger

By

I was working with a customer and discussing how to do error handling. This...

Working with ALS – Insights from the Ability Summit

By

The 14th annual Ability Summit is a global event that I attended a few...

Apr 9 Webinar: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise

By

UPDATE: This moved to Apr 9 Join me Tuesday, Apr 9 for a webinar,...

Read the latest Blogs

Forums

Botched "Data warehouse" design...

By pietlinden

Someone landed a PowerBI mess in my lap, and near as I can tell,...

disaster recovery

By sqlfriend

We have two data centers in same city. One is our main site, the...

Set up Availability Group without a cluster to create read-only database

By koln

I want to have a a secondary ready-only database available for reporting, which is...

Visit the forum

Question of the Day

Backing up the Resource Database

How does the Resource database in SQL Server 2022 get backed up?

See possible answers