Infrastructure at your Service

Tag

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

Microsoft Team

SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog

By | Database Administration & Monitoring | No Comments

During my investigation about the new AlwaysOn features, I wrote a blog post about the new SSISDB support for AlwaysOn. You can find it here: > SQL Server 2016 : availability groups and the new SSISDB support Just as a reminder, for those who have dealt with the SSISDB catalog in the previous version, some extra works were mandatory to be “AlwaysOn” compliant. Fortunately, the new version of SSIDB catalog will make easier the DBA…

Read More
Stéphane Savorgnano

SQL Server 2016: Upgrade Advisor

By | Database Administration & Monitoring, Technology Survey | No Comments

During the read of a blog of my colleague Nathan Courtine about Stretch database, I installed the version of SQL Server 2016 Upgrade Advisor and Oh surprise! it looks really NEW! “A new generation of advisor tool for SQL Server” aka Microsoft. To download and install it, click here. This new version has a dual role: Check the compatibility of old versions of SQL Server compared to SQL Server 2016 Help adoption of new SQL…

Read More
Stéphane Haby

SQL Server 2016: the Time Travel with temporal table – Part IV

By | Technology Survey | No Comments

Maintenance & Metadata My last chapter is about the maintenance backup/restore, index rebuild/reorg., etc. and the Metadata. I divide my article into 4 parts to be clearer and easier to read: Part I – Principle & Creation Part II – INSERT, UPDATE & DELETE commands Part III – SELECT command Part IV – Maintenance & Metadata SQL Server version/built used for this serie of articles is CTP 2.2/13.0.407.1 Backup & Restore Before my Backup, I…

Read More
Stéphane Haby

SQL Server 2016: the Time Travel with temporal table – Part III

By | Technology Survey | No Comments

SELECT command In this article, I present the last command SELECT. I divide my article into 4 parts to be clearer and easier to read: Part I – Principle & Creation Part II – INSERT, UPDATE & DELETE commands Part III – SELECT command Part IV – Maintenance & Metadata SQL Server version/built used for this serie of articles is CTP 2.2/13.0.407.1 SELECT Command In my sample, I search information of the number of African…

Read More
Stéphane Haby

SQL Server 2016: the Time Travel with temporal table – Part II

By | Technology Survey | No Comments

INSERT, UPDATE & DELETE commands After the introduction and the table creation, in this second part, I present the 3 important commands INSERT, UPDATE & DELETE. I divide my article into 4 parts to be clearer and easier to read: Part I – Principle & Creation Part II – INSERT, UPDATE & DELETE commands Part III – SELECT command Part IV – Maintenance & Metadata SQL Server version/built used for this serie of articles is…

Read More
Stéphane Haby

SQL Server 2016: the Time Travel with temporal table – Part I

By | Technology Survey | No Comments

Principle & Creation Microsoft create in SQL server 2016 a new feature temporal table, based on the latest edition of the SQL standard: SQL:2011. If you want read more about this standard, click here. I divide my article into 4 parts to be clearer and easier to read: Part I – Principle & Creation Part II – INSERT, UPDATE & DELETE commands Part III – SELECT command Part IV – Maintenance & Metadata To begin,…

Read More
Microsoft Team

SQL Server 2016 : availability groups and the new SSISDB support

By | Hardware & Storage | 11 Comments

This blog post is focused on the new supportability of SSIDB catalog on AlwaysOn architecture. Others studies are available here: New database issue level detection for automatic failover Potential features in standard edition Automatic failover enhancements New load balancing features with read-only replicas New clustered columnstore index support A couple of weeks ago, I was involved in an SSIS infrastructure project with SQL Server 2014. As you know, the SSIS architecture has fundamentally changed since…

Read More
Microsoft Team

SQL Server 2016 : availability groups and the new clustered columnstore index support

By | Hardware & Storage | 2 Comments

This blog post is focused on the new supportability of clustered columnstore index on the high- availability read-only replicas. Others studies are available here: New database issue level detection for automatic failover Potential features in standard edition Automatic failover enhancements New load balancing features with read-only replicas After reading some improvements from the columnstore index feature side, I was very surprised to see the following section:   Clustered columnstore indexes are now supported on AlwaysOn…

Read More
Microsoft Team

SQL Server 2016 : availability groups and load balancing features

By | Hardware & Storage | 8 Comments

Let’s continue with this third post about SQL Server AlwaysOn and availability groups. Others studies are available here: New database issue level detection for automatic failover Potential features in standard edition Automatic failover enhancements This time I’ll talk about read-only secondaries and the new load-balancing support that will be introduced by SQL Server 2016. First of all, SQL Server 2014 improved the read-only secondary availability by solving the issue related to secondary accessibility when the…

Read More
Nathan Courtine

SQL Server 2016 CTP2: Stretch database feature – Part 2

By | Database management | No Comments

In my previous blog SQL Server 2016 CTP2: Stretch database feature – Part 1, I explained how to prepare your instance and your database to enable the Stretch feature for your table. Now I present you how to enable the feature for your tables! Prerequisites Enabling Stretch Database at the table level requires ALTER permissions on this table.   Limitations For the moment in the SQL Server 2016 CTP2, there are several and important limitations,…

Read More