Fixed: SQL Server Query Performance Issue

by

Troubleshooting SQL Server query slowness issue. Query optimization through parameterization. Fixing duplicate plan issue.

SQL Server Hardening: Initial Checklist

by

SQL Server is a popular database management system that helps organizations store, manage, and analyze large amounts of data. With the rise of cyber attacks and data breaches, it’s crucial to harden your SQL Server to protect your data from unauthorized access and malicious activities. This SQL Server Hardening post will guide you through the first steps to harden your SQL Server and secure your database.

Read more

TDSSNIClient initialization failed with error 0xd

by

Hi All, Recently I faced an issue while trying to update the certificate used for SQL server connection encryption. When I updated the thumbprint value of certificate in following registry key and restarted SQL services I got below error. Registry Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLServer\SuperSocketNetLib\Certificate Error Message: I checked and verified that SQL server service account … Read more

Guide to handle high CPU caused by deadlocks

by

We were working for a customer who was facing below issues on MS SQL Database server: Initial Approach: Issue Identification: Above things helped very little so we started further investigation of deadlocks and execution plans of high CPU queries. We identified below issues: 5. Winner query acquired key lock on entire non clustered index due … Read more

SSIS Package migration

by

I encountered a scenario where a customer requested to move their existing SSIS packages from a 2008 R2 server to a 2016 SQL Server. This is not a typical request as it involves many considerations before migrating a package to a higher version. In this post, I will list the steps and considerations that I took before tackling this task of SSIS package migration.

Read more

Setting up LAB environment for SQL Server on Linux

by

In this article we will setup the lab environment using Oracle Virtual Box and install Ubuntu operating system followed by installation of SQL Server 2022 on Ubuntu. Step-1: Install Oracle Virtual Box Kindly download Oracle Virtual Box package as per your operating system from https://www.virtualbox.org/wiki/Downloads and install it. Kindly also install Virtual Box guest additions … Read more

SQL Server TDE, Encrypted Backup Interview Questions

by

Recently we worked with one of customer who wanted to implement TDE and Encrypted backups on his production SQL Servers. He had so many questions on encryption and decryption process. Some questions might look silly but we had to test things to be able to provide answers. Refer existing articles for TDE and Encrypted backups: … Read more

SQL Server Replication Error 113 – Missing end comment mark ‘*/’

by

Replication is one of the trickiest things in SQL Server and especially when you don’t know the solution of the issue. One such issue we faced a few days back which we were able to solve using a small trick. Here is what happened.: Snapshot got generated on publisher but failed to apply on subscriber. … Read more