A “multi-subnet” environment is defined when the OS cluster used as the backbone for AlwaysOn has server nodes that are located in multiple/different subnets. Deploying SQL Server AlwaysOn Availability Groups requires a Windows Server Failover Clustering (WSFC) cluster and each availability replica of a given availability group must reside on a different node of the same WSFC cluster. This post from Manvendra Singh will help you in configuring an HA and DR solution for SQL Server AlwaysOn in multi-subnet networks.

Backing Up SQL Server Databases is Easier in PowerShell than T-SQL

by Aaron Nelson

SQLServerCentral.com

PowerShell

Learn how easy the new SQLServer module makes backups of SQL Server databases.

Backup Data Security

by Steve Jones

SQLServerCentral.com

Editorial

We need better security for our data, especially for our choices in managing data.

Identifying Last Night’s SQL Agent Job Failures

by Additional Articles

Database Journal

SQL Agent

Finding the nightly job failures is just one of a DBA's morning rituals. It is fairly easy to scan all the email with a number of creative search criteria, but what if you would like a more automated approach? Read on to learn how to find and report all job failures using a script.

Not Excited by Linux

by Steve Jones

SQLServerCentral.com

Editorial

Much of the community isn't excited by SQL Server on Linux.

Stairway to U-SQL Level 12: SQL.ARRAY and CROSS APPLY EXPLODE

by Mike McQuillan

SQLServerCentral.com

U-SQL introduces two new data types - SQL.ARRAY and SQL.MAP. Here, we look at what we can do with SQL.ARRAY and the CROSS APPLY EXPLODE expression.

SQL Server Database Provisioning

by Additional Articles

SimpleTalk

provisioning

Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and high quality, the more complex become the requirements for the work of development and testing. More databases are required for testing and development, and they need to be more rapidly kept current. Data and loading needs to match more closely what is in production. Grant Fritchey explains.