CONUNDRUMS
get them UNTANGLED here
Failing to install a new instance of SQL server 2014/2016
Yesterday, I was working with a client of mine on an issue with configuring SQL server reporting...
Date: 11/22/2018
Failing to restore a database having 'In-memory OLTP' database
A few days ago, encountered a weird scenario where a 'In-memory OLTP' database had to be restored...
Date: 11/05/2018
SQL Server Management Studio (SSMS) working only when launched as an Administrator
Two weeks ago, I found one of my clients encountering an interesting issue where he found that the...
Date: 10/29/2018
What is QDS_ASYNC_QUEUE wait type ???
A week ago, one of my clients' faced an issue with the SQL server performance going poor post...
Date: 09/08/2018
SQL Server Failover cluster instance upgrade failure issue from 2008 R2 to 2012
Today, one of my clients' production environment was facing an issue with the failed upgrade of a...
Date: 08/15/2018
SQL Server detected a DTC/KTM in-doubt transaction
Few days back, one of my clients' faced an issue with their Availability group getting into the...
Date: 08/11/2018
Restarting the SQL Service may fail occasionally with the error, “TCP port is already in use”
Today, I was working with one of my clients with an issue where the application fails to connect to...
Date: 07/17/2018
Upgrade of SSRS from SQL 2008 R2 to SQL 2012
Yesterday, I encountered a weird scenario where in the SSRS component was failing to upgrade from...
Date: 03/28/2018
Sharing TDE Encrypted Backup outside the organisation.
In order to share the TDE Encrypted Database backup with somebody outside the organisation, the...
Date: 03/27/2018
SSMS 2016/2017 has the Tools -> Options -> Source control missing for the integration of TFS server
Encountered a weird thing when I was working on a TFS server integration issue yesterday where in we...
Date: 03/06/2018
Issue with adding the replica and failing with the error "No quorum set exists across the WSFC cluster."
Last week, I was working on one of my clients' issues where in they were trying to actually trying...
Date: 03/06/2018
SQL failing to come online with SQLClusterResourceWorkerWaitForCompletion() failing
A few days back, I was working on an issue where in my client applied the patch KB3045318 on his SQL...
Date: 01/27/2018
SQL session blocked by a negative SPID (-2)
A couple of times now I have faced this issue with my clients where SQL Server session is blocked by...
Date: 01/06/2018
Unable to login to SQL server
A few days back one of my clients were facing a business down scenario, where in the DBA who was...
Date: 01/06/2018
Script to list the users of the databases
Yesterday, one of my clients came up with this requirement to develop a script where in we can list...
Date: 12/15/2017
SQL services failing to start
Here is a weird scenario which my client faced where the SQL services failed to start. Tried to...
Date: 09/09/2017
Encountered issues getting the SQL server and SQL agent cluster resources online
A couple of days back, when I was troubleshooting an issue related to SQL Fail-over cluster instance...
Date: 09/05/2017
Public certificates vs Private certificates vs Self-signed certificates
Do review this information to give you a better understanding on the different types of certificates...
Date: 08/18/2017
Facing issues with applying SP2/SP3 for SQL 2008 R2 FCI
One of my clients happened to encounter an issue upgrading the SQL server 2008 R2 instance from SP2...
Date: 08/12/2017
Troubleshooting SQL Server Upgrade Issues
Recently, one of my partners, were facing issues upgrading SQL server 2008 from Service Pack 2...
Date: 07/22/2017
Installation of SSDT for BI on SQL 2014
A few days back, I was working with one of our partners who had a requirement of installing SQL...
Date: 07/22/2017
How to PREVENT TRUNCATION of TABLES?
One of my clients’ requirement to prevent the TRUNCATION of tables on the database by their...
Date: 07/20/2017
SSL on SQL - Troubleshooting
It is one of the pre-requisites for the KEY-SPEC value of the SSL self-signed certificate to be set...
Date: 07/20/2017
SSL on SQL - Foundation
A few days back, I was working with one of our partners who had a requirement of creating a SSL...
Date: 07/20/2017