Blog

DB Pro Services Oy, a leading expert in Microsoft data platforms, aims for global growth under new CEO

DB Pro Services Oy, a pioneer in Microsoft SQL Server database optimization, Azure data platforms, and advanced analytics, welcomes Timo Lindström as its new CEO. Timo, who previously served as Nutani...
Read More

SQL Server performance insights – OR vs UNION ALL is not always what it seems

This blogpost continues my series of blogposts in the field of Microsoft SQL Server performance optimization. Last time we learned, how to build the best performing composite indexes from logical hier...
Read More

SQL Server performance insights – Logical hierarchies in composite indexes

This blogpost starts my series of blogposts in the field of Microsoft SQL Server performance optimization. The goal of these blogposts is to be practical but in-depth, so I hope you find them interest...
Read More

Why understanding CPU contention is so important in Microsoft SQL Server capacity planning

What is CPU contention CPU contention is seriously taken phenomenon in Server, where multiple threads or processes are competing for being processed simultaneously. When level on CPU contention is hig...
Read More

Powerful SQL Server migrations: SQL Governor capacity planning methods

SQL Governor is software for capacity planning of medium to large-scale SQL Server environments to make data migrations smart, easy, and cost efficient.
Read More

Advanced capacity planning techniques on data migration –SQL Server Database Consolidation

This blogpost continues my series of blogposts on advanced capacity planning techniques on data migration. In my previous blogpost I told about SQL Server Instance consolidation. This blogpost is abou...
Read More

Advanced capacity planning techniques on data migration –SQL Server Instance Consolidation

This blogpost continues my series of blogposts regarding advanced capacity planning techniques on data migration. In my previous blogpost I wrote about right sizing and virtualizing SQL Servers. This ...
Read More

Advanced capacity planning techniques on data migration – Right sizing SQL Server

This blogpost continues my series of blogposts regarding advanced capacity planning techniques on data migration. In my previous blogpost I wrote about scaling up SQL Servers. This blogpost is about r...
Read More

Advanced capacity planning techniques on data migration – Scaling up Microsoft SQL Server

This blogpost continues my series of blog posts regarding advanced capacity planning techniques on data migration. In my previous blogpost I wrote an intro regarding this topic. This blogpost is about...
Read More

Advanced capacity planning techniques on data migration

This blogpost starts my series of blogposts regarding advanced capacity planning techniques on data migration. Capacity planning is the most lucrative part of data migration projects. It is not unusua...
Read More