BMW is looking at renting features using software.

Using SQL Data Compare to Sync Reference Data

by Additional Articles

Redgate

SQL Data Compare

Let's say your QA team maintain two similar test databases. They run tests to verify that different versions of the same application still produce the same, correct results. Therefore, any differences in the test data, between the two databases, needs to be corrected before the tests start. This is the sort of task for which SQL Data Compare is ideally suited, and Bob Sheldon explains how it all works.

Using SQL Server Query Store & Plan Guides to Fix Problem Queries

by Additional Articles

MSSQLTips.com

SQL Server

This webinar will cover how to use SQL Server plan guides and the query store to fix problematic queries and ways to improve query performance.

Beating the Cloud Vendors

by Steve Jones

SQLServerCentral

Cloud Computing

Can you run a system better than cloud vendors? You should know and be able to prove it.

Loading data in Azure Synapse using Copy

by Sucharita Das

SQLServerCentral

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

Learn how to create a Synapse resource and upload data using the COPY command.

Connecting to a SQL Server Docker Container Running in macOS

by Additional Articles

SimpleTalk

Containers

Since SQL Server is supported in containers, you can now run a SQL Server instance in your macOS without dual-booting or running a virtual machine. In this article of the series, Carlos Robles demonstrates how to connect to the SQL Server once it’s running.

SQL Prompt Snippets to Drop Columns and Tables and Handle Associated Dependencies

by Additional Articles

Redgate

SQL PROMPT

Louis Davidson provides a pair of SQL Prompt snippets that will help you deal with dependencies, whenever you need to drop columns or tables.

Controlling Intelligent Query Processing Features

by Kathi Kellenberger

SQLServerCentral

I always look forward to new T-SQL features and optimizer enhancements with every new version of SQL Server. Starting in 2017, Microsoft came up with a set of features called Intelligent Query Processing (IQP). These features work to improve performance without changing any code. If you’d like to learn more about these features, take a […]