SQL Server

Find if backup is encrypted or not.

by

In this blog post we will demonstrate on steps to check if the backup file in sql server is encrypted or not.

SQL Server Error 229: The SELECT permission was denied on the object ‘databases’, database ‘mssqlsystemresource’, schema ‘sys’.

by

SQL Server error 229 occurs when users try to execute a SQL query. It may also occur while trying to connect to the database server. The error message displayed is “The SELECT permission was denied on the object.” The user account executing the query or stored procedure lacks the necessary permissions, causing the error. In this post, we will discuss the causes of this error, and the steps you can take to resolve it.

Read more

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

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

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