This article demonstrates how to get started with using Auto Loader cloudFiles with Databricks through an end-to-end practical example of ingesting a data stream which has an evolving schema.
The post Advanced Schema Evolution using Databricks Auto Loader appeared first on SQLServerCentral.

Get Gartner’s latest DevOps and Agile recommendations for I&O leaders. Redgate is named as a sample vendor for Continuous Compliance Automation in the 2021 Hype Cycle™ for Agile and DevOps
The post Hype Cycle for Agile & DevOps appeared first on SQLServerCentral.

Introduction According to the official documentation, the READ COMMITTED isolation level “specifies that statements cannot read data that has been modified but not committed by other transactions”. So, one could think that a record returned under this isolation level existed in the committed state at the time of reading. In this article, I am going […]
The post The Record That Never Existed (as a committed row) appeared first on SQLServerCentral.

Learn how to plot a financial time series using SQL Server data and Python to reveal the value of exponential moving averages and make decisions about time series values.
The post Plotting in Python for Financial Time Series Data for Exponential Moving Averages appeared first on SQLServerCentral.

Get Gartner’s latest DevOps and Agile recommendations for I&O leaders. Redgate is named as a sample vendor for Continuous Compliance Automation in the 2021 Hype Cycle™ for Agile and DevOps.
The post Gartner® Hype CycleTM 2021 appeared first on SQLServerCentral.

The SQL Gateway enables you to configure a TDS (SQL Server) remoting service and set up a linked server for SAP HANA data.  After you have started the service, you can use the UI in SQL Server Management Studio or call stored procedures to create the linked server. You can then work with SAP HANA data just […]
The post Connect to SAP HANA Data as a Linked Server appeared first on SQLServerCentral.

This next article in the PowerShell Day by Day Series will cover adding help to your scripts.
The post Powershell Day by Day: Adding Help to Scripts appeared first on SQLServerCentral.

In this article we look at some of the things you should be aware of when building a VM to run SQL Server, such as vCPUs, disks, memory and more.
The post SQL Server VM Best Practices appeared first on SQLServerCentral.