PostgreSQL vs. SQL Server Notes
This blog will be where I post my PostgreSQL administration learning and it’s comparison to SQL Server from a SQL Server DBA’s viewpoint.…
Read MoreCategory: Servers
Bulk-copy SQL Server Agent jobs to new server
The easiest way to bulk-copy all SQL Agent jobs to a new server is to follow these steps 1. Load SSMS and connect…
Read More
Removing TempDB data files from SQL Server
I had a situation where a SQL Server 2016 install did not install correctly. The install completed but when I tried to move…
Read More
Protected: Installing SQL Server on Linux
There is no excerpt because this is a protected post.
Read More
Moving system databases to a new drive
A common task for any DBA building new SQL servers is to relocate where SQL Server stores user and system databases. This post…
Read More