See how SQL Server's Parameter Sensitive Plan optimization handles skewed parameters, how to verify dispatcher plans, and where PSP still falls short.
It's the first week of September, but Steve sees it as the end of summer. It's a time to catch up on things.
This guide covers how TRANSLATE() works, how it compares to REPLACE(), and where it falls short compared to other SQL dialects like PostgreSQL and Oracle.
Learn to use DuckDB to read data from Excel and then send it to SQL Server with Python and Pandas.
Today Steve wonders if the data professionals out there measure themselves on the job.
What's the difference between SQL Server's row compression and page compression, and when does each one make sense?
How a simple Extended Events session can turn you from a silent guardian to a developer’s best ally. There is an old, undeniable paradox in the life of a Database Administrator: If you do your job perfectly, nobody remembers you exist, only when you resolve problems. When queries are fast, backups are pristine, and the […]
Today Steve has a few comments on backups and your ability to get to a restore in the event of an issue with your provider.
You’re using SQL Server Management Studio (SSMS) and would like to use Dark Mode. You’ve looked at the configuration options and don’t see a way to configure it.
DBAKevlar disccusses the new product from Perplexity and Nvidia that just shipped on August 25th. If you haven’t been paying attention its goal is businesses whose entire generative AI solution has been what the AI bubble is betting on.
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Comments posted to this topic are about the item Hyperscale Replicas I
Comments posted to this topic are about the item The End of Summer
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers