Infrastructure at your Service

SQL Server Archives - Page 20 of 22 - Blog dbi services

Stéphane Savorgnano

SQL Server 2012 SP1: Fifth Cumulative Update (CU5) available

By | Technology Survey | No Comments

On 16 July, Microsoft published the fifth Cumulative Update (CU5) for Microsoft SQL Server 2012 Service Pack One. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it. Which issues are covered by this CU5? This Cumulative Update contains 29 Hotfixes: 20 for the Engine 5 for SSRS 2 for SSIS 2 for SSAS If you want more information and/or details about these Hotfixes, click…

Read More
Stéphane Haby

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

By | Database management | No Comments

SQL Server 2014 bietet jetzt (oder bald :roll:) 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….

Read More
Stéphane Haby

SQL Server 2014 CTP1 is available

By | Technology Survey | No Comments

Last week, I gave you some news about SQL Server 2014 (here). SQL Server 2014 Community Technology Preview 1 (CTP1) now is available for download on TechNet here (you need a TechNet subscription).   Attention: Only the new feature “in-memory OLTP – codename Hekaton” has been added to this CPT. I hope that other features will soon come with the next CTPs. If you don’t have a TechNet subscription yet, be patient, it should arrive soon….

Read More
Stéphane Savorgnano

Microsoft TechEd Madrid: Optimizing T-SQL & SQL Server 2014 Futures and Features

By | Technology Survey | No Comments

Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternström, Lead Program Manager, was the speaker of this session. His team, five hundred persons, works on SQL Server engine and mostly focuses on performance. There are 3 three different ways to run SQL: Physical machine can be scale-up full control roll your own…

Read More
Microsoft Team

Three basic points on SQL Server Best Practice

By | Technology Survey | No Comments

A few weeks ago, I went to the Swiss Database Days 2013 and followed the “Practical SQL Server Performance Troubleshooting” workshop. During this workshop, I have seen a different way of troubleshooting, but I was surprised to see that some participants were not aware that some basic SQL Server Best Practice do not depend on the instance settings. This blog posting is a reminder of some of these points. Swiss Database Days 2013: SQL Server…

Read More
Stéphane Haby

SQL Server 2012: System views poster available

By | Database management | No Comments

Good news for all SQL Server DBAs: DMVs and DMFs poster are now available for SQL Server 2012. You can download them here. You can choose between 2 formats: pdf and xps. What’s new? You will notice the new category AlwaysOn: You can see the ColumnStore Index in the Partitioning section: If you want to know more about the new features of SQL Server 2012, please note that we are organizing an SQL Server 2012…

Read More
Stéphane Savorgnano

Windows Server 2012 R2: soon available

By | Technology Survey | No Comments

During North America TechEd, Microsoft released some details on the upcoming release of Windows Server. This new version is called Windows Server 2012 R2 and will be at the heart of the Microsoft Cloud OS. Windows Server 2012 R2 is currently in preview and will be soon available for evaluation purposes. Register to be notified when the new product evaluation will be available. Apparently two versions will be available: Windows Server 2012 R2 Windows Server…

Read More
Stéphane Savorgnano

SQL Server 2012 SP1: Fourth Cumulative Update (CU4) available

By | Technology Survey | No Comments

Microsoft has just published the Fourth Cumulative Update (CU4) for Microsoft SQL Server 2012 SP1. If this CU covers an issue you are experiencing, you should install it quickly. Otherwise, it is not mandatory. Which issues are covered by CU4? This CU4 contains 39 Hotfixes: 24 for the Engine 3 for SSIS 7 for SSAS 5 for SSRS If you need more information and/or details on these hotfixes, click here. Historic of SQL Server 2012…

Read More
Stéphane Haby

SQL Server 2014: the next version

By | Technology Survey | No Comments

At TechEd North America 2013, Microsoft introduced a lot of new versions: Windows Server 2012 R2, System Center 2012 R2, Windows 8.1, Visual Studio 2013 and, and, and… SQL Server 2014, of course!8-O You think I’m crazy or it’s a joke!;-) No, No, it’s for real. You can see the first page about SQL Server 2014 on Microsoft site here: You can register to be part of the first testers having an evaluation version. An…

Read More
Stéphane Haby

SQL Server 2012: CompoundCurve – a new geospatial feature

By | Database management | No Comments

There are three new geospatial features in Microsoft SQL Server 2012: CircularString, CurvePolygon, and CompoundCurve. For the fun and as an example, I will test CompoundCurve, a set of circular strings that may be combined with line strings, and store a “dbi” character set in a table.:-D What is CompoundCurve? It’s a set of circular strings, or circular strings combined with line strings, that form a desired curved shape. The end point of each element…

Read More