BE SHARING

Microsoft Team

SQL Server 2014: sys.dm_exec_query_profiles, a new promising feature

13.06.2014 by Microsoft Team

Among the hidden features provided by SQL Server 2014 there is a very interesting dynamic management view named sys.dm_exec_query_profiles. This feature will help the database administrators and experienced developers to troubleshoot long running queries in real-time. I’m pretty sure(…)

Hardware & Storage

SQL Server 2014: Availability groups failover impossible with Failover Cluster Manager

06.06.2014 by Microsoft Team

A couple of weeks ago, I worked for a customer that wanted to implement SQL Server 2012 (and not SQL Server 214) AlwaysOn with availability groups. During our tests we performed a bunch of failover tests and the customer(…)

Application integration & Middleware

Tempdb enhancements with SQL Server 2014

25.05.2014 by Microsoft Team

SQL Server 2014 is definitively designed for performance and I will try to demonstrate it during this blog post. I like to talk about hidden performance features because generally it does not require any changes for applications unlike in-memory(…)

Application integration & Middleware

SQL Server 2014 : New incremental statistics

21.05.2014 by Microsoft Team

Do you use partitioning with SQL Server? If yes this post is for you because there are good news about partitioning with SQL Server 2014. I remember an old job with a healthcare customer who we decided to implement(…)

Application integration & Middleware

SQL Server 2014: SELECT INTO operators can run in parallel

06.05.2014 by Microsoft Team

A couple of weeks ago, I had to provide some best practices in term of architecture for a “heavy writes” environment that consists in importing data from different sources into SQL Server tables. At the customer place, I was(…)

Database management

SQL Server 2014: In-Memory tables, Bw-Tree, and storage

17.04.2014 by Microsoft Team

SQL Server 2014 introduces hash indexes with in-memory optimized tables. I described some of their aspects in a previous blog post. These indexes are very efficient with lookup search operations but have some limitations with operations(…)

Database management

Transparent data encryption, key management and backup strategies

26.03.2014 by Microsoft Team

Transparent Data Encryption requires the creation of a database key encryption. The database key is a part of the hierarchy of SQL Server encryption tree with at the top of the tree the DPAPI. Then if we traverse the(…)

Database management

SQL Server 2014: Buffer pool extension – an interesting new feature

20.03.2014 by Microsoft Team

Buffer pool extension (aka BPE) is an interesting feature of SQL Server 2014. Database administrators already know that memory is one of the key assets available for SQL Server. This is especially true for buffer pool memory, which plays(…)

Database management

SQL Server 2014: Deleting files of a hekaton table

06.03.2014 by Microsoft Team

A recurrent question I have often heard about Hekaton objects is the following: Is an accidental deletion of the compilation files of a hekaton table on the file system irreversible and could this compromise the execution of SQL Server?(…)

Database management

SQL Server 2014 : SELECT ALL USERS SECURABLES & DB admins

26.02.2014 by Microsoft Team

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(…)