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.
Change Data Capture (CDC) with Transactional Replication
Continuing to previous post link, where I explained the reason of CDC capture job failure for a database enabled in transactional replication with remote distributor; here I would like to discuss the scenario of enabling change data capture for a database with local distributor. In this article we will discuss about interoperatibility of SQL server … Read more
ola hallengren index optimize not optimizing indexes
We had deployed ola hallengren maintenance solution for one of the customers and scheduled all the jobs. Customer mentioned to us that Index Optimize job ran fine, however he could still see that there were many indexes with fragmentations percentage around 90% and more. He even sent report for this as evidence. Then we went … Read more
SQL Server Encrypted Backup and Restore
SQL Server encrypted backup is a feature of both standard and enterprise edition in SQL Server 2019. You can refer below link for more details: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver15 Taking encrypted backups and restoring those backups on another SQL instance requires some additional steps to be followed. Take Encrypted Backup Above encrypted backups could be restored on same … Read more
Taking SQL Server Backups in yyyymmdd_hhmmss format
When we configure native log shipping, it takes log backups in yyyymmdd_hhmmss format. Recently, we had requirement where customer wanted us to take other native backups in yyyymmdd_hhmmss format. We used below code for taking different backups in required format. Full Backup Differential Backup Log backup
SQL Server Express Edition Limitations
I have mostly seen standard and enterprise editions in customer environments. However there are few customers who keep SQL Server Express edition and later understand its limitations. One customer wanted to upgrade his express edition and wanted to know major limitations of express editions so that he can convince his management for edition upgrade. So … Read more
Handling SQL Server High CPU Issue
High CPU on a SQL Server could have various causes and we need to provide the resolution accordingly. One of our customer reported CPU being 100% for few hours and it was not going down even for few seconds. Majority of CPU workload was due to SQL processes only. This customer had never complained about … Read more
Read SQL Server Error logs effectively
As a DBA, how often we check SQL error logs. I would say Mutiple times in a single day. And how many of us really know who to check and read the error logs effectively.
Row was not found at the Subscriber
We got one replication related alert for one of the critical database. Distribution agent was failing with below error message: The row was not found at the Subscriber when applying the replicated DELETE command for Table ‘[dbo].[TableXXX]’ with Primary Key(s): [PrimaryKeyID] = 12345678 (Source: MSSQLServer, Error number: 20598) Above error could be seen in replication … Read more
Upgrade OS on MS SQL Server Box
Recently we got one request to upgrade OS of a MS SQL database server. Customer asked us to perform in-place upgrade from Windows 2012 datacenter to Windows 2019. We educated customer that in-place upgrade should be avoided considering associated risks. However, customer was fine with risks considering it was a development database server. Anyways, customer … Read more