Category Archives for "SQL 2017"

AlwaysOn – Create a Basic Availability Group

By 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 reading

Bob Ward to speak at DFW BI & Analytics Community Meeting on 12/6

By SQLRx Admin | Lunch And Learn , SQL 2017 , SQL Server

Come see Bob Ward from Microsoft speak about “Fast and Furious: SQL 2017” at the DFW BI & Analytics Community Meeting on 12/6, 11:30-1:00 at Noah’s in Irving.  You can register on the “Event” section of the ISI website at www.isi85.com . The DFW Business Intelligence and Analytics Community welcomes Bob Ward of the Microsoft […]

Continue reading

Links for new DMV’s in SQL 2017

By SQLRx Admin | Miscellaneous , SQL 2017 , SQL Server

Since we at SQLRX have been super busy this week and still need to do something for a blog post, I thought that doing a link round up of new dynamic management views that are going to be available in SQL 2017 would be a quick and good idea. I am really interested in sys.dm_db_log_info […]

Continue reading

Installing and Connecting to SQL 2017 on Ubuntu (Linux)

By Lori Brown | Installation , SQL 2017 , SQL Administration , SQL Server

SQL Server 2017 is available as a CTP for testing (https://www.microsoft.com/en-us/sql-server/sql-server-2017) and is able to be installed on a system running Linux. Because I have done all of my professional work on Windows systems, the leap to a Linux system was a bit of a stretch. I learned that while Linux is the OS kernel, […]

Continue reading

SQL 2017 Is On The Way!!

By Lori Brown | CTP , SQL 2017 , SQL Server

–By Lori Brown  @SQLSupahStah SQL Server 2017 is rolling our way like a big ole train. And, with the new features that are going to be available there may be quite a few shops that want to jump onboard. As of this writing SQL Server 2017 CTP 2.1 is available for download and testing. (https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2017-ctp/ […]

Continue reading