Managing SQL Server Docker containers in macOS
In the second article of this series, Carlos Robles explains how to manage Docker images and containers.
Installing Machine Learning Services – Level 1 of the Stairway to ML Services
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
Today, Kendra explains what's holding organizations back from implementing Database DevOps.
Azure Data Factory Multiple File Load Example - Part 2
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.
Queue table issues with Availability Groups in SQL Server
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
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.
Giving Computers Ethics
There is a need to ensure we decide what ethics a computer system ought to have.
Introduction to Attribute Relationships in SSAS
In this article, you will learn how you can set the attribute relationships between dimensions in SSAS.
Storage 101: The Language of Storage
Robert Sheldon continues his series on storage. This article covers some of the basics of performance metrics, HDDs, and SSDs.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers