A relational database contains tables that relate to each other by key values. When querying data from these related tables you may choose to select data from a single table or many tables. If you select data from many tables, you normally join those tables together using specified join criteria. The concepts of selecting data from tables and joining tables together is all about managing and manipulating sets of data. In Level 4 of this Stairway we will explore the concepts of set theory and mathematical operators to join, merge, and return data from multiple SQL Server tables.

Monitoring your servers and databases with SCOM and SQL Monitor

by Additional Articles

Redgate

Monitoring

SCOM is good at monitoring the status of your servers. SQL Monitor give you a detailed view of your SQL Server instances, and databases, right across your network, however they are hosted. By using tools appropriately, for the tasks they do well, you benefit from a simpler and more comprehensive overall strategy.

SQL Server Subquery in Select Statement with Where Clause

by Additional Articles

SimpleTalk

In this part of the temporary data store tip series we look at using subqueries to select data as well as how to use for inserts, updates and deletes.

DBA Walkthrough – Adding space on IBM AIX Power Machines

by SOLVARIA

SQLServerCentral

Learn how to manage storage/filesystems on IBM AIX - Power machines. Learn from this demo of expanding a filesytem on AIX so that your DBA's get a high level overview of how AIX storage management works.

No State Based Deployments

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones talks about deploying your database changes, and how you can't ever really depend on a state based approach.

Bringing certainty to the uncertainty of Brexit

by Additional Articles

Redgate

DevOps and Continuous Delivery (CI/CD)

These are tough times for businesses in the EU. Is the UK going to be in or out? Quite simply, businesses are finding it difficult to plan anything when everything is up in the air, and no one can confirm what will happen next. All of which is making many businesses wary of making a decision to invest in their IT infrastructure. Enter DevOps.

Introduction to the Cosmos DB Emulator

by Additional Articles

Database Journal

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.

Stairway to T-SQL DML Level 4: The Mathematics of SQL: Part 1

Monitoring your servers and databases with SCOM and SQL Monitor

SQL Server Subquery in Select Statement with Where Clause

DBA Walkthrough – Adding space on IBM AIX Power Machines

No State Based Deployments

Bringing certainty to the uncertainty of Brexit

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

Blogs

Claude AI Convinced Me Not to Build an iPad App

A New Word: Dolorblindness

Claude Code Helps Analyze Test Data Manager Log Files

Forums

Data Warehouse Toolkit meets Star Schema: The Complete Reference

GPX distance and time analysis in SQL Server

The DBA is Dead; Long Live the DBA

Question of the Day

Changing the AG Listener