Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Learn how a setting an improve high concurrency inserts with the OPTIMIZE_FOR_SEQUENTIAL_KEY option.
2025-10-01
2,846 reads
Articles
Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples
The JOIN statement is one of the most common operations SQL developers perform. Yet in a world ruled by Inner and Left Joins, the poor Full Outer Join is like Cinderella before the ball – allowed out on only the rarest of occasions. In an (unscientific) survey I once performed of SQL developers at one Fortune 100 firm, half of the developers had never used a Full Outer Join in production code, and the rest had used it in a tiny handful of occasions.
2025-10-01
How to Use SQL Server Features to Cut Web App Latency in Half
Discover how SQL Server features reduce web app latency. Learn key tactics to deliver faster queries and better performance in today’s web economy.
2025-09-29
1,825 reads
Building a Dynamic Countdown Timer in Power BI
A countdown timer can be a powerful visual tool in many Business Intelligence reporting scenarios. This could be for marketing campaigns, contract expiries, and business deals with clients. Real-time countdown visuals are not natively supported in Power BI. Although, there is the Count Down Timer custom visual, which is not dynamic in its configuration.
2025-09-29
Building a Simple SQL/AI Environment
This article shows a simple way to integrate a local GEnAI model into your T-SQL work.
2025-09-26
4,705 reads
Power BI TMDL View: Benefits, Security Risks & Best Practices
The Tabular Model Definition Language (TMDL) provides a simpler way of defining Power BI Semantic Models. Unlike the JSON-based Tabular Model Scripting Language (TMSL), TMDL uses a more accessible tab-based format for specifying DAX measures, relationships, and Power Query code.
2025-09-26
When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Learn how a trace flag affects SQL Server reading from disk and where this might be a useful thing for you to enable.
2025-09-24
2,081 reads
Side by Side Upgrade to SQL Server 2022
As a SQL Server DBA, the migration of SQL Server from an existing version to the latest version is a usual activity. In today’s cloud-oriented world, many organizations still prefer an on-prem environment; my organization is one of them. There are multiple reasons to keep your data on-prem, like having more privacy and control of the environment. Currently, our major project is to migrate our existing Microsoft SQL Server 2019 to SQL Server 2022. Recently, we completed the POC. Today, let’s discuss the steps of the SQL Server 2022 installation and migration of our databases.
2025-09-24
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,357 reads
Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices
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
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers