Skip to content

Instantly share code, notes, and snippets.

View uygary's full-sized avatar
💸
That's why we have to destroy the present politico-economic system.

Uygar Yilmaz uygary

💸
That's why we have to destroy the present politico-economic system.
View GitHub Profile

Keybase proof

I hereby claim:

  • I am uygary on github.
  • I am malmoth (https://keybase.io/malmoth) on keybase.
  • I have a public key ASC8Jbw_jJyylTS5E4EYIXxFJ9S2KXINQ_5U3qxMPkFxswo

To claim this, I am signing this object:

@uygary
uygary / EnableSqlServerMessageBrokerAfterFuckup.sql
Created August 29, 2018 16:55
After a half-ass migration, we forgot to turn on service broker, and this little puppy was what we used to diagnose the prooblem and fix it.
use FooBar;
go
select sq.* from sys.service_queues as sq
select tq.* from sys.transmission_queue as tq
alter database FooBar set restricted_user with rollback immediate
alter database FooBar set enable_broker