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!

Read-scale Availability Groups were introduced in SQL Server 2017 as one of AlwaysOn features that provides a read-only copy of your...

Do you have a clear understanding of the difference between a Data Engineer and a Data Administrator? How is Azure AI Engineer different...

Do you want to visualize your RnD team performance to drive business value? Is there anything that is slowing down your development...