chrisn-585491 (3/31/2016)

---

As do I, since not all clients understand or enable PS or any other advance scripting technology.

I'm so conflicted...

GilaMonster (3/31/2016)

---

There shouldn't be any change in memory usage. The pages database pages are still the same size, encrypted on disk, decrypted in memory.

The big thing is backup compression. Since...

I just wrote a script in PS that iterates through my databases on server X and gives me a lovely csv file of all the permissions on all the objects...

Jeff Moden (3/30/2016)

---

Manic Star (3/30/2016)

---

Powershell is awesome! Then i'm a former developer, so it was like the power of .net without the annoying user interface layer to program. It just...

Powershell is awesome! Then i'm a former developer, so it was like the power of .net without the annoying user interface layer to program. It just does what i tell...

murrayb3024 50692 (3/29/2016)

---

The plan was to not use the same names. Was thinking of trying Listner or availablity groups to try to accomplish this. Would that be possible?...

Cnames might work. Instance names are staying the same from old to new?

This might be a starting point for you:

https://gallery.technet.microsoft.com/scriptcenter/SQL-Server-Auto-Restore-08d8c77f

The other option might be ssis, but Powershell would be easier.

You could possibly use a foreach loop container to point at the place where...

How are you with Powershell? A script could do this pretty easily.

Yes, all the cubes, along with the SSRS stuff and now SSIS stuff.

We moved most of our SSIS packages over to our BI server mainly because we are running on AG's now and it makes managing the jobs a bit easier.

Ozone

Luis Cazares (3/24/2016)

---

Freeloader

Landmine