A short look at the MSSQL extension for VS Code, getting started with connections and running queries.

Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices

by Additional Articles

SimpleTalk

Views

VIEWs are an undervalued and underused feature in SQL. They basically consist of a query that has been given a name, and a parameter list, so can be used like an inline macro. Technically, you’re supposed to think of it as a virtual table.

Planning for tomorrow, today - database migrations

by johnqmrg

SQLServerCentral

Database Weekly

I have been speaking to people about database migrations to the cloud a lot over the last few weeks. One thing that has jumped out at me is that we seem to focus on the process of moving data being the migration rather than one step in a larger process. Many people neglect the discovery […]

Remembering Phil Factor

by Steve Jones

SQLServerCentral

Misc

One of the most prolific and popular authors at Simple Talk has been Phil Factor. He wrote many pieces on all aspects of database work and has probably written more articles on the Redgate Product Learning site than anyone else. He has entertained, informed, and inspired many database professionals in his many years as an […]

Getting Started with Bayesian Modeling

by Additional Articles

MSSQLTips.com

Python

Multivariate analysis in data science is a type of analysis that tackles multiple input/predictor and output/predicted variables. This tip explores the problem of predicting air pollution measured in particulate matter (PM) concentration based on ambient temperature, humidity, and pressure using a Bayesian Model.

Pushing the Limits of AGs

by Steve Jones

SQLServerCentral

Uncategorized

Many of you reading this likely have an Availability Group (AG) set up on at least one database in your organization. Maybe not most, but many of you as this has proven to be a technology that many people like for HA/DR, upgrades, and probably other uses. As the technology has evolved from it's SQL […]

Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained

by Chandan Shukla

SQLServerCentral

In Level 2 of the Stairway to Hyperscale, we learn about Page Servers in more detail.

How to Measure Replication Latency in SQL Server AlwaysOn Synchronous Availability Groups

by Additional Articles

SimpleTalk

Synchronous replicas in SQL Server Availability Groups promise no data loss, but they don’t promise zero delay; under heavy load they can still fall behind. This article shows how to measure and track that hidden replication delay using SQL Server performance counters, so you can see how well your system keeps up during IO‑intensive operations and plan maintenance more safely.