Introduction Relational databases are designed to track changes introduced to a database by data modification language (DML) commands. The fundamental reason for this construct is to ensure that changes are durable and that they can be rolled back reliably. The typical DML command used in SQL are INSERT, UPDATE and DELETE. When INSERT introduces new […]
2022-06-13 (first published: 2022-06-10)
6,002 reads
dbForge SQL Studio gives you a few advantages over SSMS. See what Kenneth discovered during his first use of the tool.
2022-04-27
4,519 reads
Learn about high availability in the cloud at a conceptual level.
2022-03-28
1,437 reads
Learn about high availability in the cloud at a conceptual level.
2022-03-28
1,589 reads
Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon's Relational Database Service.
2020-09-18 (first published: 2018-04-12)
18,515 reads
In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would take.
2020-08-28 (first published: 2018-12-11)
2,480 reads
Learn about the impact of locking and blocking in sessions through some demonstrations of different types of actions.
2020-06-11
6,609 reads
There are a number of ways to generate key values in SQL Server tables including the IDENTITY column property, the NEWID() function and more recently, SEQUENCES. The IDENTITY column property is the earliest of these methods. It was introduced very early in the history of SQL Server and it is arguably the simplest approach. Though old, IDENTITY is still maintained in modern versions of SQL Server and is still relevant for simple use cases.
2020-05-21
6,975 reads
An account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed.
2019-09-27 (first published: 2017-10-10)
5,516 reads
In this article we share a recent experience we had with implementing TLS 1.2 ONLY support on our databases and particularly with respect to its effect on Transaction Log Shipping sessions.
2019-01-03
2,126 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Dears, We are using Azure Data factory pipes to run some stored procedures against...
Hi, I have SQL Server 2019 installed and when go the Clear Trace database...
Hello I need to get txt files from directory and send email, when I...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers