Easy performance gain for data extensive process
by Michal Kovaľ on 24/05/2022This is one of our tuning successes, particularly for the nightly process of loading data into a report server from the main database.
Read moreFew days ago I have noticed that there will be a change (again) in certification paths for next generation of SQL servers. So I would like to recommend some thoughts about this from Microsoft Certified Masters (MCM) of Brent Ozar PLF Company.
Michal Tinthofer is the face of the Woodler company which (as he does), is fully committed to complete support of Microsoft SQL Server products to its customers. He often acts as a database architect, performance tuner, administrator, SQL Server monitoring developer (Woodler SMT) and, last but not least, a trainer of people who are developing their skills in this area. His current "Quest" is to help admins and developers to quickly and accurately identify issues related to their work and SQL Server runtime.
This is one of our tuning successes, particularly for the nightly process of loading data into a report server from the main database.
Read moreIn high-concurrency environments, deadlocks are more than just technical glitches...they are silent performance killers.
Read moreRecently, we have got a case where our customer requested to implement archiving strategy for their DWH. We wanted to share with you how we approached this and what was the final output.
Read more