In this article, we will learn how to use a Powershell script to track the network latency issue in the AwlaysOn availability group (AOAG), the network latency may become a real issue for the AOAG, if the network latency is too high for AOAG, the primary replica will lose the connection to the secondary replica, […]
Learn how Splunk can be used to get information from application logs or a SQL Server database.
One of the sales managers at Redgate Software posted an origin story about how he came to work at Redgate Software. It's an interesting story, and while I don't work in sales or have the same origin story, I don't know that I could have seen the place I'm in now early in my career. […]
Flyway, especially Flyway Teams edition, can be used in several different ways to accommodate a database development that was originally based on builds rather than migrations. This article explores four different ways to use Flyway to build a particular version of a database, from the ground up, using a single migration script. It should help teams select the best way to incorporate Flyway into an existing database build system, during development, while benefitting from use of Flyway's versioned migration system for deployments and releases.
In this article, we look at how to mask/hide data for users using Dynamic Data Masking in SQL Server and Data Redaction in Oracle
In this article, we will learn how to set up Azure SQL VM AOAG based on Windows Server 2019 Failover Cluster step-by-step, it is a detailed supplement to the Microsoft official articles and it is a beginner's guide for people who have no experience to do that, please read this article closely with Mircosoft's guide: […]
Grant takes a few lessons for database DR from a nuclear accident in the US.
Here's why you should NEVER use the FORMAT() function in SQL Server.
Microsoft reads your feedback, but doesn't always build it. However, your votes can sway them at times. Today Steve asks what you'd like to see added to SQL Server.
Are you evaluating the effectiveness of your homegrown database monitoring tool or looking at investing in a 3rd party one? This helpful blog post suggests 5 things to look for in your evaluations.
Kevin Kline (b | t) is hosting T-SQL Tuesday this month and it is to “Tell...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our...
Hello experts, It seems like MS Vulnerability Assessment Tool is available only on a...
Hello Experts I need to migrate a few DBS from one environment to another....
I have a query that is supposed to return one patient id but even...
Ask SSC