Author: Michelle Gutzait

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 >

List of SQL Server Databases in an Availability Group

After migrating some databases to SQL Server 2012 and creating Availability Groups for some databases, we have noticed that some of our maintenance scripts were failing with the following error: The target database (‘MyDB1’) is in an availability group and…

Read More >

Why Would I Upgrade to SQL Server 2012?

The process of upgrading SQL Server is usually time consuming, costs money and requires availability of human resources. If you don’t see the immediate need…Why bother?! Before deciding on upgrading, you should be aware of the new features and make sure you will really benefit by the upgrade. From our experience at Pythian with dozens of clients and hundreds of environments, what could be worth upgrading to SQL Server 2012?
Here are some of the top features related to the database engine (Part I):

Read More >

Minimize Downtime When Moving to a New SQL Server Environment

I am often asked what ways are there to minimize downtime when upgrading from SQL Server 2000 to SQL Server 2005, or when moving databases to a new (probably bigger and stronger) environment. Well, if you can afford having both–old environment and new environment in parallel–this task can be very easy and straightforward . Here are your options.

Read More >
Page 2 of 212