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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda Date: 01/27/2018

Tit Bits (2) on recent speculative execution side-channel vulnerabilities

Microsoft is constantly working to address the new publicly disclosed class of vulnerabilities...

Author: Shreyas R Gowda Date: 01/12/2018

Tit-Bits on the recent speculative execution side-channel vulnerabilities

Microsoft is aware of a new publicly disclosed class of vulnerabilities that are referred to as...

Author: Shreyas R Gowda Date: 01/12/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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda 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...

Author: Shreyas R Gowda Date: 07/20/2017