Adding Columns to a Table in SQL Server
Adding new columns to tables in SQL Server is a common task for anyone developing or maintaining databases, usually driven by the need for new features on an application/script procedure.
How to Add a Filegroup to a Database in SQL Server
This post contains a demo on how to add a new Filegroup to a database in SQL Server. Most databases work well with single data/log files and do not need this.
Disabling Change Data Capture (CDC) in SQL Server
This post is a note on how to disable Change Data Capture (CDC) in SQL Server and follows on from yesterday’s post:
How to Enable Change Data Capture (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.
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.
How to Connect to SQL Server with Windows Authentication using a Different Domain
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.
How to Rename a Computer that Hosts SQL Server
This post contains a demo on how to rename a computer that hosts SQL Server. Changing a hostname of a running SQL Server host is most often required soon after a fresh MSSQL installation.
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.
How to Backup a SQL Server Database
This post contains a demo on how to backup a SQL Server Database and includes some information on the types of backups available in SQL Server.
How to Get Estimated Backup Restore Time in SQL Server
This post contains a script to get estimated completion times and process information for your currently running database backups & restores in SQL Server.
