Operating systems Don’t forget to configure Power Management settings on Hyper-V 06.01.2015 by Microsoft Team 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(…)
Technology Survey dbi services wishes you a Merry Christmas with this SQL Server script 18.12.2014 by Microsoft Team 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(…)
Technology Survey Journées SQL Server 2014: Vidéos des sessions disponibles 16.12.2014 by Microsoft Team 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 à(…)
Technology Survey SQL Server 2014 : sortie du livre “Développer et administrer pour la performance” 15.12.2014 by Microsoft Team 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(…)
Hardware & Storage WSFC : Manual or automatic failover? That is the question! 26.11.2014 by Microsoft Team 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(…)
Technology Survey Journées SQL Server 2014: il n’est pas trop tard pour vous inscrire 24.11.2014 by Microsoft Team 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(…)
Database management SQL Server 2014: buffer pool extension & corruption 19.11.2014 by Microsoft Team 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(…)
Database management SQL Server & memory leak: Are you sure? 28.10.2014 by Microsoft Team 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(…)
Operating systems SQL Server failover cluster, VSphere, & SCSI-3 reservation nightmares 23.10.2014 by Microsoft Team 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.
Hardware & Storage SQL Server: Forced failover with AlwaysOn & Availability Groups 16.10.2014 by Microsoft Team 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(…)