Introduction Sometimes we face the scenario in an enterprise environment that the database in SQL Server Always On Availability Group (AOAG) has high concurrency read and write access from application servers. If we keep using the one network interface card for both network traffic of database connections from application servers and database mirroring between AOAG […]
The post Add a Second NIC for an Availability Group to Separate Network Traffic appeared first on SQLServerCentral.

Redgate’s new DevOps test data management tool, Redgate Clone, provisions production-like data in seconds for SQL Server, PostgreSQL, MySQL and Oracle databases.
The post Redgate opens the doors to cross-database DevOps Test Data Management appeared first on SQLServerCentral.

The tip, Views in SQL Server, explored the purpose of views, creating views examples, and benefits of views. A view is a virtual table that references the actual database tables stored in the database. What if someone changes the underlying table structure, such as renaming the column, adding a new column, or dropping the table? What is the impact of changing schema on views? How can we stop any schema changes if the view references the schema?
The post Benefits and Limitations of SCHEMABINDING Views in SQL Server appeared first on SQLServerCentral.

This article outlines the syntax of the three and four dot references that usually denote external database references, demonstrates how to find them either from a live database or by using a text search of a script, and explains some of the complicating factors that can lead to 'false positives'.
The post Finding External References in Database Deployments appeared first on SQLServerCentral.

This SQL cheat sheet contains a series of scripts to help address common situations that might be brought to a Microsoft SQL Server DBA. Each has a proper explanation as to what it does and how it works.
The post Cheat Sheet for SQL Server DBA Daily Operations appeared first on SQLServerCentral.

This article will cover exporting data from a PostgreSQL table to a CSV file, both from the command line and pgAdmin. We will also look at importing data from a CSV file.
The post PostgreSQL Table Import/Export from and to CSV File appeared first on SQLServerCentral.

SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set of tasks and commands at specified intervals, ensuring the database is up-to-date and performing optimally. As a database administrator, it is essential to regularly monitor the status of SQL Server jobs. One way to do this is […]
The post Create an HTML Report on the Status of SQL Server Agent Jobs appeared first on SQLServerCentral.

Understanding how roles and privileges work in Postgres is key to understanding the next, and often more confusing part of security, object ownership.
The post PostgreSQL Basics: Object Ownership and Default Privileges appeared first on SQLServerCentral.