Since Github doesn't provide a great way for you to learn about new releases and features, don't just star the repo, join the mailing list. dsq will likely work on other platforms that Go is ported to ...

SQL Server DBA specializing in performance tuning and disaster recovery. Bad code rarely begins the cascade of most SQL Server performance problems. Typically, it begins with something that is much ...

This time, I'm going to write about learning SQL. It all started with a casual comment from my teacher one day and a reference book placed in front of me. “You should try getting your hands on SQL ...

Elasticsearch is an open-source, distributed JSON-based search and analytics engine built using Apache Lucene to provide fast real-time search functionality. It is a NoSQL data store that is ...

pre-commit is a nice development tool to automatize the binding of pre-commit hooks. After installation and configuration pre-commit will run your hooks before you commit any change. CREATE OR REPLACE ...

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

SQL has dominated data querying for decades. Newer query languages offer more elegance, simplicity, and flexibility for modern use cases. For the last three decades, databases and Structured Query ...