In this article, we will see T-SQL scripts to list foreign key relationships between tables. What is Referential dependency ? Referential dependency is a constraint between two tables in a relational database that ensures data consistency. To establish a referential dependency, you define a foreign key on a table that refers to the primary key … Read more
On AWS portal , we see Volume IDs of EBS volumes. However on EC2 Machine, we see disk names. Sometimes, we need to know which disk name is associated with which volume ID. In this article, we will talk how to find drive letters from EBS volume IDs. Before we start, Please go through article … Read more
Here are step-by-step instructions: Installation of AWS CLI Validation of AWS CLI setup To check the version of the AWS CLI installed on your Windows machine, open a command prompt or PowerShell terminal and run the following command: aws –version This will display the version number of the AWS CLI installed on your machine, along … Read more
What is Accelerated Database Recovery SQL Server 2019 introduced Accelerated Database Recovery (ADR) as a new feature. ADR reduces the time it takes to recover a database from a crash or other failure. It accomplishes this by introducing a new recovery mechanism that greatly reduces the amount of time it takes to roll back transactions … Read more
In this article we will discuss on how to run a script on all databases that are either AG primary or standalone in SQL instance.
Script to find space utilization in each data file and log file. This will be useful while troubleshooting data and log file full issues.
Script to find last successful run of SQL agent jobs.
In this series, we will learn basics of PowerShell. This Blog will focus on some of the basic terminology and how we can work with Variables in PowerShell. Introduction to PowerShell PowerShell was introduced with Windows 2008/R2. Since then, many versions of PowerShell have launched and with every new version, new features have been introduced. … Read more
Recently I was faced with an interesting issue where upon rerunning distributor agent, complete snapshot was being applied even though we had got “snapshot has been delivered successfully” message. The activity was about adding newly created tables into the replication. Below were high level steps followed for the activity. After step 5, once we got … Read more
In SQL server 2022, MS introduced a new feature in the area of security , called Ledger. SQL server ledger makes data temper-evident through cryptography which enables organizations to confirm if their data is 100% trusted or if it has been tempered with. This feature uses are power of blockchain yet avoid the complexity and … Read more