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, […]
The post How to use a Powershell script to track the network latency issue in AOAG appeared first on SQLServerCentral.

Learn how Splunk can be used to get information from application logs or a SQL Server database.
The post Business Analytics from Application Logs and SQL Server Database using Splunk appeared first on SQLServerCentral.

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
The post SQL Server vs Oracle: Data Masking appeared first on SQLServerCentral.

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.
The post Building a Database with Flyway appeared first on SQLServerCentral.

In this article we look at how to generate random dates in SQL Server to build a sample dataset along with code and examples
The post Generate Random Dates in T-SQL appeared first on SQLServerCentral.

Here's why you should NEVER use the FORMAT() function in SQL Server.
The post How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!) appeared first on SQLServerCentral.

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.
The post [From the archives] 5 things to look for in a 3rd party database monitoring tool appeared first on SQLServerCentral.

If you save a metadata 'model' for every new version of a database created by Flyway, you can compare the current model to the previous one to see what changed. In turn, you can then generate a database E-R diagram that highlights the changed objects, instantly making those changes visible to other team members
The post Increasing the Visibility of Database Changes in Flyway Development appeared first on SQLServerCentral.