Author: Michelle Gutzait

Save Costs by Consolidating SQL Server On-Prem or in the Cloud

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…

Read More >

Best Practice Recommendations for Windows Hosting SQL Server on VMware

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…

Read More >

Azure Data Lake basics for the SQL Server DBA / developer and… for everyone!

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….

Read More >

Migrate a SQL Server environment with complex replication without reinitializing or rebuilding replication

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.

Read More >

Use case for SQL server table partitioning

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.

Read More >

Locks, blocks and deadlocks – what’s the difference?

  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…

Read More >

SQL 2016 – Improve Performance with the Query Store feature: Part 1

  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…

Read More >

Issues with Plan Cache Reuse & Row Goal Optimization

  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…

Read More >

SQL Server: migrations/upgrades – 10 things to think about

Here at Pythian we have planned and implemented dozens of migrations and upgrades for our customers. In this blog post I am trying to summarize the 10 most important things to consider when migrating or upgrading a SQL Server environment,…

Read More >

Speaking at the Spanish virtual PASS chapter

Title : Recuperación de desastres y soluciones de alta disponibilidad con SQL Server Event link: https://globalspanish.sqlpass.org/Inicio.aspx?EventID=1846 Event description: “Esta presentación presenta las soluciones de recuperacion de desastres (Disaster Recovery) y alta disponibilidad (High Availability) con SQL Server y ofrece escenarios…

Read More >
Page 1 of 212