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

Which Database is Causing the Problem?

by Additional Articles

Brent Ozar Blog

You’ve got one SQL Server hosting a bunch of databases, and performance is bad. Which database should you focus on first?

Are you a Data Scientist?

by Steve Jones

SQLServerCentral.com

Editorial

A data scientist needs some specialized skills. Today Steve Jones talks a bit about the requirements to be good at this job.

SQL Server Trigger on View Example

by Additional Articles

MSSQLTips.com

In this tip we look at how to create a SQL Server trigger on a SQL Server view.

Build an OLAP Cube in SSAS using an ADO.NET Data Provider

by Jerod Johnson

SQLServerCentral

SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]