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 Administration , SQL Server
It is common knowledge that encrypting a database causes degraded performance in a SQL server. In an AlwaysOn environment performance can be even more sluggish because there is the extra element of data replication latency. How much difference does it really make? Of course the answer is “it depends” on your environment and your workload. […]
Continue readingBy SQLRx Admin | Database Mail , SQL Administration , SQL Server , Tip of the Month
If you are planning on installing SQL Server 2016, take note that you need SP1 or .NET 3.5 for Database Mail. Database Mail is a very important and widely used part of SQL that allows us to send e-mail. I found this when mail could not be sent and the Database Mail log was empty […]
Continue readingBy Ginger Daniel | Cloud , SQL Administration , SQL Server , Stretch Database
Microsoft has added another cool feature in SQL Server 2016 – Stretch databases – that provides a cost effective way to store historical or ‘cold’ data. This feature is ideal for transactional databases with large amounts of cold data, typically stored in a small number of tables. Stretching is better than the traditional method […]
Continue readingBy Lori Brown | ColumnStore , Expert , Partitions , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah I recently ran across a data warehouse that did have the largest table partitioned. We were migrating up to SQL 2016 and we wanted to make sure that the partitions were still working and in place. Since I felt I needed to refresh my table partitioning skills, I decided to […]
Continue readingBy Lori Brown | Intermediate , Performance Tuning , SQL Development , SQL Server , Trace Flags
–By Lori Brown @SQLSupahStah After installing Service Pack 1 for SQL 2016, I ran across USE HINT and thought I would put out what I could find to document it. Here’s where you find info from Microsoft: https://msdn.microsoft.com/en-us/library/ms181714.aspx and here is a link for all of the bugs that are fixed in SP1: https://support.microsoft.com/en-us/kb/3182545 USE […]
Continue readingBy Lori Brown | Intermediate , Security , SQL Administration , SQL Server , Upgrade
–By Lori Brown @SQLSupahStah I am working with a client who is migrating from SQL 2012 to SQL 2016. It just so happens that while they have just a few databases to move, they also have a ton of SQL logins that needed to be migrated. This is not an issue since I know to […]
Continue readingBy Lori Brown | SQL Administration , SQL Server
— By Lori Brown @SQLSupahStah SQL 2016 SP1 has been released. I might be a little late to this announcement but thought I would at least give the download link and some highlights on things that are fixed in it. Download it from here: https://www.microsoft.com/en-us/download/details.aspx?id=54276 Some of the highlights are: New CREATE OR ALTER that […]
Continue reading