The age of artificial intelligence seems to be here, but it's a little different to what we were promised.

Data Transfer Strategies between MongoDB and SQL Server

by Phil Factor

SQLServerCentral

There are a variety of days to move data between MongoDB and SQL Server. This article covers some of your options and gives you ideas on which method might work best for you.

How to find Updated Column in SQL Server Trigger

by Additional Articles

MSSQLTips.com

SQL Triggers

In this tip we look at how to which columns have been updated when using a SQL Server trigger by using the update and columns_updated functions

Changing Hardware

by Steve Jones

SQLServerCentral

Hardware

AMD has new chips coming out and Glenn Berry changes his recommendation against using AMD in SQL Servers.

Are Windows Containers a Good Choice?

by Steve Jones

SQLServerCentral

Virtualization, containers, and k8s

Steve doesn't think Windows containers are the future for the data platform.

SQL-On-Hadoop: Hive - Part I

by Frank A. Banin

SQLServerCentral.com

Hadoop

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.

Running Linux SQL Server as a Container

by Additional Articles

Redgate

SQL Server on Linux

Phil Factor starts a series of articles that will demonstrate the use of temporary SQL Server instances, running in Linux containers, into which we can deploy the latest database build, stocked with data, for development and testing work. This initial article shows how to set up a SQL Server instance inside a Linux Docker container, create some sample databases, and persist data locally.

SQL Server Clustered Tables vs Heap Tables

by Additional Articles

MSSQLTips.com

tables

One very important design aspect when creating a new table is the decision to create or not create a clustered index. We will take a look at a few points to help with the decision.