SQL DBA Blog

Tag: Database Admin

  • Move Temp DB SQL Server

    A common best practice for SQL Server DBA’s is to have Temp DB files stored on a separate drive, especially ensuring that it’s not on the C:\ drive and sharing with the OS. This is because Temp DB can grow very large, very quickly. The growth of Temp DB Files depends on the workload/queries happening…

    read more

  • How to Check SQL Server Version

    Checking your SQL Server versions is a common task, as most database administrators will know how important it is to keep the software on the host up to date. This post is here to help you to check the version of SQL Server instances. You may have many instances running on the same host server…

    read more

  • Add Columns to a Table in SQL Server

    Adding new columns to tables in SQL Server is a common task for anyone developing and/or maintaining databases, usually driven by the need for new features on an application/script procedure. As ever, before you get started with MSSQL changes, have a look at the relevant Microsoft Documentation – Add Columns to a Table If the…

    read more

  • 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. Database files in SQL Server generally operate with 2 files, data (.mdf) files and log (.ldf) files. If we add an additional data file,…

    read more

  • Disabling Change Data Capture in SQL Server

    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 SPs to do this which are explained…

    read more

  • How to Enable CDC in SQL Server

    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 Azure SQL out of the box. CDC…

    read more

  • SQL Server Default Port

    The default port for the SQL Server Engine is 1433, which is a useful thing to know if you’re working as a Database Administrator (DBA) or Database Reliability Engineering (DBRE) type role. Though-out my career I’ve seen SQL Server run on the default 1433 port 99% of the time. For the other 1 percent, it…

    read more

  • How to Connect to SQL Server with a Different Domain User Account

    This post is a guide on how to connect to SQL Server with Windows Authentication, but using a different Domain User rather 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, you’ll likely be logged into your computer…

    read more

  • 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 connectivity. The hostname system metadata is stored in sys.servers and reported by @@SERVERNAME. This post is a guide on how to update MS SQL metadata after a hostname change.…

    read more

  • Get All Database Sizes in SQL Server

    Measuring databases is important for knowing how much disk space a SQL Server requires today, as well as the future growth of the database files. It takes more than one run of a script to know all your disk provisioning needs. The script below in this post helps give a quick look at the database…

    read more

Recent Posts

Categories

Tags

Active Directory (AD) AWS CLI CDC Certificates & Encryption Change Data Capture CSV Files Database Admin Database Backups Data Types Deleting Data Error Messages Featured Git Git Commands Git Log Installing SQL Server Linked Servers Linux Admin Measuring Databases MSSQL SPIDs NetFirewallProfile New-Item PowerShell PowerShell Create Folder PowerShell Delete Files PowerShell ForEach PowerShell Tips PowerShell Version Restoring Databases SQL Server Agent SQL Server ETL SQL Server Management Studio (SSMS) SQL Server Processes SQL Server Scripts SQL Tips SSH SSMS Tips Temp DB Windows Admin Windows Firewall WordPress Tutorials WSL WSL1 WSL2 WSL Ubuntu WSL Version