Stairway to T-SQL DML Level 4: The Mathematics of SQL: Part 1
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.
Free eBook: SQL Server Backup and Restore
In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.
Monitoring your servers and databases with SCOM and SQL Monitor
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
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
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
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
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
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
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.
Blogs
Strategies for Compliant Development Down Under
By Steve Jones
I’m doing a tour of Australia and New Zealand with our SQL in the...
T-SQL Tuesday #114 Puzzle Party – Roundup
Here’s my round-up for this month’s T-SQL Tuesday. Thanks to everyone who contributed last...
Do you have rarely used indexes that are hurting performance of writes?
By SQLPals
We know that indexes are necessary for query performance but comes with overhead during...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
SQL Server Error mtlog.cpp
Hi all We are seeing frequent error messages like this: "[WARNING] === At least...
What are the new distributions of bounty hunter rewards in 2019?
Sometimes the best change is to remove content altogether. In the past few months...
Ask SSC