Infrastructure at your Service

Tag

SQL Server 2014 Archives - Page 6 of 7 - Blog dbi services

Stéphane Haby

Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2

By | Application integration & Middleware | One Comment

Delayed Transaction Durability is a new SQL Server 2014 feature that was not included in SQl Server 2014 CTP1 but discreetly published in CTP2. It is a very interesting functionality that helps reducing the IO contention for transaction log writes. In other databases engine, you will find equivalents such as: Oracle: ‘COMMIT WRITE BATCH WAIT|NOWAIT’ (link here) MySQL: ‘group_commit’ since version 4.x (link here) PostgreSQL: ‘group_commit’ introduce in version 9.2 (link here) What is it…

Read More
Stéphane Savorgnano

SQL Server 2014: Readable Secondary with In-Memory objects

By | Database management | No Comments

In-Memory OLTP is one of the best new functionalities of SQL Server 2014 as it was the case with AlwaysOn and SQL Server 2012. In-Memory OLTP is fully integrated with AlwaysOn and also with AlwaysOn Availability Group. During my test with AlwaysOn Availability Group under SQL Server 2014 CTP2, I discovered that a Readable Secondary Replica was not able to access In-Memory OLTP objects. I have a Readable Secondary Replica named pc1 with a database…

Read More
Stéphane Haby

SQL Server 2014: Rebuilding Clustered Columnstore Indexes

By | Database management | One Comment

I was surprised that you have to rebuild indexes that are stored In Memory. My previous posting “SQL Server 2014 – New Features: xVelocity memory optimized columnstore index” explains all processes connected with columnstore indexes. In this article, I will explain why, when, and how to rebuild them. Why do we need to rebuild the Clustered Columnstore Indexes? When a row is deleted, SQL Server marks the row as logically deleted. Physically, the row is…

Read More
Stéphane Haby

With Power Query, converting an internet table to Excel is an easy job!

By | Application integration & Middleware | No Comments

While exploring SQL Server 2014, I was surprised by the powerful Power Query feature. In the recent past, converting an internet table to Excel was a nasty work leading to format problems, implicit conversions, etc. With Power Query, importing tables from the internet is very easy! What is Power Query? Power Query is a tool based on the concept of Power BI (more on this tool here). Power BI is composed of: PowerPivot The first…

Read More
Stéphane Haby

SQL Server 2014 – New Features: xVelocity memory optimized columnstore index

By | Application integration & Middleware | No Comments

Some customers or colleagues recently asked me about the SQL Server concept xVelocity and in particular the SQL Server 2014 feature new xVelocity memory optimized columnstore index. So I decided to write a few words on the dbi services blog. What is xVelocity? Introduced in SQL Server 2012, xVelocity is composed of two features:  xVelocity in-memory analytics engine  xVelocity memory-optimized columnstore index xVelocity in-memory analytics engine The xVelocity in-memory analytics engine is an update of…

Read More
Nathan Courtine

SQL Server 2014: An overview of the New Features

By | Database management | One Comment

The Microsoft Techdays 2013 took place on 12-13 November at the Congress Center in Basel and on 18-19 November at the Beaulieu Congress Center in Lausanne. With more than 400 participants in Lausanne and around 1’000 participants in Basel, the largest technology event Microsoft in Switzerland was a great success. You can follow all the presentations from Lausanne or Basel. In this blog, I will summarize the presentation of SQL Server 2014: les nouveautés by…

Read More
Stéphane Savorgnano

SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures

By | Technology Survey | No Comments

One of the best new functionalities of Microsoft SQL Server 2014 is the In-Memory part, which gives you the possibility to load tables and also Stored Procedures in-memory for a very fast response time. The Community Technology Preview 2 from Microsoft SQL Server 2014 went out some days ago with two new Advisors. These Advisors will help you manage the transformation of your disk tables to Memory Optimized Tables as well as your Stored Procedures…

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…

Read More
Stéphane Savorgnano

Microsoft TechEd Madrid: Windows Server 2012 R2, High Availability, SQL Server Data Tools

By | Technology Survey | No Comments

Let’s talk about my third day at TechEd 2013. I started with a session about: Windows Server 2012 R2 and High Availability The goal of High Availability is to deal with possible points of failure in your infrastructure. There are multiple ways to manage HA on the market: Server Server redundancy deployments Run server inside a clustered VM Backup Monitor via a SCOM Management Pack Database SQL Server 2012 AlwaysOn Mirroring, Replication, Backup Run SQL…

Read More