If you’re using database mirroring in Microsoft SQL Server. Encountering Error 1418, which signifies that the Principal and mirror server are unable to communicate is quite common.
Saurabh
SQL Server Error 229: The SELECT permission was denied on the object ‘databases’, database ‘mssqlsystemresource’, schema ‘sys’.
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.
SQL Server Hardening: Initial Checklist
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.
SSIS Package migration
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.
Transparent Data Encryption In SQL Server
Introduction
SQL Server Transparent Data Encryption (TDE) is a security feature. TDE is known as encryption at rest. Database files and backups are protected from unauthorized access using AES or 3DES algorithm.
LOG_REUSE_WAIT_DESC shown as Availability_Replica even though DB is removed from AG
Issue: One of our customers have a AG server with 2 nodes and 4 databases added to availability group. He got an alert saying that log file is full for one of the bigger database.
SQL Server on Azure VM. Cannot Perform a Differential Backup for Database “xyz”, Because a Current Database Backup Does not Exist.
When you are a DBA, sometimes a problem which might seem so trivial from the error description may not really be so when you dig deeper. Recently we got alerted from our monitoring system that ‘XYZ’ database was missing a differential backup with error statement as “Cannot perform a differential backup for database “XYZ”, because … Read more