Phil Factor feels that the database gets the short shrift in any outage - it's time to stop saying "the database has gone down" and time to start thinking about the resilience of the entire system.

The Difference Between Rollup and Cube

by Ben Richardson

SQLServerCentral.com

Learn about the fundamental differences between the ROLLUP and CUBE operators.

Change Not For Replication Value for SQL Server Identity Columns

by Additional Articles

MSSQLTips.com

In this tip we look at how to change the SQL Server setting for a tables identity column to not for replication for existing tables.

Designing Highly Scalable Database Architectures

by Additional Articles

SimpleTalk

While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and has the capability to recover from a disaster scenario. In this article, Samir Behara discusses the options available when designing the database architecture to achieve scalability.

A Self-Serve System that Allows Developers to Refresh Databases (Part 1)

by Ben Kubicek

SQLServerCentral

Backup and restore

Empower developers to refresh their own test systems with production backups.

Serverless

by Steve Jones

SQLServerCentral

Cloud Computing

The idea of serverless computing is interesting, and with Azure Stack, might be something more of us embrace.

Introduction to SQL Server Security — Part 5

by Additional Articles

SimpleTalk

SQL Server contains many built-in views and functions that can be used to understand what is going on “under the hood,” and security is no exception. In this article, Robert Sheldon explains the security related catalogue views, dynamic management views, and system functions