In this blog post we will discuss 10 things to remember while taking effective backup for SQL Server.
SQL SERVER – Login Failed – Error: 18456, Severity: 14, State: 38 – Reason: Failed to Open the Explicitly Specified Database
Those who are my regular clients would know that I am very active in replying to emails. My average time of response is around 24 minutes. Many of the emails are for suggestions and I don’t get much time to help everyone, but I do reply to them letting them know the alternatives. If you are following my blog, you would know that I do provide “On Demand” services to help critical issues. This blog is an outcome of one of such short engagement about login failed.
SQL SERVER – The Cluster Resource ‘SQL Server’ Could Not be Brought Online Due to an Error Bringing the Dependency Resource
In my lab setup, I already have a 2 node windows 2012 R2 cluster. I already had one SQL server 2012 instance is working fine without issues. However, when I was trying to install a new additional SQL 2012 instance, the installation reached till the last phase and getting failed with errors related to a cluster resource.
How to Create Temp Table From Stored Procedure? – Interview Question of the Week #140
Question: How to Create Temp Table From Stored Procedure?
SQL SERVER – How to Move SQL Server Cluster to Different Domain?
One of my blog readers sent an email where he wanted my quick opinion about SQL Server cluster.
SQL SERVER – AlwaysOn Availability Group Listener – This TCP Port is Already in Use
While doing a preparation of a demo, I encountered below error while creating the listener of the AlwaysOn availability group. I was trying this from Management Studio.
SQL SERVER – How to Reach Out to Cloud – Cloud Computing with PartitionDB
Cloud Computing is not new anymore; everyone is talking about the cloud. Has everyone already touched the sky?