Tag Archives for " SQL 2016 "

Aug 09

AlwaysOn – Create a Basic Availability Group

By Ginger Keys | 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
Jan 12

SQL 2016 SP1 USE HINT

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

Consistency Check an Analysis Services Database

By Lori Brown | Analysis Services , SQL Administration , SQL Server , Upgrade

— By Lori Brown @SQLSupahStah I am migrating a client to SQL 2016 and had to restore the SSAS databases and do what amounts to a DBCC CHECKDB against it. The command is done while connected to SSAS in Management Studio. You open an XMLA query (not MDX)… …and run the following: <DBCC xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine“> <Object> […]

Continue reading
1 2 3
>