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.
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.
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.
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.
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.
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.
This post contains a script to get estimated completion times and process information for your currently running database backups & restores in SQL Server.