Category Archives: Uncategorized

How WITH (NOLOCK) can degrade performance

By | December 11, 2019

I was recently asked by a company to have a technical call for a training requirement. The “Senior Database Architect” insisted I only talk about concurrency issue. I tried to explain that concurrency is just one aspect of tuning and using some features are a double edged sword. As an example I wanted to show… Read More »

SQL 2019- Licensing

By | November 11, 2019

In this post I will try to explain SQL 2019 licensing in the simplest way possible. Do you need to worry about SQL Express, Web or Developer edition? No not really, we are only exploring production workloads, and none of the editions above are used in true production workloads. Besides they are practically free (even… Read More »

Turning into cyborgs

By | October 24, 2019

The Year is around 1964, Jawaharlal Nehru is the prime minister of India. India is reeling under Inflation and has borrowed so much that nobody will lend her any money. Droughts and the Wars have made the nation weary. Jobs are few and far between and most people are still dependent on the Governments socialist… Read More »

Writing good TSQL vs Bad

By | October 15, 2019

Saw this question on the forum and wanted to highlight how easy it is to over complicate a simple query. A perfect example of Programmatic access vs Set based querying. The developer has an unhealthy obsession with CASE statements and as you can see from the post he is now facing issues as a… Read More »

Make the List and Stick to it

By | July 26, 2019

Every few weeks I am approached by someone on LinkedIn on how to go about starting the business or improving the way they work etc. To be honest I won’t claim to be an expert in this field (by any measure) but the fact that people ask me these question tells me that I must… Read More »

Report on Self harm

By | March 18, 2019

Recently we were given access to some data for self-harm statistics collected by WHO. Here are the important points Highest risk category are millennial males nearing the age of 25 in the Americas. Below is a screen grab of the basic report. Further analysis can be found below:- Data for regions like Africa and Middle… Read More »