MySQL is an open-source relational database that is widely used for web applications, it’s easy to use, reliable, secure, and fast....

Leave your peers awe-struck using the "magic trick" of Hypothetical Indexes in SQL Server

A few days ago, I helped one of my customers with a cyber security review questionnaire. One of the sections asked about the guest users...

This series of articles will cover the first steps you should take when entering a new environment, aiming to improve overall...

In SQL Server and Azure SQL, each session has a set of options, which affect the behavior of the session. Here is a useful script...

One of the hardest aspects of a cloud native application design is to decide whether application component or service should be Stateful...

What is Azure Cosmos DB? Azure Cosmos DB is a fully managed, fast and cost-effective NoSQL database with multi-write data distribution to...

General Performance Tuning Chapter 1: To-know Tools This series of articles will cover the first steps you should do when you enter to a...

I had the pleasure of presenting my session on SQL Server Extended Events in SQL Friday. Here are the session materials...

In April 2020 I created the open-source project "SQL Server Page Allocation Reports". It is time to revisit that project and see what's new!