Database Admin
Database Admin Blog Archives: Includes practical guides, troubleshooting strategies, and best practices, written by an experienced Microsoft SQL Server DBA.
-
Keeping SQL Server and Critical Systems Up to Date
Applying the latest patches to SQL Server, Windows OS, and underlying hardware is a vital part of maintaining secure, high-performing systems. For many…
-
Add a Filegroup to a Database in SQL Server
This post contains a demo on how to add a new Filegroup for a database in SQL Server. Most databases work well with single data/log files and do not need this.
-
Connecting to SQL Server on Another Domain
This post contains a guide on how to connect to SQL Server with Windows Authentication, but using a different Domain User other than your own.
-
How to Rename a Computer that Hosts SQL Server
When changing the hostname of a computer that is running SQL Server, we have to update system metadata so that remote connections and applications do not lose…
-
Get Estimated Database Backup/Restore Example
When you're waiting on a database backup or restore to complete in SQL Server, we can run the script below to get an estimated time of how long the backup has…
-
Drop Table if Exists in SQL Server
The DROP TABLE command in SQL Server is used to remove a table from the database permanently. However, attempting to drop a non-existent table can result in…
-
Creating a Linked Server with a MySQL Database
This is my third Linked Server demo post, and this time, we’re connecting to a MySQL database.
-
Test If a Port Is Open with PowerShell (Test-NetConnection)
Test-NetConnection -ComputerName server -Port 1433 checks a TCP port from PowerShell. How to read TcpTestSucceeded, get a plain True or False for scripts, test several ports, and what to use on old Windows.
-
How to Apply Force Encryption in SQL Server
If you’re planning to allow external connections to a SQL Server, one of the first security measures to implement is encryption, both at rest and in transit.