Infrastructure at your Service

Tag

AlwaysOn Archives - Page 3 of 4 - Blog dbi services

Microsoft Team

SQL Server AlwaysOn and availability groups : how to isolate the replication traffic from other networks?

By | Database Administration & Monitoring | 12 Comments

A couple of days ago, I was involved in a project about implementing availability groups with SQL Server 2014. My customer wanted to isolate the replication traffic from the public network. The idea behind was to get a better control of the network bandwidth as well as to be sure that the replication can be done without any latency issues in case of heavily network traffic issued by other applications or backup activities for instance….

Read More
Microsoft Team

Dealing with SSRS subscription schedules in AlwaysOn environment

By | Database management | 13 Comments

A couple of days ago, I had the opportunity to work with AlwaysOn 2014 infrastructure that included a report server (SSRS) in native and scale-out mode. As you know, dealing with SSRS and availability groups is not an easy task depending on the used features. This is particularly true when scheduling and subscriptions are used by customers. Here’s a brief description of the concerned architecture: 2 SSRS servers in scale-out mode and an availability group…

Read More
Microsoft Team

SQL Server 2016 : availability groups and the new SSISDB support

By | Hardware & Storage | 11 Comments

This blog post is focused on the new supportability of SSIDB catalog on AlwaysOn architecture. 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 New clustered columnstore index support A couple of weeks ago, I was involved in an SSIS infrastructure project with SQL Server 2014. As you know, the SSIS architecture has fundamentally changed since…

Read More
Microsoft Team

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

By | Hardware & Storage | 2 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
Microsoft Team

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
Microsoft Team

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
Microsoft Team

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
Microsoft Team

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…

Read More