SQL

External Article

Introduction to SQL for Cosmos DB

  • Article

This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer. More specifically it will show you how to leverage your Structured Query Language skills to exploit the core possibilities of Cosmos DB as a NoSQL document database.

2019-03-25

219 reads

External Article

Resumable Online Index Create and Rebuild Operations

  • Article

Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.

2019-03-21

1,738 reads

External Article

Introduction to SQL Server Security — Part 3

  • Article

SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the database. This makes the database easier to move to another instance or participate in an Always On Availability Group. In this article, Robert Sheldon explains how to work with users in contained databases.

2019-03-11

Blogs

Daily Coping 24 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Notes on SQLSaturday Jacksonville 2022

By

I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately...

TSQL Tuesday #150: Your first technical job. Rollup.

By

This months subject for T-SQL Tuesday was Your first technical job. I have to...

Read the latest Blogs

Forums

Is this If Condition Expression Valid?

By Stamey

I hate to be a pain, but I am a beginner at this and...

SSRS 2012 Email Relay question

By wentigels

Hi All,   I am trying to figure out if it is possible to...

Interviewing for a SQL Server DBA role, any tips?

By subevenis

Hi all, as the title says, I'm interviewing for a job as a SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers