Pseudo Code for batch processing using WHILE LOOP

  Leveraging WHILE LOOP

Split data into N equal groups

In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...

Split data into N equal groups

In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...

Upcoming SQLpassion Online Trainings

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...

Weekly reading #28

September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...

Weekly reading #28

September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...

How I applied 13 cumulative updates in 12 minutes

Twitter is a strange place. I mean, aside from all the outrage practice and animal videos. Last week I sent out a tweet about how I used dbatools to...

How to Reduce the Risk of SQL Database Corruption

Introduction:

Today we are going to learn how to prevent SQL database corruption. Let’s start with some facts about how database corruption can occur actually. The SQL database corruption could...

I’m Speaking at Microsoft Ignite 2019

I’m happy to be speaking at Microsoft Ignite this year. I have an unconference session and a regular session, both focused on accessibility in the Power Platform. The regular...

Instantaneous Transaction Rollback with SQL 2019

If you’ve read about the Accelerated Database Recovery feature in SQL Server 2019 you could be forgiven for thinking it’s just about speeding up database recovery time in case...