Parking Garages And Predicates
You lost your car in a big parking lot. Erik Darling explains how this is just like an index scan.
Navigating Hadoop Resources
Learn where to get the latest installation and learning resources for the ever-evolving components of Hadoop ecosystem and how those components may complement Microsoft SQL Server common everyday tasks.
“But I don’t need to back up that database.”
Brent Ozar shares four stories of people who thought they could avoid backups - and got burned.
Reasons to Upgrade
There are always reasons to upgrade or avoid upgrading to a new version. Steve Jones has a few thoughts.
Scripting Objects with PowerShell
In the third installment of this series, Steve Jones uses PowerShell to source control code.
150 SQL Code Smells
Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there were 120 of them at the time. Phil Factor has continued to collect them and the current state of the art is reflected in this article. SQL Prompt is committed to cover as many as possible of them. Phil has also updated his book, which is free to download.
Would You Move to Linux for Price?
There's a sale on the price of SQL Server for Linux and Steve wonders if people will move.
Preventing Invalid Data Early In An ETL Flow
In this post, Tim Smith will look at some of the considerations for both data rules and logic to prevent invalid data early in the ETRL process.
Auto-Deleting Data
Steve likes that idea of auto deleting data, especially with legislation increasing.
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers