Blog - comments

Great script Franck! Just saved me a ton of ball ache. Cheers Ralph

Hi Martin and Jim, your're right. Default fetch size is too small on most clients and because buffer...
Well noone else is biting, so here goes ... Small sqlplus arraysize + lots of rows per block => each...
Jim Dickson
I think your arrysize is 15 (10000 rows, 668 roundtrips; not a surprise in sqlplus). For the query w...
Martin Preiss
Thanks Martin for the link. This is why I selected lpad(x,2000,x) in order to have some volume. But...
Blog Stephane Haby SQL Server 2014: AlwaysOn-Verfügbarkeitsgruppen - jetzt mit Microsoft Cloud!

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Posted by on in Technology Survey

SQL Server 2014: AlwaysOn-Verfügbarkeitsgruppen - jetzt mit Microsoft Cloud!

SQL Server 2014 bietet jetzt (oder bald Wink) die Möglichkeit der Integration von AlwaysOn-Verfügbarkeitsgruppen mittels virtueller Maschinen, gehostet in der Windows-Azure-Infrastruktur (IaaS).


Sie können sekundäre Datenbanken direkt in der Cloud vorhalten, wie das Beispiel zeigt:



Der Einsatz von asynchroner sekundärer Replikation in der Cloud ist durch die Integration des Assistenten in SQL Server Management Studio (SSMS) erleichtert worden.


Was sind die Vorteile dieser Entwicklung?

  • Der erste Vorteil ist Kostensenkung, wenn Sie Ihre Hochverfügbarkeitslösung erweitern wollen.
  • Der zweite ist die reduzierte Belastung der primären Server, indem jetzt Backup-Aufgaben und Reports direkt auf dem sekundären Replikat von Cloud ausgeführt werden.

Und schlussendlich kann gesagt werden, dass in dieser neuen Version bis zu acht sekundäre Replikate möglich sind (in SQL Server 2012 nur vier), aber davon nur zwei synchron, wie SQL Server 2012. 

Ich kann nicht warten, ich muss testen!Cool

Rate this blog entry:

Stéphane Haby is Delivery Manager and Senior Consultant at dbi Services. He has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. Stéphane Haby is Microsoft Certified Solutions Associate MCSA) for SQL Server 2012 as well as Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008. He is also ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking / Financial Services, and many other industries.



  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Wednesday, 01 April 2015
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)


Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter