SQL DBA Blog

Tag: Database Admin

Add a Filegroup to a Database in SQL Server

September 1, 2022

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. Adding filegroups to a SQL Server database can improve performance by distributing data across multiple disk drives…
Read More
Disabling Change Data Capture in SQL Server

August 30, 2022

This post contains a demo on how to disable CDC (Change Data Capture) in SQL Server 2022. The sp_cdc_disable_table and sp_cdc_disable_db in-built MSSQL SPs are what we should use to disable CDC in SQL Server which is explained more below. The sp_cdc_disable_table and sp_cdc_disable_db are the in-built MSSQL…
Read More
How to Enable CDC in SQL Server

August 29, 2022

This is a post on how to enable Change Data Capture (CDC) in SQL Server. Enabling this on a database and table will allow the recording of activity when tables and rows have been modified. This is a feature available for us to configure within SQL Server and…
Read More
SQL Server Default Port

August 26, 2022

The default port for the SQL Server Engine is 1433, which is a key thing to know if you’re working as a Database Administrator (DBA), especially when managing network configurations or troubleshooting connectivity issues. In my experience, SQL Server runs on port 1433 about 95% of the time.…
Read More
Connecting to SQL Server on Another Domain

August 25, 2022

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. The regular Windows SQL Server User connects & runs their queries via SQL Server Management Studio (SSMS). If you’re in a corporate environment,…
Read More
How to Rename a Computer that Hosts SQL Server

August 23, 2022

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 connectivity. This guide provides a clear, step-by-step approach to updating SQL Server metadata after a hostname change. This is more often…
Read More
Get Database Sizes in SQL Server

August 20, 2022

Knowing how much disk space your databases are consuming in SQL Server is an important thing to know and monitor as a Database Administrator. As well as this, we should be looking at future growth of database files, ensuring we have enough disk space for years to come.…
Read More
How to Backup a SQL Server Database

August 19, 2022

This guide provides a simple demo on how to back up a SQL Server database and explains three main types of backups in MS SQL: > SQL Server Full Backup > SQL Server Transaction Log Backup > SQL Server Differential Backup > Additional Notes on SQL Server Backups…
Read More
Get Estimated Database Backup/Restore Example

August 18, 2022

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 left to go – We have one 5GB database here currently being backed up at the time…
Read More
Get Last Backup Times for all Databases in SQL Server

August 17, 2022

Ensuring your databases are regularly backed up is critical for data recovery in case of corruption, accidental deletions, or other failures. If you don’t have a backup, recovering lost data may be impossible. As a Database Administrator, it’s your number one Priority along-side ensuring your SQL Service is…
Read More

Recent Posts

Why Is the Database in “In Recovery” Mode?January 26, 2025
How to View the Definition of a Stored ProcedureJanuary 25, 2025
SQL Script to Show Exclusive Locks on TablesJanuary 23, 2025
How to Get SQL Server’s IP AddressJanuary 15, 2025
Identify Missing & Unused Indexes in SQL ServerDecember 19, 2024

Categories

– AWS
– DBA Stories
– Linux
– MySQL
– Other
– Postgres
– PowerShell
– Redshift
– SQL Server
– Windows Server

Tags