MAMP is a “one-click solution for setting up your personal webserver”. If you don’t have hosting or a domain name sorted out, you can go ahead and build your WordPress website using this free bit of kit.
What is this blog about?
Hello and welcome to my tech blog, which is a place for me to store all my notes as I blog away as a software enthusiast.
My area of interest, or niche, very much revolves around Database Administration, so there will be a lot of RDMS related blog posts here, particularly on SQL Server. I spend a lot of time testing random features during my journey as a Database Administrator (DBA). This tech blog is a good place to store notes for personal reference. I do try my best to keep things accurate and informative for those landing on my pages via Google search too though.
If you want to know more about who’s writing this have a look at my about me page here.
I hope you find some of my posts useful and feel free to get in-touch. If anything I say is inaccurate or if you’d like to offer some general feedback please go ahead, I’d really appreciate it.
Certificates & Encryption CSV Files Database Admin Database Backups Data Types Deleting Data Error Messages Exporting Data Featured Git Importing Data Installing SQL Server Linked Servers Linux Admin Logging & Monitoring Measuring Databases Restoring Databases SQL Server Agent SQL Server ETL SQL Server Management Studio SQL Server Processes SQL Server Scripts Windows Admin WordPress Technical Issues WordPress Tutorials WSL
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…
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.
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.