Tag: Database Admin
Database Admin Blog Archives: Includes practical guides, troubleshooting strategies, and best practices, written by an experienced Microsoft SQL Server DBA.
-
How to Backup a SQL Server Certificate
Backing up SQL Server certificates is essential if you use them, especially for encrypted database backups that may need restoration on another server.
-
How to Check Features Installed in SQL Server
This guide explains how to check which features are installed on a SQL Server instance.
-
How to Install SQL Server on Linux
As from SQL Server 2017, we now have support for running our favorite RDMS on Linux, as well as Windows!
-
How to Run Scheduled Tasks with SQL Server Express
SQL Server Express lacks SQL Server Agent, which means scheduling tasks like index maintenance, backups, and other recurring operations requires an alternative…
-
How to Rename Schema’s in SQL Server
Changing the schema of a table in SQL Server can be a rare task for database administrators but a more common requirement for database developers. This guide walks through how to move a table from one schema to another using the ALTER SCHEMA statement. During my time as…
-
Adding & Removing SQL Features via Command
This post will guide you on how to add and remove features from SQL Server via the command line. The process includes checking installed features, installing a…
-
Install/Uninstall SQL Server via Command
Installing and uninstalling SQL Server via command line can be useful, especially in environments without a GUI.
-
Creating a Linked Server for a PostgreSQL Database
This is a post on how to create a Linked Server to a PostgreSQL database.
-
Creating a Linked Server to SQL Server
Linked Servers in SQL Server allow you to query external databases, such as remote SQL Server instances, Oracle, ODBC or MS Access databases. It provides easy…
Three guides collect the posts by the job you are doing rather than by date.
PowerShellFiles, CSVs, the firewall, scheduled tasks WSLInstalling it, distros, files across both worlds Windows AdministrationServers, domains, DNS, the tools worth havingThis site started as a SQL Server blog in 2017 and the archive is still here. The new SQL Server writing, and all the scripts, moved to a site of their own.
sqldba.blogScripts, error library, wait types, SSMS- Linux & WSL (28)
- Microsoft SQL Server (51)
- Other (13)
- PowerShell (53)
- Windows Server Admin (37)