But now, as per company standards, they need to use a domain account as the service account. Let us learn more about that in this blog.
SQL SERVER – System. Security. Cryptography. CryptographicException – There Was an Error Generating the XML Document
One of my clients contacted me in assistance to install SQL Server. Generally, this is straightforward, but sometimes there are problems. This time we received an error message and it was very interesting. Let us learn about error related to the XML Document.
SQL SERVER – How to Protect Database from DBA and Hide Database Schema
There is a growing demand for database encryption nowadays and large companies offer alternative solutions for Microsoft TDE. But what if you want to protect the database from local Administrator?
SQL SERVER – AlwaysOn AG (Availability Group) and TDE Error – Please Create a Master Key
Along with performance consulting, sometimes I also get requests from a few clients to look at the AlwaysOn availability group related problems.
SQL SERVER – TDE Effects on TempDB’s Slow Performance
I am a big supporter of the fact that testing and playing with new features should not be done on production environments. It can prove to be harmful, even after you tried to clean up the system. Sometimes we are not sure what the impact of our acts can lead to. In a recent consulting engagement, I figured this out the hard way. I was brought in for slow performance suddenly and we were not sure what was happening in the system. I love tough challenges and this was no different.
SQL SERVER – Why Does Encrypted Column Show NULL on Subscriber?
While I was online on Skype last night, one of my old customers pinged me and wanted to know my opinion of a special issue which he was facing when Encrypted Column Show NULL on Subscriber.
SQL SERVER – Error: 26014 – Unable to Load User-Specified Certificate
After seeing various issues with SQL Server startup problem, I felt that I know almost most of the errors, but I was wrong till someone contacted me with a new error. But I learned that Errorlog is always a good place to start with. SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location. Let us learn in this blog post we are going to learn how to fix unable to load user-specified certificate. Here is what I saw in my client’s machine.