Microsoft SQL Server

In the Ultra Transcenders books

VBR-13

Each book explains Microsoft SQL Server in context, with comparison tables and the common traps.

Terms in this definition

• Schema

  The middle part of a Unity Catalog name (catalog.schema.table), grouping tables, views, volumes, functions and models inside a catalog. A grant on it covers everything in it now and later, and nothing inside can be reached without USE SCHEMA.

• configuration database

  Veeam stores details of its infrastructure, jobs and sessions in this SQL Server or PostgreSQL database, which can be local or remote and is tidied each week by DatabaseMaintenance.

• PostgreSQL

  Short for Azure Cosmos DB for PostgreSQL, a Citus-based distributed relational service that scales writes out horizontally. New projects are steered away from it towards Azure Database for PostgreSQL elastic clusters.

• Dedicated

  Running Azure Functions on an App Service plan, which removes the execution time limit and offers VNet integration on Basic and higher tiers.

• application-aware processing

  Without this job option, a VM backup is merely crash-consistent. With it, Veeam uses VSS on Windows and handles application logs so that SQL Server, Exchange, Oracle, PostgreSQL, SharePoint or Active Directory data is transactionally consistent in backups and replicas.

• log

  Text written by a component to record something that happened. VCF Operations for logs takes these in, and after integration with VCF Operations they can be searched from its Analyze page and Log Analysis widget.

Related terms

• ALTER ANY EXTERNAL MIRROR

  A permission that the account used for mirroring must hold in an Azure SQL Database, Azure SQL Managed Instance or SQL Server source before Fabric can mirror it. Anyone with CONTROL, or in the db_owner role, already has it.

• Always On availability group

  High-availability feature of SQL Server that keeps synchronous or asynchronous replicas on different servers or VMs without shared storage. As every replica is a live SQL Server, it is an expensive way to provide DR.

• Automated Backup

  Feature of the SQL IaaS Agent extension: SQL Server instances on Azure VMs get backed up into a storage account.

• Azure Cosmos DB Data Migration Tool

  Utility that moves data from sources such as SQL Server into Azure Cosmos DB.

• Azure Hybrid Benefit

  Licensing benefit that cuts Azure costs by reusing Windows Server or SQL Server licences with Software Assurance, or RHEL and SUSE subscriptions. Ubuntu isn't eligible, nor is the DTU purchasing model of Azure SQL.

• Azure SQL

  An umbrella name covering three Azure offerings that share the SQL Server engine: the managed database service, the managed instance, and SQL Server installed on Azure-hosted virtual machines.

• Azure SQL Managed Instance

  Fully managed SQL Server instance offering almost complete compatibility, including SQL Agent, CLR and queries across databases; disaster recovery to another region is achieved with auto-failover groups.

• azure/sql-action

  Used in GitHub workflows to publish a SQL project or .dacpac to SQL Server or an Azure SQL database; it is a wrapper round SqlPackage.