SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth, blocks covering-index usage, and makes code brittle when schemas change. Specify only the columns you...
2025-10-02
4 reads
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth, blocks covering-index usage, and makes code brittle when schemas change. Specify only the columns you...
2025-10-02
4 reads
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily create database snapshots. This new version fixes a bug that we’ve found in version 2...
2025-10-02
1 reads
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there was a great question that I wasn’t sure about. Someone asked about the download size...
2025-10-01
7 reads
Setting page visibility and the active page are often overlooked last steps when publishing a Power BI report. It’s easy to forget the active page since it’s just set...
2025-10-01 (first published: 2025-09-09)
112 reads
(Side note: Excited to share that the audio version of my book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh” is...
2025-10-01 (first published: 2025-09-09)
311 reads
After setting up dozens of Internet of Things (IoT) smart home devices, I started to wonder: how hard could it be to build one from scratch?
I needed a project...
2025-10-01
3 reads
In parts 1 and 2 of this series, we’ve gathered info and done the triage just like anyone in almost any industry does At this point you’ve: Defined what...
2025-10-01
15 reads
Are you diversifying your DBA skillset? My recent job search made one thing clear: the database landscape is broader than just SQL Server and Oracle. More and more companies...
2025-09-30
24 reads
SQL Server 2025 introduces native support for vector data types and external AI models. This opens up new scenarios for semantic search and AI-driven experiences directly in the database....
2025-09-30 (first published: 2025-09-27)
23 reads
Update for SQL Server 2025:
This post and the GitHub repo have been updated for SQL Server 2025 RC1 and Ubuntu 24.04.
New in SQL Server 2025: You no longer need...
2025-09-30 (first published: 2025-09-29)
15 reads
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
By Kevin3NF
In parts 1 and 2 of this series, we’ve gathered info and done the...
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers