You may not be old, but I sure am. As I travel around to all the different conferences to speak, whether we're talking a dev conference, SQL Server, or PostgreSQL, one of the topics that keeps coming up is age. The age of the organizers. It's mostly the same people putting on events for the […]
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.
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Working with SQL Server 2022 can be a great learning experience, but development tasks...
Comments posted to this topic are about the item Looking for New Blood
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers