Killing SQL Server Processes (SPIDs)
There are many reasons why you’d KILL a SPID in SQL Server. Whether it’s impending disk space doom due to data or log file bloat, or a long running query that’s lost in space…
Tech Blog – Home
Renaming a computer that hosts SQL Server
When changing the hostname of a computer running SQL Server, system metadata must be updated so that remote connections and applications do not lose connectivity.
Installing SQL Server 2017
Installing SQL is a straight-forward task… but it’s important that things are in-place from the get-go to prevent having to make changes on a live system.
SiteOrigin Custom CSS Load Delay
I’ve used SiteOrigin CSS WordPress Plug-in quite a bit now, although there’s one note-able issue that I feel is worth blogging about. This SiteOrigin Plug-in lets you click on an area of your page and customise a ton of options without you typing a single line of code.
Get Estimated Database Restore Time
If you’re backing up or restoring a large database, you can run the script below to find out how long it has left to complete.
