Author: Michelle Gutzait

Overview Here’s a scenario we’ve seen in many businesses; your SQL Server database has grown to the point that performance has degraded significantly, and your business no longer meets the intended RTO (recovery time objective). In this case, your database…

Database unavailability or outright failure is no joke. Not only do such incidents often cause massive internal stress (along with the inevitable blame game between IT staff), but they can also negatively impact business outcomes and lead to dissatisfied or…

There’s a lot of buzz around consolidation nowadays, as well as some fear of change. You may want to consolidate your SQL Server environments to save on maintenance and license costs, and also potentially on hardware and the size of…

Did you know it’s very important to ensure that your VMware environment is properly set when hosting SQL Server instances? Imagine you have a host server with specific specs. Now you need to create virtual machines on it and ensure…

The basics If you’re a Microsoft SQL Server DBA or developer and have not been introduced to the Microsoft Azure Data Lake and would like to understand what it’s all about and how to get started, this article is for YOU….

Michelle Gutzait, one of Pythian’s SQL Server Experts, discusses how to migrate a SQL Server environment with complex replication without reinitializing or rebuilding replication.

Michelle Gutzait, one of Pythian’s SQL Server Experts, offers some helpful use cases for those who have trouble deciding which tables they should partitioning or not.

  We are often being paged by development teams talking about locks, blocks or deadlocks and some people make the wrong use of the terms. There is a big difference between the three and it will explained at a high level…

  After playing with this great new feature for some time and speaking about it during a SQL Saturday in Montreal, I can say that I am very excited about Query Store in SQL 2016! Performance tuning is our bread and butter…

  I am presenting here on behalf of my colleague  Fabiano Amorim (he is busy resolving other exciting performance issues…  :-D ) . Fabiano had an interesting case with one of our customers that is very common in SQL Server. The…