My client contacted me for a quick assistance in a setup trouble. She informed me that it’s a brand-new install and its failing at the end. She was installing SQL Server 2016 on Windows Server 2016. Let us learn about how to fix Installation Error.
SQL SERVER – Maintenance Plan Error: Failed to Acquire Connection “Local Server Connection”.
One of my clients had an interesting situation where none of the SQL Maintenance plans were working. The example what I am using here is a SQL Server backup maintenance plan failing. I also saw a behavior where all the individual jobs were working fine as expected.
SQL SERVER – Unable to Bring SQL Cluster Online – Reason: The Account is Disabled
This was one of an interesting issue reported by my client. They informed that after some hardening by the security team, they are not able to bring SQL resource online in the cluster. In this blog, we would learn about how to fix the issue where SQL cluster is not coming online.
How to Generate Fibonacci Series for the First 1000 Values? – Interview Question of the Week #174
Question: How to Generate Fibonacci Series for the First 1000 Values?
SQL SERVER – SQL Server Cluster Resource Doesn’t Come Online Randomly
This was another interesting situation where client reported that their SQL Server Cluster resource, sometimes, fail to come online when they perform failover of SQL Server from one node to another. In this blog, we would learn how to fix ” SQL Server resource not coming to an online state ” issue.
SQL SERVER – Impact of Transaction on the Free Log Space
Earlier I wrote a blog post about SQL SERVER – How to Find Free Log Space in SQL Server? After reading this blog post, I received the following question from one of the users about the impact of the transaction on the free log space.
SQL SERVER – Reading Transaction Log to Identified Who Dropped a Table
The other day I received a distress email from a user who wanted to find out who has dropped a table or column from their database. During the On Demand (55 minutes) consultation, not only I was able to help them with restoring their lost data but also was able to find out which user had actually dropped their table “accidentally”. We were lucky enough that the user had a database in full recovery model, hence their transaction log recorded every detail needed.