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.

Script to create demo database and load data for statistics and R

by Mala Mahadevan

Mala's Data Blog

Make sure you have a working install of SQL Server 2016. The size of the database is only 8 MB.
USE...

2016-07-15

295 reads

Descriptive Statistics with SQL and R – 1

by Mala Mahadevan

Mala's Data Blog

I started my re-discovery of statistics with an introduction here. This second post is about descriptive statistics – very basic, simple...

2016-07-14

1,105 reads

Basic Statistics with SQL – Introduction

by Mala Mahadevan

Mala's Data Blog

I was a student of statistics in school and college. I didn’t get to use much of anything I learned...

2016-07-10

675 reads

TSQL Tuesday #75 – PowerBI

by Mala Mahadevan

Mala's Data Blog

This month’s TSQL Tuesday post is from one of my favorite people in the community – Jorge Segarra a.k.a. SQL Chicken. It...

2016-02-17

446 reads

Advent of Code – Day 2 – Using Cross apply

by Mala Mahadevan

Mala's Data Blog

For this post i worked on second puzzle in the Adventofcode series. This wasn’t as challenging as the first one, but...

2016-02-02

298 reads

Advent of Code – Day 1 – Parsing a variable

by Mala Mahadevan

Mala's Data Blog

I have been following the series of posts written by my friend and SQL MCM Wayne Sheffield on some TSQL...

2016-01-19

259 reads

Comparing data in two identical tables

by Mala Mahadevan

Mala's Data Blog

Continuing with the recipes in SQL Server 2012 T-SQL recipes book – I was drawn to this puzzle that asked for...

2015-12-14

775 reads

Blogs

A New Word: Dolorblindness

dolorblindness – n. the frustration that you’ll never be able to understand another person’s...

Claude Code Helps Analyze Test Data Manager Log Files

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

PowerPoint to HTML with Claude AI

I had an idea for an animated view of a sales tool, and started...

Read the latest Blogs

Forums

Optimism Without Illusion or Why AI Needs Blunt Technologists

Comments posted to this topic are about the item Optimism Without Illusion or Why...

SSIS with VS2022 64/32 issue with Excel files

Hi all, I'm trying to do classic scenario for loading multiple Excel files into...

Case part is sloooooow

Hi So the case statement is slowing this down - but for the life...

Visit the forum

Question of the Day

The String Distance I

In SQL Server 2025, what is returned by this code:

SELECT EDIT_DISTANCE('tim', 'tom')

Assume preview features are enabled.

See possible answers