Viewing 15 posts - 16 through 30 (of 82 total)
Just wanted to report back - although I get a SQL Server 2016 edition downgrade warning (treats it as a downgrade as i am going from Dev which allows all...
May 22, 2018 at 6:29 am
Beatrix - thanks for testing, and for finding the bug, really appreciate it 🙂
Sue - thanks for the suggestion, i have seen some great examples with ExecuteSql() and...
May 17, 2018 at 8:11 am
OK - well i've discovered there is a much easier way to install the SMO objects without having to use NuGet! You install it from the PS Gallery! In PS,...
May 11, 2018 at 4:51 am
SQLPirate - I'm so confused - where am i running these commands from? PowerShell ise?? I have downloaded and installed (i think) Nuget.exe (from here: https://www.nuget.org/downloads)
What does that actually...
May 10, 2018 at 8:47 am
As others have said before R Services is a service and a series of set up steps on a server and SQL instance. Are you wondering how you can backup...
May 9, 2018 at 9:58 am
Adding a slightly different spin on the debate:
What about the fact that we have to work 5 days a week (or more), 8 hours a day (or more) doing...
May 4, 2018 at 9:07 am
Thanks Alex, the script is awesome 🙂
Cheers!
May 4, 2018 at 4:11 am
Useful forum post discussing the differences between Basic Integration (Standard Edition) and Advanced Integration (Enteprise Edition) for Microsoft R Services (In-Database)
https://stackoverflow.com/questions/41062767/editions-and-supported-features-for-sql-server-2016
May 3, 2018 at 10:06 am
I'm confused. When you follow the first document link - to add the SSISDB to the AlwaysOn availability group, what does that look like? Can you see SSISDB listed in...
April 26, 2018 at 9:39 am
Thanks... does that mean you need to go through two processes, first this one:
and this then this one:
https://blogs.msdn.microsoft.com/mattm/2012/03/23/ssis-catalog-backup-and-restore/
??
April 26, 2018 at 4:49 am
Thanks for responding Sue... doesn't feel simple though. I can't just download the SMO package - i know need some sort of nuget client to help me install the package,...
April 20, 2018 at 4:16 am
Are any of the AGs auto failover? if so you would want the same instance name wouldn't you? Else there would be a configuration issue of having to update the...
April 11, 2018 at 5:07 am
Thanks Sue. The CMS server was correct. Not really sure what that error meant but I managed to get around this by calling the script using powershell.exe, using the following...
March 27, 2018 at 10:03 am
That's awesome! And so simple... sometimes the simple things are so elusive 🙂
Thanks for your quick response!
March 21, 2018 at 10:19 am
I am using the latest version (4.0) but when running the job i am getting this:
March 15, 2018 at 4:02 am
Viewing 15 posts - 16 through 30 (of 82 total)