Articles

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.

2017-01-13

3,309 reads

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(36)

You rated this post out of 5. Change rating

2017-01-12

35,727 reads

Discuss

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.

2017-01-12

4,563 reads

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.

2017-01-11

4,829 reads

Simpson's Paradox

by Mala Mahadevan

SQLServerCentral.com

T-SQL

This article is a case study and an attempt to explain an interesting phenomenon with data anomalies that is commonly called Simpson's Paradox.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(34)

You rated this post out of 5. Change rating

2017-01-10

3,717 reads

Discuss

SQL Server 2016 Enterprise Edition Performance Advantages

by Additional Articles

SQL Server Performance

SQL Server 2016

Glenn Berry uses a few specific examples to demonstrate the performance benefits you can get from SQL Server 2016 SP1 Enterprise Edition.

2017-01-10

4,975 reads

Using R to Identify Key Features Quickly

by Nick Burns

SQLServerCentral.com

Visual Analytics

Typical BI dashboards display data summaries like counts and averages. We use R to extend on these to identify key associations in a dataset.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2017-01-09

2,337 reads

Discuss

Using SQLite with PowerShell and SQL Server

by Additional Articles

SimpleTalk

SQLite

When you combine PowerShell and SQLite, you can perform powerful magic. Phil Factor is in awe of SQLite and gives a brief demonstration of how easy it is to use. Just to encourage anyone who is unfamiliar with the database, he includes a giant-sized SQLite version of the old PUBS database that the first generation of RDBMS developers cut their teeth on.

2017-01-09

3,904 reads