-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Mala's Data Blog

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 12-year PASS conference attendee. In my spare time I love to garden, travel, read, paint, and do yoga.

Ohhhhhh S…t!! A tribute to Robert Davis

Today marks 3 days since we’ve lost Robert Davis a.k.a SQLSoldier, one of the pillars of SQL Family community.
I was introduced to Robert many years ago at one of the PASS Summits. I had known of him as a SQL genius well before that. One of my good friends… Read more

1 comments, 2,735 reads

Posted in Mala's Data Blog on 5 April 2018

Data experiments with salary survey – I

As someone who just crossed three decades of working in technology – I have a sudden renewed interest in understanding how careers in technology evolve with age or years of experience. Those of us older in this industry are among the first generation who have worked almost an entire career… Read more

0 comments, 2,435 reads

Posted in Mala's Data Blog on 12 March 2018

My experience with TechOutbound 2018 – Caribbean

I am a passionate, regular attendee of Techoutbound (formerly SQLCruise) events. I try to do at least one every year.  This year’s cruise on east coast was to East Caribbean – with an itinerary that was different from original because of hurricane related issues in the area. We were doing… Read more

0 comments, 232 reads

Posted in Mala's Data Blog on 26 February 2018

DBA best practices..from the DBA from Heaven

I met Tom Roush for the first time around 9 years ago – at a PASS Summit. If I recall right –  Kendra Little introduced him to me as a colleague from Microsoft and a friend of hers. I met him at several summits following that – found him a… Read more

0 comments, 453 reads

Posted in Mala's Data Blog on 1 February 2018

SQL Saturday Nashville 2018

I decided to go to the SQL Saturday at Nashville this year to get some good learning and networking in during frigid January. One of the reasons I wanted to go was that the line up for precons was amazing and I wanted to learn more on Azure particularly. I… Read more

0 comments, 267 reads

Posted in Mala's Data Blog on 15 January 2018

T-SQL Tuesday #97 Roundup: Learning goals for 2018

T-SQL Tuesday is a monthly blog party started by respected SQL Guru Adam Machanic. I was honored with hosting this month’s party. I picked a topic that is important for me at this time of the year – setting learning goals. I was surprised and somewhat overwhelmed to see the… Read more

0 comments, 545 reads

Posted in Mala's Data Blog on 18 December 2017

T-SQL Tuesday #97 – My learning plan

This month’s T-SQL Tuesday is hosted by…er..yours truly. I picked a topic that usually comes up for me every December – learning goals for the next year. This is the first time that I am blogging about it.

Usually this review is accompanied by a strange combination of imposter syndrome,… Read more

1 comments, 1,936 reads

Posted in Mala's Data Blog on 11 December 2017

T-SQL Tuesday #97 – Setting learning goals for 2018

 
This is my first opportunity hosting a T-SQL Tuesday and am super excited!!
T-SQL Tuesday is the brainchild of well respected SQL Guru and author of ‘sp_whois active’ – Adam Machanic (b|t).  Adam rightly predicted that we all could benefit from ‘a recurring, revolving blog party’…

Read more

42 comments, 583 reads

Posted in Mala's Data Blog on 4 December 2017

TSQL Tuesday #96 – Folks who have made a difference

This month’s T-SQL Tuesday is hosted by Ewald Cress, and the topic is ‘Folks who have made a difference’. This is an opportunity – and right around thanksgiving – to give a shout-out to people who have made a difference in our careers and in the data community. To… Read more

1 comments, 314 reads

Posted in Mala's Data Blog on 14 November 2017

Dealing with disquiet

Last week I listened to a podcast from one of my best friends in the sql community – Kendra Little. In this podcast Kendra talks of her encounter with anxiety attacks and how she dealt with them. When I listened to her honest, moving story – my mind was filled… Read more

0 comments, 1,739 reads

Posted in Mala's Data Blog on 11 November 2017

PASS Summit 2017 – the best ever

I have been a PASS summit attendee for 14 years now. This year is my 15th. Every year is different – some years are better than others, some make you feel it wasn’t as good as usual. This year was an odd experience for me. Quite a number of my… Read more

0 comments, 490 reads

Posted in Mala's Data Blog on 5 November 2017

Understanding ANOVA

ANOVA – or analysis of variance, is a term given to a set of statistical models that are used to analyze differences among groups and if the differences are statistically significant to arrive at any conclusion. The models were developed by statistician and evolutionary biologist Ronald Fischer. To give a… Read more

0 comments, 1,801 reads

Posted in Mala's Data Blog on 9 October 2017

Box-and-whisker plot and data patterns with R and T-SQL

R is particularly good with drawing graphs with data. Some graphs are familiar to most DBAs as it has been things we have seen and used over time – bar charts, pie diagram and so on. Some are not. Understanding exploratory graphics is vitally important to the R programmer/data science… Read more

0 comments, 1,790 reads

Posted in Mala's Data Blog on 25 September 2017

Confidence Intervals for a proportion – using R

What is the difference between reading numbers as they are presented, and interpreting them in a mature, deeper way? One way perhaps to look at the latter is what statisticians call ‘confidence interval’.

Suppose I look at a sampling of 100 americans who are asked if they approve… Read more

0 comments, 1,104 reads

Posted in Mala's Data Blog on 18 September 2017

What is networking, really?

I am still trying to get up to speed on blogging after a gap. Today I managed to push myself to write some R code and test it, and it worked. Am getting there, although need more work to turn it into a blog post. So, here is another on… Read more

1 comments, 1,441 reads

Posted in Mala's Data Blog on 10 September 2017

14 years of Summit…

I have been trying to get my blogging going again after a gap of two months. It has been incredibly hard. To warm up, I decided to try some non technical posts. One of them is stuff I have been wanting to write a long time – with this year… Read more

1 comments, 381 reads

Posted in Mala's Data Blog on 4 September 2017

Getting back to blogging

The past two months have been very hectic for me. I had an unexpected job offer towards end of July, which I gladly accepted – that was followed by some much needed home renovation, and a long vacation/tour of the west coast with my beloved sister. All of this has… Read more

0 comments, 386 reads

Posted in Mala's Data Blog on 28 August 2017

Understanding Relative Risk – with T-SQL

In this post we will explore a common statistical term – Relative Risk, otherwise called Risk Factor. Relative Risk is a term that is important to understand when you are doing comparative studies of two groups that are different in some specific way. The most common usage of this is… Read more

2 comments, 1,777 reads

Posted in Mala's Data Blog on 19 June 2017

Cochran-Mantel-Haenzel Method with T-SQL and R – Part I

This test is an extension of the Chi Square test I blogged of earlier. This is applied when we have to compare two groups over several levels and comparison may involve a third variable.
Let us consider a cohort study as an example – we have two medications A and… Read more

0 comments, 401 reads

Posted in Mala's Data Blog on 12 June 2017

Dataset for Cochran-Mantel-Hanzel Test

Below is the script to create the table and dataset I used. This is just test data and not copied from anywhere.

USE [yourdb]
GO
/****** Object: Table [dbo].[DrugResponse] Script Date: 6/12/2017 6:45:46 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIERl ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DrugResponse](…

Read more

1 comments, 336 reads

Posted in Mala's Data Blog on 12 June 2017

Older posts