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