02/27/2018
by Marlon Ribunal
Comments Off on Productivity For The Data Pro
Productivity is hard to measure when your work has no definite structure like a typical office job. You may operate within the traditional 9-5 office job but the nature of working around databases requires flexibility; and, the focus is shifting … Continue reading
02/20/2018
by Marlon Ribunal
Comments Off on Killing A Service Broker SPID
Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations where a SPID that is spawned by the Service Broker stays alive even after the queue is stuck in limbo. … Continue reading
02/13/2018
by Marlon Ribunal
Comments Off on Database Maintenance Without Breaking The Bank
Database maintenance does not have to be expensive. There are free tools out there that will make your life easier. Of course, commercial DBA tools are worth their price – they are paid for a reason. Software like SolarWinds Database Performance … Continue reading
