Find the PoserShell script:
-
-
And I will be speaking about Cognitive Services and give a demo on Text Analytics. Register now at http://kmug-july2018.eventbrite.com. Here goes the quick social media flyer designed by me for the announcement
-
This script will create an SQL Server Agent job, which will take daily database backup to a folder with date appended in the filename.
-
You can change the Analysis Services mode from Multidimensional Mode to Tabular Mode or vice versa easily by following below steps. I did this on SQL Server Analysis Services 2016 version. Step 1: Edit msmdsrv.ini file Go to folder X:\Program Files\Microsoft SQL Server\MSAS13.MSSQLSERVER\OLAP\Config Change X: with your correct installation drive. Open file msmdsrv.ini in notepad It is recommended to take a backup first. There is a chance this folder require additional permission to edit so I would suggest you to open the file “as Administrator” Find the tag <DeploymentMode>0</DeploymentMode> If your current mode is Multidimensional then the DeploymentMode value will be 0 or…