The Choice of SQL Server Version
Brent Ozar has his quarterly report on SQL Server versions and SQL Server 2022 isn't being used as much. Does that make sense to you? What versions are you installing?
Creative Development
An interesting approach to schema changes is a creative solution to Steve. He asks if you have other creative solutions you've seen.
Exploring Parameter Sensitive Plan Optimization in SQL Server 2022
PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance by accepting varied data sizes based on the runtime parameter value(s) specified by the customer. It deals with the situation in which a single cached plan for a parameterized query isn't the best option for all potential incoming parameter values. Non-uniform data distributions exhibit this phenomenon. When using PSPO, SQL Server keeps several execution plans for a single query, each one customized for a particular parameter value. With the help of this feature, numerous execution plans for a parameterized query are generated, each of which is tailored for a certain range of parameter values.
PASS Data Community Summit - Early Bird price ends July 26
Ready to secure your spot at PASS Data Community Summit? Register by July 26 at the Early Bird rate.
SQL Server vs Oracle Query Statistics to Improve Performance
In this article, learn how to query cached query statistics and execution plans for Oracle or SQL Server to identify code that can be optimized to improve performance.
A Paste Policy
Steve saw a policy on code usage in software development and wondered how many companies have this.
PASS Data Community Summit
Check out the full details for this year's Pre-Cons and Learning Pathways, and find out why some of our speakers are particularly excited for what’s in store this year. If you’re not already on the mailing list, sign up now and be the first to know all Summit 2023 updates.
The role of forethought for a computer engineer
If you have ever played a game of chess against someone good, or perhaps against a computer, you know that a good player is always thinking multiple moves ahead. Being a DBA and/or a database programmer is like playing several chess games simultaneously.
Building a Database Dashboard with SSRS
Learn how to create a dynamic database dashboard that tracks key metrics using SQL Server Reporting Services. From setting up to deploying your report.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers