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 »
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 »
https://youtu.be/ph070n6lLU4 The use of AUTO SHRINK I think needs no explanation. Almost anybody who has worked on SQL Server understands the way databases can quickly grow. In these cases we can see growth happens in two places, the database file and the log file. The database file gets highly fragmented when it is shrunk. The… Read More »
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 »