As SQL developers, we tend to think of performance tuning in terms of crafting the best table indices, avoiding scalar and table valued functions, and analyzing query plans (among other things). But sometimes going back to the spec and applying some properties of elementary math can be the best way to begin to improve performance of SQL queries which implement mathematical formulas. This article is a case study of how I used this technique to optimize my SQL implementation of the Inverse Simpson Index.

DevOps as a bludgeon

by Additional Articles

Redgate

Vendors/3rd-party Products

With both personal experience and the real world evidence to back it up, Grant Fritchey says, unequivocally, a well-implemented DevOps process helps the organization. But it's not always easy to bridge a siloed organization, and sometimes organizations adopt DevOps for the wrong reasons.

Getting Started with MLflow in Azure Databricks

by Additional Articles

MSSQLTips.com

Azure

In this article we cover how to get started with MLflow using Azure Databricks which manages the end-to-end machine learning lifecycle.

Cloud Database Growth

by Steve Jones

SQLServerCentral

Cloud Computing

The use of cloud databases is growing, and Azure SQL Database is one of the more popular ones.

Finding Dependencies in SQL Server Databases using SQL Dependency Tracker

by Additional Articles

Redgate

Vendors/3rd-party Products

Before you alter a database object, you need to understand what other objects will be affected. This article shows how to generate a simple dependency diagram that reveals both those objects that reference the target object, and those referenced by it, and includes foreign key references, column references and all the other details you need.

Insurance price prediction using Machine Learning (ML.NET)

by Additional Articles

SimpleTalk

Data Science

In this article, Chandra Kudumula shows how to use ML.NET to train a model for predicting costs from an insurance dataset.

Holding Code in Your Head

by Steve Jones

SQLServerCentral

software development

Steve has a few thoughts on software development and coding today when working in teams and trying to keep the entire solution in your head.

Understanding CRUD Operations Against Heaps and Forwarding Pointers

by Mohsin Khan

SQLServerCentral

SQL Server internal storage

In this article, we examine how data changes are made against heaps.

How to Generate Fake Test Data for SQL Server

by Additional Articles

Redgate

Vendors/3rd-party Products

How to use a SQL random data generator to fill SQL Server tables with realistic test data, to shift left database unit testing, integration testing and performance testing so that it is performed during the early stages of database development.

SQL Server Memory Usage Query

by Additional Articles

MSSQLTips.com

Check out this SQL Server function that can return memory usage information for a SQL Server instance such as the amount of memory SQL Server is using and available memory on the machine.

Optimize Your SQL by Reformulating the Spec

DevOps as a bludgeon

Getting Started with MLflow in Azure Databricks

Cloud Database Growth

Finding Dependencies in SQL Server Databases using SQL Dependency Tracker

Insurance price prediction using Machine Learning (ML.NET)

Holding Code in Your Head

Understanding CRUD Operations Against Heaps and Forwarding Pointers

How to Generate Fake Test Data for SQL Server

SQL Server Memory Usage Query

Blogs

How to Connect to SQL Server When Nothing Else Works – DAC

Get a Range of Sequence Values: #SQLNewBlogger

The Agent Era: When “How do I…?” Replaces “Where do I click?”

Forums

Are luxury packages in Andaman suitable for a honeymoon?

Hiring: Financial SQL Systems Administrator

Job Opening for ERP Systems Administrator - Hybrid

Question of the Day

Creating a JSON Document II