News

InfoWorld2d

13 reasons SQL has got to go

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even ...
InfoWorld6d

Chat with data the easy way in R or Python

Why write SQL queries when you can get an LLM to write the code for you? Query NFL data using querychat, a new chatbot ...
Redmond Magazine2y

Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...
Ars Technica13y

Powershell. SQL Query. How to determine if a query returns no results?

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 minutes ...
Redmond Magazine3y

A Deep Dive into SQL Server 2022's Query Performance Features, Part 1

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...