In this blog, I would share my learning about error “Unable to allocate enough memory to start ‘SQL OS Boot’. Let us learn the workaround.
How to Forecast the Size of Restore of Backup in SQL Server? – Interview Question of the Week #265
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.
How to Measure Resource Status on Azure? – Interview Question of the Week #264
Every single time when I start working with Azure, I always want to know what is the status of Azure resource status or consumption in the last hour.
MySQL – Download Sample Database – Sakila, World, Employee
However, whenever we are exploring the new feature, it is a good idea that we work with the sample database and build our scripts