03/06/2018
by Marlon Ribunal
1 Comment
Disclaimer: I’m one of the Technical Reviewers for this book. With the rising demand for cloud computing and wide adaptation of cloud-based analytics platforms such as Data Lake Analytics and the likes, the chasm between the traditional Data Professionals and … 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