Do the transforms in the SQL, not in the visualization tool
November 25, 2024 at 2:50 AM
Do the transforms in the SQL, not in the visualization tool
SQL is a more powerful tool for slicing and dicing data, but a less powerful tool for working with my colleagues who do not know SQL.
October 13, 2023 at 3:41 PM
SQL is a more powerful tool for slicing and dicing data, but a less powerful tool for working with my colleagues who do not know SQL.
Announcing Free SQL Server Performance Monitoring That Doesn't Suck
Announcing Free SQL Server Performance Monitoring I built a free, open-source SQL Server performance monitoring tool. Two editions, no licensing...
Announcing Free SQL Server Performance Monitoring I built a free, open-source SQL Server performance monitoring tool. Two editions, no licensing...
Announcing Free SQL Server Performance Monitoring That Doesn't Suck
Announcing Free SQL Server Performance Monitoring I built a free, open-source SQL Server performance monitoring tool. Two editions, no licensing fees, no telemetry, no cloud dependency. Here's what it does...
erikdarling.com
February 11, 2026 at 5:19 PM
Announcing Free SQL Server Performance Monitoring That Doesn't Suck
Announcing Free SQL Server Performance Monitoring I built a free, open-source SQL Server performance monitoring tool. Two editions, no licensing...
Announcing Free SQL Server Performance Monitoring I built a free, open-source SQL Server performance monitoring tool. Two editions, no licensing...
Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules - free, open source cross platform command line tool for SQL Server developers
#sqlserver #dotnet #oss
#sqlserver #dotnet #oss
Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules
T-SQL Analyzer is a free, open-source new command line tool for identifying, and reporting the presence of anti-patterns in SQL Server T-SQL scripts.
buff.ly
February 17, 2025 at 2:08 PM
Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules - free, open source cross platform command line tool for SQL Server developers
#sqlserver #dotnet #oss
#sqlserver #dotnet #oss
qStudio est un outil open-source sous licence Apache 2.0, étant à la fois un client SQL et un notebook permettant de faire de la data analyse avec un mode présentation, des graphiques, etc ... ⬇️
github.com/timestored/q...
github.com/timestored/q...
GitHub - timestored/qstudio: qStudio - Free SQL Analysis Tool
qStudio - Free SQL Analysis Tool. Contribute to timestored/qstudio development by creating an account on GitHub.
github.com
October 9, 2025 at 5:58 AM
qStudio est un outil open-source sous licence Apache 2.0, étant à la fois un client SQL et un notebook permettant de faire de la data analyse avec un mode présentation, des graphiques, etc ... ⬇️
github.com/timestored/q...
github.com/timestored/q...
New release of T-SQL Analyzer CLI - adds the ability to analyze a .dacpac or a live database!! 🥳 🤯
To install:
dotnet tool install -g ErikEJ.DacFX.TSQLAnalyzer.Cli
erikej.github.io/sql/dacfx/20...
To install:
dotnet tool install -g ErikEJ.DacFX.TSQLAnalyzer.Cli
erikej.github.io/sql/dacfx/20...
Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules
T-SQL Analyzer is a free, open-source new command line tool for identifying, and reporting the presence of anti-patterns in SQL Server T-SQL scripts.
erikej.github.io
February 23, 2025 at 4:29 PM
New release of T-SQL Analyzer CLI - adds the ability to analyze a .dacpac or a live database!! 🥳 🤯
To install:
dotnet tool install -g ErikEJ.DacFX.TSQLAnalyzer.Cli
erikej.github.io/sql/dacfx/20...
To install:
dotnet tool install -g ErikEJ.DacFX.TSQLAnalyzer.Cli
erikej.github.io/sql/dacfx/20...
I saw some election deniers showing how easy it is to manipulate a voter database by using "this hacking tool called SQL Server Management Studio."
November 21, 2023 at 1:31 AM
I saw some election deniers showing how easy it is to manipulate a voter database by using "this hacking tool called SQL Server Management Studio."
You can use my free T-SQL Analyzer command line tool to check for over 140 anti-patterns in your SQL scripts directly in SQL Server Management Studio (SSMS)
#dotnet #sqlserver #databases
#dotnet #sqlserver #databases
SqlServer.Rules/tools/SqlAnalyzerCli/readme.md at master · ErikEJ/SqlServer.Rules
120+ T-SQL static code analysis rules for SQL Database Projects - ErikEJ/SqlServer.Rules
github.com
April 2, 2025 at 10:21 AM
You can use my free T-SQL Analyzer command line tool to check for over 140 anti-patterns in your SQL scripts directly in SQL Server Management Studio (SSMS)
#dotnet #sqlserver #databases
#dotnet #sqlserver #databases
By the way, if you think an LLM can't reason, give it an SQL tool and point it at a database it's never seen before and ask it a question.
April 21, 2026 at 4:06 PM
By the way, if you think an LLM can't reason, give it an SQL tool and point it at a database it's never seen before and ask it a question.
Shhh I see dead SQL. 🤫
I’m launching an exciting new dev tool for Halloween. 💀
I’m launching an exciting new dev tool for Halloween. 💀
September 11, 2025 at 10:23 AM
Shhh I see dead SQL. 🤫
I’m launching an exciting new dev tool for Halloween. 💀
I’m launching an exciting new dev tool for Halloween. 💀
A free SQL explain plan visualizer tool by @datadoghq
Currently for PostgreSQL, MySQL, MSSQL and MongoDB
explain.datadoghq.com
Currently for PostgreSQL, MySQL, MSSQL and MongoDB
explain.datadoghq.com
January 28, 2026 at 11:18 PM
A free SQL explain plan visualizer tool by @datadoghq
Currently for PostgreSQL, MySQL, MSSQL and MongoDB
explain.datadoghq.com
Currently for PostgreSQL, MySQL, MSSQL and MongoDB
explain.datadoghq.com
saw someone say AI can’t write SQL
some data for anyone that cares -
@honeycomb.io offers agents a query tool against our datastore; it’s a custom JSON schema, which means it’s very unlikely to be something models know very well from the jump
some data for anyone that cares -
@honeycomb.io offers agents a query tool against our datastore; it’s a custom JSON schema, which means it’s very unlikely to be something models know very well from the jump
August 22, 2026 at 2:03 PM
saw someone say AI can’t write SQL
some data for anyone that cares -
@honeycomb.io offers agents a query tool against our datastore; it’s a custom JSON schema, which means it’s very unlikely to be something models know very well from the jump
some data for anyone that cares -
@honeycomb.io offers agents a query tool against our datastore; it’s a custom JSON schema, which means it’s very unlikely to be something models know very well from the jump
After 6 years, today I learned how to build dashboards at work using custom SQL queries without having to bother a data analyst. I asked AI to teach me how to do so using internal info.
People say AI atrophies the brain but it’s just a tool, like the internet which can expand your mind or erode it
People say AI atrophies the brain but it’s just a tool, like the internet which can expand your mind or erode it
February 27, 2026 at 10:30 PM
After 6 years, today I learned how to build dashboards at work using custom SQL queries without having to bother a data analyst. I asked AI to teach me how to do so using internal info.
People say AI atrophies the brain but it’s just a tool, like the internet which can expand your mind or erode it
People say AI atrophies the brain but it’s just a tool, like the internet which can expand your mind or erode it
Just released the db* CODECOP tool suite supporting the latest Trivadis #PLSQL & #SQL Coding Guidelines v4.3.
The screenshots show SQL injection vulnerabilities via a custom validator in SQL Developer and SonarQube.
See github.com/topics/codecop.
The screenshots show SQL injection vulnerabilities via a custom validator in SQL Developer and SonarQube.
See github.com/topics/codecop.
October 4, 2023 at 7:30 PM
Just released the db* CODECOP tool suite supporting the latest Trivadis #PLSQL & #SQL Coding Guidelines v4.3.
The screenshots show SQL injection vulnerabilities via a custom validator in SQL Developer and SonarQube.
See github.com/topics/codecop.
The screenshots show SQL injection vulnerabilities via a custom validator in SQL Developer and SonarQube.
See github.com/topics/codecop.
Blog post: Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules - T-SQL Analyzer is a free, open-source new command line tool.
#dotnet #sqlserver #tsql
#dotnet #sqlserver #tsql
Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules
T-SQL Analyzer is a free, open-source new command line tool for identifying, and reporting the presence of anti-patterns in SQL Server T-SQL scripts.
buff.ly
May 21, 2025 at 8:22 AM
Blog post: Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules - T-SQL Analyzer is a free, open-source new command line tool.
#dotnet #sqlserver #tsql
#dotnet #sqlserver #tsql
Real engineering judgment:
If a regex solves it, use a regex.
If a SQL query solves it, use a SQL query.
If a deterministic function solves it, write the function.
Reaching for an LLM when you don't need one is how you get slow, expensive, unreliable software. Use the right tool.
If a regex solves it, use a regex.
If a SQL query solves it, use a SQL query.
If a deterministic function solves it, write the function.
Reaching for an LLM when you don't need one is how you get slow, expensive, unreliable software. Use the right tool.
April 15, 2026 at 12:43 AM
Real engineering judgment:
If a regex solves it, use a regex.
If a SQL query solves it, use a SQL query.
If a deterministic function solves it, write the function.
Reaching for an LLM when you don't need one is how you get slow, expensive, unreliable software. Use the right tool.
If a regex solves it, use a regex.
If a SQL query solves it, use a SQL query.
If a deterministic function solves it, write the function.
Reaching for an LLM when you don't need one is how you get slow, expensive, unreliable software. Use the right tool.
Working on H3 integration into freestiler, my R/Python vector tiling tool.
The new feature uses @duckdb.org internally to dynamically aggregate points into a multi-layer hexagonal tileset based on some function (summary stats, or your own custom SQL).
Tiled here: 12M US groundwater wells
The new feature uses @duckdb.org internally to dynamically aggregate points into a multi-layer hexagonal tileset based on some function (summary stats, or your own custom SQL).
Tiled here: 12M US groundwater wells
May 25, 2026 at 5:07 PM
Working on H3 integration into freestiler, my R/Python vector tiling tool.
The new feature uses @duckdb.org internally to dynamically aggregate points into a multi-layer hexagonal tileset based on some function (summary stats, or your own custom SQL).
Tiled here: 12M US groundwater wells
The new feature uses @duckdb.org internally to dynamically aggregate points into a multi-layer hexagonal tileset based on some function (summary stats, or your own custom SQL).
Tiled here: 12M US groundwater wells
Lately a lot about SQL has been said. I work with SQL professionally since 1988. And it's a great tool, you can't imagine how was processing lots of data before SQL. An advice: use sqlite in your game if there are many info. Raw SQL or with tools. It's impressive.
#indiedev #gamedev #indiegames
#indiedev #gamedev #indiegames
March 7, 2025 at 8:01 PM
Lately a lot about SQL has been said. I work with SQL professionally since 1988. And it's a great tool, you can't imagine how was processing lots of data before SQL. An advice: use sqlite in your game if there are many info. Raw SQL or with tools. It's impressive.
#indiedev #gamedev #indiegames
#indiedev #gamedev #indiegames
sqlit is a lazygit style SQL TUI for the terminal.
It supports 10+ SQL databases (Postgres, SQLite, Supabase, ClickHouse, DuckDB, etc), has query history, autocomplete and more.
Peter Adams (Maxteabag on GitHub) made sqlit using the Textualize framework and is Terminal Tool of the Week! ⭐️
It supports 10+ SQL databases (Postgres, SQLite, Supabase, ClickHouse, DuckDB, etc), has query history, autocomplete and more.
Peter Adams (Maxteabag on GitHub) made sqlit using the Textualize framework and is Terminal Tool of the Week! ⭐️
December 23, 2025 at 8:54 PM
sqlit is a lazygit style SQL TUI for the terminal.
It supports 10+ SQL databases (Postgres, SQLite, Supabase, ClickHouse, DuckDB, etc), has query history, autocomplete and more.
Peter Adams (Maxteabag on GitHub) made sqlit using the Textualize framework and is Terminal Tool of the Week! ⭐️
It supports 10+ SQL databases (Postgres, SQLite, Supabase, ClickHouse, DuckDB, etc), has query history, autocomplete and more.
Peter Adams (Maxteabag on GitHub) made sqlit using the Textualize framework and is Terminal Tool of the Week! ⭐️
SQL is underrated in the data domain
Learn:
- CTEs
- Window functions
- EXPLAIN plans
Writing better SQL beats adding another tool.
Learn:
- CTEs
- Window functions
- EXPLAIN plans
Writing better SQL beats adding another tool.
May 18, 2025 at 11:23 AM
SQL is underrated in the data domain
Learn:
- CTEs
- Window functions
- EXPLAIN plans
Writing better SQL beats adding another tool.
Learn:
- CTEs
- Window functions
- EXPLAIN plans
Writing better SQL beats adding another tool.
New release of SQL Query Strees, the .NET WinForms base SQL Server stress testing tool that I maintain and publish - now better support for Azure SQL standalone database
https://buff.ly/3CQ1lpJ
#sqlserver #dotnet
https://buff.ly/3CQ1lpJ
#sqlserver #dotnet
Releases · ErikEJ/SqlQueryStress
SQL query stress simulator created by Adam Machanic http://dataeducation.com/sqlquerystress-the-source-code/ - ErikEJ/SqlQueryStress
buff.ly
February 17, 2025 at 9:22 AM
New release of SQL Query Strees, the .NET WinForms base SQL Server stress testing tool that I maintain and publish - now better support for Azure SQL standalone database
https://buff.ly/3CQ1lpJ
#sqlserver #dotnet
https://buff.ly/3CQ1lpJ
#sqlserver #dotnet
I keep seeing people online who think that they have to write *all* SQL using the jOOQ DSL, once they're using jOOQ. This couldn't be further from the truth.
Views are a wonderful tool in all SQL databases, allowing to create libraries of common SQL queries.
Views are a wonderful tool in all SQL databases, allowing to create libraries of common SQL queries.
September 18, 2026 at 8:22 AM
I keep seeing people online who think that they have to write *all* SQL using the jOOQ DSL, once they're using jOOQ. This couldn't be further from the truth.
Views are a wonderful tool in all SQL databases, allowing to create libraries of common SQL queries.
Views are a wonderful tool in all SQL databases, allowing to create libraries of common SQL queries.
Freemium plans available. Works with Claude, ChatGPT, Cursor, Codex and any MCP client. Schema and API docs at scry.io. www.everydev.ai/tools/scry
Scry - SQL Query Engine for AI Agents | EveryDev.ai
Scry is a programmatic internet research tool built as an MCP server, giving AI agents the ability to run structured SQL queries over hundreds of…
www.everydev.ai
September 24, 2026 at 3:33 PM
Freemium plans available. Works with Claude, ChatGPT, Cursor, Codex and any MCP client. Schema and API docs at scry.io. www.everydev.ai/tools/scry
I keep coming back to fselect.
fselect is a open-source utilities. Command-line tool to search files with SQL syntax.
→ Full source available on the repo link.
→ Released under open-source.
You stop paying for proprietary file search tool...
#opensource #selfhosted #utilities
fselect is a open-source utilities. Command-line tool to search files with SQL syntax.
→ Full source available on the repo link.
→ Released under open-source.
You stop paying for proprietary file search tool...
#opensource #selfhosted #utilities
September 27, 2026 at 2:35 PM
I keep coming back to fselect.
fselect is a open-source utilities. Command-line tool to search files with SQL syntax.
→ Full source available on the repo link.
→ Released under open-source.
You stop paying for proprietary file search tool...
#opensource #selfhosted #utilities
fselect is a open-source utilities. Command-line tool to search files with SQL syntax.
→ Full source available on the repo link.
→ Released under open-source.
You stop paying for proprietary file search tool...
#opensource #selfhosted #utilities
SQL is such a widespread and basic tool that this is almost like saying the US government doesn’t use HTML.
February 11, 2025 at 5:58 PM
SQL is such a widespread and basic tool that this is almost like saying the US government doesn’t use HTML.