Category Archives for "Upgrade"

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
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 >=”http://schemas.microsoft.com/analysisservices/2003/engine“> <Object> […]

Continue reading
Jun 01

SQL Server 2016 RTM Available!!

By SQLRx Admin | Advice , Installation , Miscellaneous , SQL Server , Upgrade

In case you live under a rock or were at the dentist, Microsoft announced that SQL Server 2016 has been made generally available today June 1, 2016. See: https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/ Pricing is as follows: A handy feature comparison of previous versions of SQL can be located here: https://www.microsoft.com/en-us/server-cloud/products/sql-server/comparison.aspx SQL 2016 feature comparison between editions can be […]

Continue reading
Jun 01

SQL Server 2016 RTM Available!!

By SQLRx Admin | Advice , Installation , Miscellaneous , SQL Server , Upgrade

In case you live under a rock or were at the dentist, Microsoft announced that SQL Server 2016 has been made generally available today June 1, 2016. See: https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/ Pricing is as follows: A handy feature comparison of previous versions of SQL can be located here: https://www.microsoft.com/en-us/server-cloud/products/sql-server/comparison.aspx SQL 2016 feature comparison between editions can be […]

Continue reading
>