Microsoft Team

Don’t forget to configure Power Management settings on Hyper-V

Recently I had the opportunity to audit a SQL Server database hosted on a Hyper-V 2012 cluster. I noticed that the guest operating system had the Power Plan configured to High performance. This is great thing but when I talked to(…)

dbi services wishes you a Merry Christmas with this SQL Server script

The end of the year approachs and soon it will be time to celebrate Christmas with your family and friends. At dbi services, we wish you a merry christmas via SQL Server with the following script, to execute in your(…)

Journées SQL Server 2014: Vidéos des sessions disponibles

Les vidéos des sessions des journées SQL Server 2014 sont enfin en ligne: > Infrastructure et AlwaysOn > Industrialisation des audits (avec Sarah Bessard) Si vous avez des questions n’hésitez pas à(…)

SQL Server 2014 : sortie du livre “Développer et administrer pour la performance”

Un billet en cette fin d’année qui approche à grand pas pour vous annoncer la sortie prochaine (fin décembre 2014) du livre SQL Server 2014 : Développer et administrer pour la performance en français et(…)

WSFC : Manual or automatic failover? That is the question!

During the night, you receive an alert concerning your SQL Server failover cluster or your availability groups and you’re in panic mode because the message displayed is : a failover has occured .. see the log for more details(…)

Journées SQL Server 2014: il n’est pas trop tard pour vous inscrire

Le plus grand événement français va bientôt avoir lieu (1 et 2 décembre) à Paris et il vous reste  encore une semaine pour vous y inscrire! Pensez également à commander votre lunch(…)

SQL Server 2014: buffer pool extension & corruption

I had the opportunity to attend Paul Randal’s session on advanced data recovery techniques at the Pass Summit. During this session one attendee asked Paul if a page that has just been corrupted can remain in the buffer pool extension(…)

SQL Server & memory leak: Are you sure?

I have recently come across an issue with one of my customer that told me that their SQL Server 2008 R2 instance had a memory leak. These are strong words! The server has 64 GB of RAM and the(…)

SQL Server failover cluster, VSphere, & SCSI-3 reservation nightmares

When I have to install a virtualized SQL Server FCI at a customer place as an SQL Server consultant, the virtualized environment usally is ready. I guess this is the same for most part of the database consulting people.

SQL Server: Forced failover with AlwaysOn & Availability Groups

During a workshop at one of my customer about the implementation of SQL Server AlwaysOn and availability groups, I had an interesting discussion. It was about asynchronous replication between 2 replicas and the effect of the forced failover operation(…)