Most of my earnings come from my role as SQL Server Performance Tuning and Optimization consultant. Every single day I work with few customers so that I can maintain the quality of my work with each of them. As you can imagine, I face new challenges and learn new ways to tune SQL Server. In this blog post, we will discuss an error XML document could not be created because server memory is low. Use sp_xml_removedocument to release XML documents.
SQL SERVER – Reporting Services Not Starting After Maintenance Window
This is the issue faced on my test server and I found something interesting. In this blog, we would learn about one of the reasons why SQL Server Reporting Services (SSRS) couldn’t start after regular maintenance.
SQL SERVER – Always On Availability Groups and Full-Text Index
One of the most successful offerings from me has been Comprehensive Database Performance Health Check. Sometimes during my assistance, some random issues appear which I try to solve as well. In a recent engagement, one of their developers asked a question about the coexistence of full-text index and always on availability groups. In this blog, we would learn about one common issue which you might face when full text and availability group is used together.
SQL SERVER – Unable to Create Always On Listener – Attempt to Locate a Writeable Domain Controller (in Domain Unspecified Domain) Failed
This is one of the common causes in Always On for which my clients contact me – “Unable to create listener”. In this blog we would learn about how to fix event Id 1212 – Attempt to locate a writeable domain controller.
SQL SERVER – Always On Secondary Replica Huge Redo Queue – Version Store is Full. New Version(s) Could Not be Added
One of my earlier clients to whom I helped in configuration Always On Availability Group came back to me with strange behavior. In this blog, we would discuss error Version store is full. New version(s) could not be added. In this situation, I also found that the redo queue was increasing continuously on the secondary replica.
SQL SERVER – Azure Key Vault Deletion Error – Vault ‘ProdRecoveryVault’ Cannot be Deleted as There are Existing Resources Within the Vault
Along with my performance consulting, I also help many clients in fixing some quick issue. You can refer to various consulting services which I provide. This blog is an outcome of one such engagement where the has Azure Key vault and was not able to delete it. In this blog, we would learn about how to fix error Vault ‘Name’ cannot be deleted as there are existing resources within the vault.
SQL SERVER – How to Change Authentication Mode Using T-SQL Query
One of my clients asked an interesting question. It took a while for me to figure out the answer so sharing with my blog readers. In this blog, we would learn how to change authentication mode of SQL Server using T-SQL query instead of SQL Server Management Studio.