Infrastructure at your Service

Tag

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

Microsoft Team

SQL Server 2016 : availability groups and automatic failover enhancements

By | Hardware & Storage | 3 Comments

Let’s continue with this study of the new availability group enhancements. Others studies are available here: New database issue level detection for automatic failover Potential features in standard edition This time we’ll talk about the possibility to enrol a third replica for automatic failover. It implies of course to configure synchronous replication between the 2 pairs of replicas and this is at the cost of degrading the overall performance. But it seems that in this…

Read More
Stéphane Haby

SQL Server 2016: native support for JSON

By | Technology Survey | No Comments

A lot of discussions and most important, a feature requests in the Microsoft connect site here with more than 1000 votes is the origin of this new feature in SQL Server 2016. A lot of NoSQL have already this function and PostgreSQL for example have the json_extract_path_text functionality and you can at every time ask my colleague Daniel Westermann one of our expert in PostgreSQL of this subject. First, Json is represented by a NVARCHAR for…

Read More
Nathan Courtine

SQL Server 2016 CTP2: Stretch database feature – Part 1

By | Database management | No Comments

SQL Server 2016 CTP 2 has introduced some interesting new features such as Always Encrypted, Stretch database, the configuration of the tempdb in the SQL Server installation, aso… Regarding the configuration of the tempdb in SQL Server 2016 CTP 2, I recommend you a good article called SQL Server 2016 CTP2 : first thoughts about tempdb database from David Barbarin. In this article, I will focus on the Stretch database feature! What is the Stretch…

Read More
Microsoft Team

SQL Server 2016 : availability groups and the new potential support for standard edition

By | Hardware & Storage | No Comments

In my first blog about availability groups with SQL Server 2016, I talked quickly about the new interesting option: DB_FAILOVER. In this blog post, I will continue by introducing the new potential support of availability groups in a standard edition (based on the last Microsoft Ignit news). Yes, this sounds a great news because it will increase the scope of possible customers but bear in mind that it concerns potentially the standard edition (not in…

Read More
Microsoft Team

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

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

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

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

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