While preparing for a demo for an upcoming session, I came across an error which I didn’t see earlier. Here is the error in the UI and it is related to Backup Log Operation.
SQL SERVER – FIX: Msg 35250 – The Connection to the Primary Replica is Not Active. The Command Cannot be Processed
Earlier I wrote a blog on same error message which you can read from below link. SQL SERVER – FIX: Msg 35250, Level 16, State 7 – The Connection to the Primary Replica is Not Active. The Command Cannot be Processed
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.
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.
SQL SERVER – Missing Columns and Other Folders in SQL Server Management Studio (SSMS) in Object Explorer
On Random basis, I do get some emails and comments on my blog which makes me do some research and write more blogs to share my thoughts and findings. This blog is an outcome of one such email communication with a user. Let us learn about missing columns in SSMS.
SQL SERVER – Setup Rule: Microsoft .NET Application Security. The computer cannot access the Internet
There are many rules in SQL Server setup which are checked to make sure that the user is not seeing failure at the end of the installation. Most of the rules are generally passed, but few of them are known to generate warnings. One of such rule is Microsoft .NET Application Security which can be seen below.