Infrastructure at your Service

AlwaysOn Archives - Page 3 of 3 - Blog dbi services

David Barbarin

SQL Server 2016 : availability groups and the new clustered columnstore index support

By | Hardware & Storage | No Comments

This blog post is focused on the new supportability of clustered columnstore index on the high- availability read-only replicas. Others studies are available here: New database issue level detection for automatic failover Potential features in standard edition Automatic failover enhancements New load balancing features with read-only replicas After reading some improvements from the columnstore index feature side, I was very surprised to see the following section:   Clustered columnstore indexes are now supported on AlwaysOn…

 
Read More
Microsoft Team

Recap SharePoint Event Paris 2015

By | Application integration & Middleware | No Comments

  Guillaume Meunier and I went to SharePoint Event 2015 in Paris on Saturday 30, May. This event was well organized and on time! We learned about the news features regarding SharePoint, related to B.I, SQL, governance, collaboration & Communication, Workflow and Process System. The sessions we followed are: How OneDrive Company revolutionized storing files in my business Almost all companies use the SMB file system and deployment networks on workstations to store and centralize…

 
Read More
David Barbarin

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

By | Technology Survey | No Comments

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 box, ce qui peut être pratique si vous voulez manger     Pour ma part j’aurai l’occasion d’ouvrir le bal et de vous retrouver au cours d’une session sur SQL Server et les groupes de disponibilité (cela devient presque une habitude) lundi matin à…

 
Read More
David Barbarin

Pass summit 2014: My favorite sessions of this great event

By | Technology Survey | No Comments

The Pass Summit 2014 is now over and it’s time for us to go back home. I want to share my favorite sessions with you in this post.   Pass Summit was really an amazing event regardless of the expertise area (BI or SQL Server engine). This was also a good opportunity to meet SQL Server guys in others countries as well as the French SQL Server community. We attended a lot of interesting sessions…

 
Read More
Stéphane Haby

Les journées SQL Server 2014 – un event qui devrait vous intéresser!

By | Technology Survey | No Comments

Comme vous le savez peut-être déjà, le plus grand événement SQL Server francophone arrive bientôt. Les journées SQL Server 2014, organisées par le GUSS, (Groupement des Utilisateurs SQL Server) sont à Paris les 1 et 2 décembre 2014. dbi services y est aussi – et vous?   Les journées SQL Server 2014 Voici le site de l’event: http://guss.pro/2014/12/01/journees-sql-server-2014/ Les 2 jours traitent aussi bien de l’administration, du développement que de la BI SQL Server 2014….

 
Read More
David Barbarin

SQL Server: Forced failover with AlwaysOn & Availability Groups

By | Hardware & Storage | No Comments

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 with allowed data loss. Does SQL Server resynchronize availability databases if I loose some transactions during the failover process? The quick answer is yes but probably the most interesting question is how SQL Server achieves resynchronization…

 
Read More
David Barbarin

SQL Saturday 323: SQL Server AlwaysOn and availability groups session slides

By | Hardware & Storage | 4 Comments

This SQL Saturday’s edition in Paris is now over. It was a great event with a lot of French and international speakers. There were also many attendees indicating that this event is a great place to share about SQL Server technologies. Maybe the Montparnasse tower in Paris played a role here with its panoramic view over Paris from the 40th floor! For those who didn’t attend on Saturday, you will find our SQL Server AlwaysOn…

 
Read More
David Barbarin

SQL Server 2014: Availability groups failover impossible with Failover Cluster Manager

By | Hardware & Storage | 2 Comments

A couple of weeks ago, I worked for a customer that wanted to implement SQL Server 2012 (and not SQL Server 214) AlwaysOn with availability groups. During our tests we performed a bunch of failover tests and the customer tried to perform a failover of one of the installed availability group by using the failover cluster manager (FCM). Of course, I told him this is not best practice because the failover cluster manager is not…

 
Read More