How Well Does the MSSQL Extension in VSCode Work?
A short look at the MSSQL extension for VS Code, getting started with connections and running queries.
2025-09-22
7,845 reads
A short look at the MSSQL extension for VS Code, getting started with connections and running queries.
2025-09-22
7,845 reads
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.
2025-09-22
Create your own test lab on Hyper-V to evaluate SQL Server 2025 and Windows Server 2025
2025-09-19
1,449 reads
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.
2025-09-19
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.
2025-09-17
Learn about a new feature of SQL Server 2022 - Parameter Sensitive Plan Optimization(PSPO)
2025-09-15
1,582 reads
How can we setup alerts in Azure SQL MI to notify us when there are issues?
2025-09-15
A look at window functions in SQL and how they can be used to query data without the restrictions of a GROUP BY.
2025-09-12
6,326 reads
This article dives into a fun (and interesting!) strategy for widening fixed-width columns in SQL Server, to reduce downtime, risk, and runtime at the time when a column’s data type needs to be changed.
2025-09-12
A list of all builds for SQL Server 2016. Updated with CU2 for SP2 and CU10 for SP1.
2025-09-10 (first published: 2017-01-25)
40,794 reads
In my previous post, I showed you how to build a snapshot backup catalog...
By Steve Jones
Train employees well enough that they could get another job but treat them well...
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Docker Advice for SQL Server...
Comments posted to this topic are about the item DevOps is DevOps
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers