Adding a database to an availability group can fail with the message that the database is encrypted by database master key, even when TDE is off. This post finds the key, checks what depends on it and lists three ways to continue. A demo database shows the checks and the error that protects a key still in use.
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.
Last Query Cost in MySQL: Read It With SHOW STATUS
The last query cost in MySQL is a number the optimizer computes for the last query it compiled, and SHOW STATUS LIKE ‘Last_query_cost’ returns it. This post shows the command on a Sakila query, explains what the number means and where it misleads. It also points to EXPLAIN FORMAT=JSON for the cost of each part of a plan.
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: Count the Licensed Cores
Choosing a processor for SQL Server starts with the license, because SQL Server is licensed per core and the cores you buy decide the bill. This post reads what the server reports, counts the cores that matter, and explains the edition limits and the per-core speed trade. It ends with a way to size cores from measured CPU use.
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.