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

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

• Database Weekly
• Editorial

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 […]

Moving away from an RDBMS

• by Steve Jones

• SQLServerCentral

• Azure Cosmos DB
• Data Modeling

Today Steve looks at an article the migrates a relational model to CosmosDB.

The Basics of iTVFs

• by Steve Jones

• SQLServerCentral.com

• iTVF

Learn the basics of inline table valued functions in this short article.

Handling System-named Constraints in SQL Compare

• by Additional Articles

• Redgate

• SQL Compare

If some of your database constraints have system-generated names, they can cause 'false positives' when comparing schemas and generating build scripts using SQL Compare or SQL Change Automation. Phil Factor explains the difficulties, and the Compare option you need to enable to avoid them.

Storage 101: Cloud Storage

• by Additional Articles

• SimpleTalk

• Storage

Throughout this series, Roberts Sheldon has discussed a range of storage-related topics, some of which he mentions only briefly. One of those is cloud storage, which now plays a vital role in today’s data management strategies. Organizations of all types and sizes now employ cloud storage to varying degrees, either to supplement their on-premises systems or to handle the bulk of their data. Because cloud storage has become so pervasive, this article focuses exclusively on that topic, describing what it is, how it works, and its benefits and challenges.

Implementing Restart Ability For Shell Scripts

• by Imran Quadri Syed

• SQLServerCentral

• scripting

The purpose of this document is to help design Unix shell scripts (or any programming scripts) with restart capability from point of failure and also to avoid a common mistake done by developers/admins while filtering records.