GitHub

coresql/sql-query-identifier

Identifies the types of each statement in a SQL query (also provide the start, end and the query text). This uses AST and parser techniques to identify the SQL query type. Although it will not ...
Ars Technica

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 ...
TechRepublic

SQL basics: SELECT statement options

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Due to popular demand, we’re ...
GitHub

eoinkelly/rails-raw-sql-guide

What decisions do you need to make? Broadly speaking, these are the sequence of decisions and actions you will need. The rest of this document explains these in more detail. We need to be aware of all ...
Microsoft

Query Store is enabled by default in SQL Server 2022

Part of the SQL Server 2022 blog series. Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database ...