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.
This week Steve wonders if you're want to tackle an exciting project for a day or a week.
Starting out a new database development with source control is relatively easy. To introduce source control into an existing database application can be more challenging. Phil Factor explains some of the fundamental steps.
There are a whole slew of problems that we had to worry about ten years ago, and they just hardly ever come up today.
Steve doesn't think microservices work with relational databases, but maybe you can convince him otherwise.
If you haven’t used a date table before, here are a couple of primers on how to create one and use it.
DevOps can help provide better security for your databases.
In this article we look at some simple ways to test a SQL Server developers T-SQL skills with some query questions and answers.
In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server. Install SQL Server on Ubuntu 16.04 Install Pacemaker agents and configure the cluster Create Always On Availability Groups Create […]
The ability to analyze lots of data on a workstation can be a way to test things without overloading server systems until you are sure your code works.
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
I’ve been doing storage load tests for SQL Server for a long time, both...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item Half of All Engineers
I have an app that has an address field on the customer and the...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers