Microsoft will introduce four new security permissions in SQL Server 2014. One of them called SELECT ALL USERS SECURABLES is the subject of this post. As explained by Microsoft SQL Server 2014 will allow a database administrator to manage data without seeing sensitive data or personally identifiable information. We can achieve a greater compliance but we must take care what…
For my first blog post at dbi services, I think it could be a good opportunity to begin by discussing around SQL Server 2014, Hekaton memory optimized tables, and hash indexes. When you create a memory optimized table you have to consider the number of buckets that you have to reserve for its associated hash index. It’s an important aspect…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
