Cosmos DB delivers a wide range of advantages over traditional SQL and NoSQL-based data stores, including support for multiple consistency levels, latency and throughput guarantees, policy-based geo-fencing, automatic scaling, and multi-master replication model. However, it is a significant departure from the traditional database management and development approach that most database administrators are familiar with. Discover the offerings that you can use at no cost to gain hands-on experience with Cosmos DB.

Creating Aliases for Docker Commands in Linux

by Carlos Robles

SQLServerCentral

In this article you will learn how to create and use alias commands for Docker, to make Docker's command line experience easier and more productive.

What Limits Do You Want in 2019?

by Steve Jones

SQLServerCentral

SQL Server 2019

With SQL Server 2019 getting closer to release, Steve asks about the hardware limitations that we should have in Standard Edition.

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.

SQL in the City Summits – US & Down Under

by Press Release

Redgate

event

Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today.

Testing Databases: What’s Required?

by Additional Articles

Redgate

Testing

Phil Factor reviews the various types of database test that need to run during development work, what sort of test data they require, and the challenges with managing this data, and in keeping the test cell stocked with the correct database, and data, in a way that allows rapid cycles of database testing.

DBAs and the ITIL Framework, Part II: Asset Management

by John F. Tamburo

SQLServerCentral.com

See how the ITIL Framework's Asset Management standards make the DBA's job easier. Use the CMDB and DML to keep your data assets under tight control.

The Other Jobs

by Steve Jones

SQLServerCentral

Career Growth

This week Steve is asking what jobs you might choose if you had the chance, as well as those you enjoyed, or perhaps dreaded.

Azure SQL Elastic Pools and SQL Monitor

by Additional Articles

Redgate

Azure SQL

Jon Hayman explains the Azure-tailored metrics and alerts in SQL Monitor that track use of the limited compute resources available to an Azure SQL Elastic Pool, and to each of the databases in it.

The Silent Bug I Find in Most Triggers

by Additional Articles

Brent Ozar Blog

I don’t have a problem with triggers. They get the job done when you need to implement business logic in a hurry, and you’re not allowed to change the application. As long as you keep the number of statements to a minimum (say, 2-3), and don’t try to do something really slow like fire up a cursor, triggers can be an efficient way to solve hard problems quickly. However, most triggers I run across have a really, really dangerous bug.

Introduction to the Cosmos DB Emulator

Creating Aliases for Docker Commands in Linux

What Limits Do You Want in 2019?

Introduction to SQL Server Security — Part 5

SQL in the City Summits – US & Down Under

Testing Databases: What’s Required?

DBAs and the ITIL Framework, Part II: Asset Management

The Other Jobs

Azure SQL Elastic Pools and SQL Monitor

The Silent Bug I Find in Most Triggers

Blogs

5 Starter Projects for Your AI and Data Engineering Portfolio

The Book of Redgate: Taking Breaks

Database AI Agents: The Read-Only Rule

Forums

Liability for AI Errors

Running a Parameter-Sensitive Stored Procedure on a Secondary Replica

Pro SQL Server Internals

Question of the Day

Running SQLCMD II