Designing Databases for Distributed Systems

Several data management patterns have emerged for microservices and cloud-native solutions. Learn important patterns to manage data in a distributed environment.

What I Wish Everyone Knew About ETL Processes - Traditional to Modern Cloud Solutions

Learn about the evolutionary journey of ETL (Extract, Transform, Load) from traditional processes to modern cloud solutions.

Explore Natively Compiled SQL Server Stored Procedure Execution Plans

In this article, we look at execution plans and performance of a natively compiled stored procedure versus a traditional stored procedure.

What Is Good Database Design?

Find out how good database design is essential to ensure data accuracy, consistency, and integrity and that databases are efficient, reliable, and easy to use.

New Microsoft Sandbox Uses Natural Language LLMs for SQL Queries

Decision Tree - Credit Card Fraud Detection

Credit card fraud detection is an important application of machine learning techniques, including Decision Trees. The goal is to identify and detect fraudulent transactions and separate them from valid transactions to prevent financial loss and protect user accounts.

Alternatives To SQL Server 2022 Built-in function GREATEST

If you haven’t already heard, SQL Server 2022 introduced a new built-in system function called GREATEST. Simply put, it is to a set of columns, variables, expressions etc. what the MAX function is to a set of values (i.e., rows) of a single column or expression.

SQL Athena Introduction - How it works, Use Cases and Advantages

Learn about Amazon Athena, how it works, why you would use it, and some of the advantages of Athena over traditional relational databases.

Power BI Workspace Permissions and Roles

What are the Power BI workspace permissions and roles and how are they used?

Analyze and Tune SQL Server Statistics

Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and I believe that they will remain a core topic for a while when speaking about performance. Why is that?