Infrastructure at your Service

SQL Server 2012 Archives - Page 3 of 7 - Blog dbi services

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

IT Pro TechDays 2013 in Lausanne: BYOD, SQL Server & SharePoint

By | Technology Survey | No Comments

I had the opportunity to attend the IT Pro day at the Microsoft Techdays in Lausanne. Let me give you a few insights on my day there. Being a SharePoint specialist but also ramping up on Microsoft SQL Server I tried to balance between SQL and SharePoint related sessions. BYOD As usual, the day started with a Keynote focusing on an overview of the new Windows 8.1 and Windows Server 2012 R2 features. Well… it…

Read More
Stéphane Savorgnano

SQL Server 2012 SP1: Sixth Cumulative Update (CU6) available

By | Technology Survey | No Comments

Some days ago, Microsoft published the sixth Cumulative Update (CU6) for Microsoft SQL Server 2012 Service Pack one, two months after the fifth one. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it and just have a look at it. Which issues are covered by this CU6? It is a small CU, it contains only 23 Hotfixes, mainly for the Engine and Analysis…

Read More
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 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
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

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