I am happy to write this blog post as I am really happy that finally, SQL Server Engineering team has decided to fix the error which we all have been struggling for many years. I will say Since the year 2000, I have been working with SQL Server and it has always bothered me that every time when I try to insert data into my table which is larger than the data type of the column, I got an annoying error String or binary data would be truncated. I recently demonstrated this to my Comprehensive Database Performance Health Check.
How to Compile Queries and Not Execute Them? – Interview Question of the Week #219
Question: How to Compile Queries and Not Execute them?
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘SSIS_hotfix_install.sql’ Encountered Error 15151
Recently I was helping a client where SQL Server upgrade was failing with an error. If you have seen my blogs, there have been many blogs where I explain steps to fix upgrade-related issues. In this blog, we would learn about fixing another cause of script level upgrade for database ‘master’ failed.
SQL SERVER – Error in Validation: Listener in Workgroup – Unable to determine if the computer exists in the domain ‘WORKGROUP’
There are many deployments where I have assisted my clients in creating Always On Availability Groups. Sometimes they come to me with special requirements, based on their infrastructure, and I always learn from them. In this situation, my client was trying to create a listener in a workgroup, and it was failing with error: Unable to determine if the computer ‘ListenerName’ exists in the domain ‘WORKGROUP’
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘msdb110_upgrade.sql’ Encountered Error 8649, State 1, Severity 17
While trying to upgrade my SQL instance to the latest patch of SQL 2017, I encountered an issue. This has happened earlier with a few of my clients earlier but this time the cause was different. In this blog we would learn about cause and the fix of upgrade error:
Registration Open for SQL Saturday Helsinki Workshop 2019
I am super excited that I will be visiting Helsinki SQLSaturday 2019. I will be delivering a day-long post-conference on my most popular workshop – Practical Real-World SQL Server Performance for Everyone.
SQL SERVER – A Brief History of Deadlock and Modern Approach of Resolution
Every time we talk about deadlock, you will see DBA frowning on this topic. DBA believes that Developers are creating the deadlocks and developers believe that DBA’s should be taking care of the deadlocks. Essentially, it is such a subject which requires DBA and Developers to work together to resolve the issue.
Registration Open for SQL Saturday Stockholm Workshop 2019
I am super excited that I will be visiting Stockholm SQLSaturday 2019. I will be delivering a day-long pre-conference on my most popular workshop – 21 Essential Scripts: Performance Tuning for EVERYONE.
How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? – Interview Question of the Week #218
Question: How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement?
Consulting Wrap Up – What Next and How to Get Started
This is the wrap-up post of my 5 part series on my over 10 years of experience in Comprehensive Database Performance Health Check consulting engagement.