Updating instances Sexy chat with mom

by  |  31-May-2019 11:42

See how to pin your view to a dashboard, share links, and to save and share customized views.

We are happy to announce a price reduction of an average of 35% for Linux App Service on the Premium v2 plan (pricing may vary by regional meters).

In the interim, Paul Herber has a shape substitute utility. I don't know if it will change on all pages since I only had one page at the time however I cannot think of any reason why it shouldn't. When a shape is copied from a stencil to a drawing, a copy of the shape is placed in the local stencil.

It’s insane to think they have over 550 commands now!

So, on this momentous day of releasing dbatools version 1.0 I am releasing blog post 1, I have contributed to dbatools a little over the last 12 months or so and I literally use it every day as a DBA so I figured the least I could do right now, is share some of the ways I use dbatools, so in this post we will talk about how I update SQL Server using dbatools command Update-Dba Instance.

I can call the CSI_ITEM_INSTANCE_PUB.update_item_instance API. The problem with this is that the API has a rollback statement in its code and the trigger wouldn't allow it. I can make the trigger on OE_ORDER_HEADERS_ALL an AUTONOMOUS_TRANSACTION and get away with the rollback restriction.

This will let me do a commit/rollback etc inside the trigger. The other option is to update EXTERNAL_REFERENCE in the CSI_ITEM_INSTANCE table directly.

This price reduction makes the decision point between hosting on a Standard App Service plan or a Premium v2 App Service plan a much simpler one.

Community Discussion