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
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers