Question: How Many Temporary Tables are Created So Far in SQL Server?
SQL SERVER – TCP Provider – An Operation On a Socket Could Not be Performed Because the System Lacked Sufficient Buffer Space or Because a Queue was Full
Sometimes, I am contacted by blog readers via email and trust me, I get to learn something new. One of my blog reader contacted me for below error about buffer space.
SQL Authority News – Updates on Recent Trip to SQL PASS 2017, Seattle
Today is Thanksgiving in the USA and few other countries. Earlier last week I returned from the USA attending various customer meetings and conferences. Here is a quick update about my trip to SQL PASS 2017, Seattle.
SQL SERVER – AlwaysOn Wizard Error – Checking for Compatibility of the Database File Locations on the Server Instance that Hosts Secondary Replica
This blog is about another message which I faced with I faced in the wizard. You can read earlier two blogs with more problems which my client faced. This error is about AlwaysOn Wizard Error.
SQL SERVER – AlwaysOn Wizard Error – The Endpoints Tab Lists at Least One Endpoint that Uses Only Windows Authentication
While configuring AlwaysOn availability group for one of my clients, there were various errors. I planned to write blog on all errors which I encountered. Here is an earlier blog. After we bypassed all errors in “Select Databases” screen, we came to “Specify Replicas” screen. We added both server names and as soon as we hit next, we got below message. Let us learn about how to fix AlwaysOn Wizard Error.
SQL SERVER – Error – Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group
As a part of my consulting job, I do work with clients who wanted to deploy AlwaysOn availability group. Sometimes there are some simple errors which are encountered, but new DBAs are not aware of such things. In this blog we would talk about one of such error.
SQL SERVER – Add Node Error – Rule “SQL Server Database Services Feature State” Failed
While deploying SQL Server 2016 cluster in my lab I ran into this problem when I was trying to add a second node to the SQL cluster. Let us learn about Add Node Error and how to solve it in this blog post.
How to Assign Multiple Variables in a Single T-SQL Query? – Interview Question of the Week #148
Question: How to Assign Multiple Variables in a Single T-SQL Query?
SQL SERVER – Startup Error – Your SQL Server Installation is Either Corrupt or Has Been Tampered With
While playing with my virtual machines, I screwed up something and my SQL service for my named instance was failing to start. Let us learn about a startup error.
When I tried to start via services.msc, here was the error
SQL SERVER – Message: “Please wait for the System Event Notification Service” When Trying to Logoff from RDP Session
I must tell you that there could be many reasons for this behavior, but in this blog, I would talk about a cause which was due to SQL Server. Let us learn about how to fix error related to the Notification Service.