TSQL2sday – Daily database WTF
This month’s TSQL Tuesday is organized by Kennie T Pontoppidan(t) – the topic is ‘Daily Database WTF‘ – or a horror story...
2017-03-12
434 reads
Mala's Data Blog
Generating Frequency Table
This week’s blog post is rather simple. One of the main characteristics of a data set involving classes, or discrete...
2017-03-20 (first published: 2017-03-06)
7,660 reads
The Empirical Rule
I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning...
2017-03-02 (first published: 2017-02-27)
2,486 reads
SQL Cruise 2017 – Western Carribean – my experience
As some readers may know, I am a regular attendee on SQL Cruise s for 8 years now. SQLCruise is...
2017-02-19
610 reads
My Epic Life Quest
I have always maintained a private bucket list. I have not had the courage to actually put it down in...
2017-01-13 (first published: 2017-01-02)
1,912 reads
2016 – A Year to remember
2016 has undoubtedly been a landmark year in my life. To me it marked my first conscious entry into mid...
2016-12-31
799 reads
Multivariate Variable Analysis using R
So far I’ve worked on simple analytical techniques using one or two variables in a dataset. This article is a...
2016-12-05
926 reads
Associative Analytics: Two sample T Test
In the previous post we looked at a one way T-Test. A one way T Test helped us determine if...
2016-11-25 (first published: 2016-11-21)
2,482 reads
PASSion Award and what it means to me
2016 is going to be a special year in my life. There was an article on Oscar awards a while...
2016-11-04 (first published: 2016-10-31)
1,719 reads
Days 1,2 and 3 of PASS Summit 2016
Today is Thursday, October 27th already. For some of us the summit begins monday – with precons and PASS Volunteering related meetings...
2016-10-27
392 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
WHERE condition using ='value' returns different results that using IN('value')
Have an interesting scenario - user found a discrepancy with rows returned when running...
Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date
I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model',...
Unknown Token Received From SQL Server
I have an issue when a stored procedure is executed from the SQL Server...