Recently I walked into a very interesting situation with this blog. As many of you may know that this blog is hosted on Linux server and runs with MySQL and PHP. Self-hosted WordPress is the platform for this blog.
SQL SERVER – Invalid Object Name ‘master.dbo.spt_values’ in Management Studio
One of my clients contacted me for On Demand (55 minutes) as they believed that this was a simple issue. John was honest enough to confess the mistake which he has done, which lead to error related to invalid object name.
SQL SERVER – Can I Delete Always On Availability Groups Initial Sync Folder?
This was one of an interesting question which I heard from one of my clients who deployed AlwaysOn availability groups. I was not able to find much documentation and clarity so did some research and found an answer. This can also be an interview question as well.
SQL SERVER – Interesting Observation – Count of Temporary Table Re-generations
The best part of my SQL Server Performance Tuning Practical Workshop is that at the end of the workshop we spend quite a good amount of time to solve the issues users have in their production system. During one of the recent workshop, I was asked a very interesting question  about temporary tables.
SQL SERVER – How to See Scripts Executing in sp_executesql?
Question: How to See Scripts Executing in sp_executesql?
NuoDB – 3 Important Features of Elastic SQL Database Every One Must Know
During during a consulting engagement, I was asked if I know anything about NuoDB and what is my opinion about it. Well, NuoDB has been my favorite Elastic SQL Database and I have been using it for a while where I find relational database hits their limits and NewSQL solution NuoDB is the solution.
SQL SERVER – Why Edition Upgrade is Not Upgrading Edition of SQL Server?
Sometimes many DBAs are so expert in many areas like performance tuning or backup/restore, they miss simple stuff. One of my DBA friends was running Standard Edition of SQL Server 2016 in production and want to upgrade the edition to Enterprise – core based edition. Let us learn about Edition Upgrade issue.Â
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.