Category Archives: Uncategorized

In this post I have pasted the script used in the Youtube video on how Partitioning can improve query performance.

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 »

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 »

In this video we continue with how to secure Azure SQL Databases based on the security best practices mentioned in the last video. We cover how to create a Azure SQL Database and SQL Server. Identify what features are enabled by default and what’s not. We then move on to enabling Auditing Advanced Threat Detection… Read More »

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 »

Saw this question on the forum and wanted to highlight how easy it is to over complicate a simple query. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/75264de5-9a32-40f4-b9ce-e430d77b77fe/case-when-is-not-working-please?forum=transactsql 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 »

Every once in a while I take a moment to think about something other than work. Often these thoughts are governed by the hot topics of the day and while there has been no shortage of such topics; a conversation I was having on LinkedIn recently is the one for this post (It is also… Read More »

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 »

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 »