PASS Summit is the must-attend conference for Microsoft data professionals; delivering 3 full days of technical training on data architecture, management, and analytics. Get the skills you need with in-depth sessions created and led by industry experts. Network and problem-solve with peers and Microsoft engineers, and get ahead of the curve with spotlight sessions on today’s hot topics. Join Redgate and the PASS community in Houston on November 10 - 13 to future-proof your data career.

Installing Machine Learning Services – Level 1 of the Stairway to ML Services

by gingergrant

SQLServerCentral.com

This first installment of the Stairway to Machine Learning Services explains the installation process for this subsystem in SQL Server.

The Main Obstacles to Implementing Database DevOps

by Kendra Little

SQLServerCentral

DevOps and Continuous Delivery (CI/CD)

Today, Kendra explains what's holding organizations back from implementing Database DevOps.

Azure Data Factory Multiple File Load Example - Part 2

by Additional Articles

MSSQLTips.com

In this two-part tip, we are created a metadata-driven pipeline which will copy multiple flat files from Azure blob storage to an Azure SQL Database. The flat files can have different delimiters and are stored in different folders and there are multiple destination tables as well.

Shell Scripting Standards

by Imran Quadri Syed

SQLServerCentral

Imran Quadri Syed covers best practices for writing shell scripts.

Queue table issues with Availability Groups in SQL Server

by Additional Articles

MSSQLTips.com

I recently came across an issue in a SQL Server Availability Group scenario where queries against a heavily-used queue table were taking longer and longer over time.

The Dangers of using Float or Real Datatypes

by Additional Articles

Redgate

SQL PROMPT

Floating point datatypes accommodate very big numbers but sacrifice precision. They are handy for some types of scientific calculations, but are dangerous when used more widely, because they can introduce big rounding errors.