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.
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.
This post is a guide on how to check your PowerShell version on a Windows computer. I’m using $PSVersionTable to get this info.
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.
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 post is useful if you need to run PowerShell Scripts automatically with a set schedule in Windows. In the demos below, we’re creating new Scheduled Tasks via GUI and with PowerShell.
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.
In this post, we’ll walk through a script that restarts services on multiple remote hosts using PowerShell. A single PowerShell command will be run on several computers at the same time.
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.
Looping is a fundamental concept in PowerShell, and in programming in general. It’s needed for various situations where we need to work with one object at a time within an array/collection of objects.
This post is a guide on how to check what service is running for a TCP or UDP port on a Windows host computer.
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.
This post contains a demo on how to backup a SQL Server Database and includes some information on the types of backups available in MS SQL.
This post contains a SQL script to get estimated completion times and process information for your currently running database backups &
This is a post on how to get the last backup dates and times for all databases on a SQL Server Instance.