SQLAssAS (11/18/2016)

---

So last night we had a failover on our availability group but it didnt fully fail over..

I am not sure why this happened but we are currently looking into...

If this is a copy & paste, could it just be that typo?

Thanks for the link. I have full access to our Azure subscriptions so I'm hoping to set up a VM in one of them and get something going there. I...

I'm keen to keep my skills up to date as much as possible and try not to be a refusenik who ends up getting left behind, so I'm going to...

Well, I wasn't sure either but I recently spoke to somebody...

Wow, ok.

I assumed it just creates an object if it doesn't already exist and alters it if it does.

It's in the link there.

CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR ALTER support makes it easier to modify and deploy objects like Stored Procedures, Triggers,...

Based on this recording https://channel9.msdn.com/Events/Connect/2016/136, I think it may be possible to use Distributed AGs to migrate from Windows to Linux, too.

I haven't managed to set up a test environment for myself yet (I might try to do it in Azure), but some use cases that interest me are;

- you can...

Before you do that, be sure that you don't need point-in-time recovery for that database. (Ultimately the DBA will...

--Warning Food discussion starting--

One of my favorite ways to enjoy gorgonzola is to add it to a sauce pan with about the same amount of heavy cream. Then season with...

Oh, wow!

Did you specify WITH KEEP_REPLICATION when you did the restore?

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b2ee9679-50a6-45b6-a632-6fec933df467/rowguid-column-not-restoring-for-merge-replicated-db?forum=sqlreplication

I haven't taken the exam,...

I think you need to speak to Microsoft to be completely sure of where you stand.