How to Exclude a Category from Blog Page in WordPress
This is a guide on how to exclude a blog category from a blog page in WordPress. I hide my Web Blog posts from the Tech Blog area, so this is a useful one to note down.
Tech Blog – Home
“Content from the website listed below is being blocked.” Windows Server
If you’re on a fresh install of Windows Server and you try use Internet Explorer, you’ll no doubt be prompted with the following message for every website you try access.
Creating a Linked Server with a Postgres Database
In my previous post, I created a Link Server to another SQL Server instance This time, it’s a link to a Postgres database!
Configuring Linked Servers in SQL Server
Linked Servers in SQL Server allows you to query external databases, such as remote SQL Server instances, Oracle, ODBC or MS Access databases.
Database Growth Events in SQL Server
When a database file gets full and it needs more space, a growth event will happen. The size of said database growth can be set within the database options, or can be done using the ALTER DATABASE statement as shown below.
Setting Maximum Database File Sizes in SQL Server
Setting maximum database file sizes in SQL Server is something you’d ideally not have to set, but it’s a good last resort option available if you need it.
Updating Help Documentation in PowerShell
The Update-Help cmdlet in PowerShell will download the latest help files for PowerShell modules installed on your machine. Running PowerShell as Administrator is a requirement for this one, else you’ll get the following error.
Moving TempDB Files in SQL Server
It’s a solid best practise to have TempDB files stored in separate drive, away from your C: drive. This is because TempDB can grow very large, very quickly (within minutes);
