Category Archives: Uncategorized

Tackling Corona Virus Long Term

By | March 21, 2020

At this point it seems Corona and its impact is here for the long term. As the days go by I see even more people taking extreme measures often out of fear or a lack of understanding the problem. Social media and Whatsapp has played its share too. The spread of Corona can happen through… Read More »

DB Options: SET ANSI Nulls

By | March 18, 2020

https://youtu.be/QfB2v6QQej8 ANSI NULLS dictate how SQL Server responds when the equal to (=) operator is used to check for NULLs. Keep in mind that the IS NULL condition works regardless of what ANSI NULL setting is used. When ANSI NULLS are ON using a query like ColA =NULL will not return any results. Setting ANSI… Read More »

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. 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 »