Infrastructure at your Service

SQL Server 2016 Archives - Page 9 of 9 - Blog dbi services

David Barbarin

SQL Server 2016: Live query statistics

By | Database management | No Comments

During my tests of the SQL Server 20126 CTP2, I noticed an additional icon on SQL Server Management studio which is close to the Actual Execution Plan button as shown below: I decided to take a look at the SQL Server 2016 BOL and I found a topic about this feature. It seems to be a funny feature. So after that, I decided to test it with one of my financial query (developed for one…

 
Read More
David Barbarin

SQL Server 2016 CTP2 : first thoughts about tempdb database

By | Development & Performance | No Comments

In my first blog about SQL Server 2016, I noticed during the SQL Server installation process that we are able to configure the number of files for tempdb. This is surely a great improvement but at this point, you may think that the configuration of the tempdb database is finished but in fact you’re wrong. Let me say why. First let’s have a look at the tempdb files configuration after installing SQL Server. use tempdb;…

 
Read More
David Barbarin

SQL Server 2016 CTP2 is out!

By | Technology Survey | No Comments

As announced by Satya Nadella at the Microsoft Ignite keynote in Chicago, SQL Server 2016 CTP2 is finally out and it follows a previous private CTP. This CTP will provide some interesting features to evaluate as: Always Encrypted Stretch databases Operational analytics However, this CTP does not stop here and will incorporate a myriad of new features and many improvements, such as: Polybase AlwaysOn enhancements Row level security Dynamic data masking Native JSON support Temporary…

 
Read More
David Barbarin

SQL Saturday Lisbon: from Francesinha to Bacalhau

By | Technology Survey | No Comments

The last week-end, I was at the SQL Saturday 369 that held in Lisbon. If you take a look at the agenda, you’ll probably see that there is a lot of interesting sessions with a lot of famous speakers. Unfortunately, I was not able to attend to all sessions, so I decided to focus only on those that have a direct correlation with my work. First, 2 “headache” sessions given by Paul White (aka @SQL_Kiwi)…

 
Read More
David Barbarin

SQL Server vNext becomes SQL Server 2016

By | Technology Survey | No Comments

  Satya Nadella, CEO of Microsoft has announced at the Microsoft Ignite keynote in Chicago that SQL Server 2016 public preview will come this summer and you can be sure that at dbi services we’re looking forward to take a look at under the hood and test this next major release. Amid all the good news, here those who have focus my attention:   First of all, because we’re working in Switzerland, security is a…

 
Read More