Question: How to Forecast the Size of Restore of Backup in SQL Server?
Answer: Recently, I had discussed this in consulting engagement:
SQL SERVER – Always On Error: This Database is Encrypted by Database Master Key, You Need to Provide Valid Password When Adding it to the Availability Group
This database is encrypted by the database master key, you need to provide a valid password when adding it to the availability group.
SQL SERVER – Always On Listener Not Coming Online – Failed to Create New NBT Interface, Status 1450
I would share my learning about fixing error “Failed to create new NBT interface, status 1450 “in cluster log while creating the “IP Address” resource.
MySQL – Get Last Query Cost Using SHOW STATUS LIKE ‘Last_Query_Cost’
One of the most appreciated tips was about how to get Last Query Cost in MySQL using the command SHOW STATUS LIKE ‘Last_Query_Cost’.
SQL SERVER – Linked Server Error – Msg 3910 – Transaction Context In Use By Another Session
In this blog, I would share my understanding and the solution of Linked Server Error – Msg 3910 – Transaction context in use by another session.
Choosing a Processor for SQL Server
Choosing a Processor for SQL Server is always a challenge and I often find DBAs and organizations struggling with the same.
SQL SERVER – Stream Aggregate and Hash Aggregate
Recently during the on-demand consultation, I was asked a very interesting question about Stream Aggregate and Hash Aggregate.
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.