By Jeffry Schwartz | Function , SQL 2016 , SQL Development , SQL Server
Overview In short, no. However, for many years there was no alternative to the T-SQL option, and even when there were other viable options, it was unclear whether it was worth changing existing code to take advantage of the new technologies. With the addition of the string_split function in SQL Server 2016, it is worth […]
Continue readingBy Ginger Daniel | Always On , SQL 2016 , SQL 2017 , SQL Administration , SQL Server
AlwaysOn Basic Availability Groups (BAGs) are available with SQL Server 2016 and 2017 Standard edition. The functionality is generally the same as database mirroring (which has been deprecated). This feature replicates transactions to a database on a secondary server, and is useful for disaster recovery should something happen to the primary server. If you have […]
Continue readingBy Ginger Daniel | Encryption , SQL 2016 , SQL Administration , SQL Server
In the AlwaysOn 2016 release, there are several enhancements that have improved manageability, scalability, and availability. One of the enhancements is the ability to add encrypted databases to an AlwaysOn group. Encrypted databases were allowed in earlier versions of AlwaysOn, however they could not be accessed if there was a failover to a secondary replica […]
Continue readingBy Ginger Daniel | SQL 2016 , SQL Administration , SQL Server
–By Ginger Keys SQL Server 2016 provides some awesome new enhancements and features, especially in Enterprise Edition. One of the new features relating to AlwaysOn is Direct Seeding. Good stuff – No more time consuming backup and restore Direct Seeding allows you to initialize the databases to your secondary replica(s) without having to configure a […]
Continue readingBy Lori Brown | Expert , SQL 2016 , SQL Administration , SQL Server , Trace Flags
I came across something today that I did not know existed in AG’s, Automatic Seeding. This allows SQL to automatically create the secondary replicas for all databases in an AG. Pretty cool!! So if you set things up correctly when you set up your AG’s, you don’t have to worry about backing up databases and […]
Continue readingBy Lori Brown | Expert , SQL 2016 , SQL Development , SQL Server , SSIS Catalog
–By Lori Brown @SQLSupahStah I have a client who has a lot of SSIS packages in the SSIS catalog that we are migrating to a new server. Of course there is lots of testing going on. So the question came up about how to more easily see package runtimes and comparing to the overall average […]
Continue reading