If you have come on this page by internet search, then you must have seen below error in the ERRORLOG which is about deadlock scheduler.
SQL SERVER Installation – FeatureUpgradeMatrixCheck (SQL Server 2016 Feature Upgrade) setup rule failed
One of the best ways to learn problems faced by individuals and organizations is to look at the forums for these issues. Often I have visited MSDN forums and see if there are some hot or interesting issues. Sometimes it is interesting to see some setup failures and investigate for the root cause. They might look trivial, but the best part is going the path of troubleshooting can be refreshing and gives you immense satisfaction to how things work inside SQL Server or Windows. This blog is inspired by one such error that encountered and I found it interesting enough to share it on this blog for the benefit of a larger audience. Let us learn about SQL Server Installation Error.
SQL SERVER – Install Error – Could not Find the Database Engine Startup Handle
Note: There are multiple reason of above error and this blog shows just one of them. I am sure that this blog would give you guideline about what do to in case you see this error about install error.
SQL SERVER 2016 – WARNING: Setup Limited to Reporting Services for SharePoint
I have a habit of generally reading the “What’s New” section whenever a new version is around in the block. This is a great way to actually check, learn everything that is getting released in a nutshell. These often don’t just mean we can master them in that single page, but it gives us enough information to start our journey for exploration. Let us learn about Setup Limited to Reporting Services for SharePoint warning.
SQL SERVER – Detected a DTC/KTM in-doubt Transaction with UOW
Recently, one of my clients contacted me to assist in fixing and issue which was causing their production database to be in SUSPECT state. The learnings I am getting from various consulting engagements is awesome and the after effect of this is a number of blogs I have published in the recent past. They were using Microsoft SQL Server 2008 R2 (SP2) in a clustered environment. They had a disaster and had a hard failure of SQL cluster. Initially there were issues with DTC and they were able to fix them by installing the DTC component in the cluster. Now, once they reinstalled DTC, the production database was in SUSPECT state. Let us learn about how to detect DTC/KTM in-doubt Transaction with UOW.
SQL SERVER – Fix Error Msg 13602 working with JSON documents
My saga of working with JSON documents and finding out the various errors continues. With JSON being one of the new data structures introduced inside SQL Server 2016, I have been exploring to how these are fundamentally different from using the FORXML constructs. The more I have been working and testing with this capability, the more similarities I am seeing in them. Coming from a generation of working with SQL Server for more than a decade, I try to explore and learn the new concepts keeping some reference. This helps in faster learning and can accelerate the way you work with the new concepts.
SQL Server Agent – Unable to start the service – The request failed or the service did not respond in a timely fashion
Rarely, it also happens when someone becomes accidental DBA and may get stumped with simple things. This blog is result of troubleshooting which I have done for a company where I found one such DBA. I don’t say you cannot become a DBA in this manner, it is the hard work that goes behind this that needs to be understood. Let us learn about error related to SQL Server Agent.