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.
Tech Blog – All Posts (Grid)
How to Check PowerShell Version
This post is a guide on how to check your PowerShell version on a Windows computer. I’m using $PSVersionTable to get this info.
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.
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.
How to Automate PowerShell Scripts with Task Scheduler
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.
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 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.
PowerShell Restart Services on Multiple Hosts
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.
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.
PowerShell ForEach Loop Tutorial
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.
How to Find Which Process is Listening on a Port in Windows
This post is a guide on how to check what service is running for a TCP or UDP port on a Windows host computer.
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 MS SQL.
Get Estimated Backup Restore Time in SQL Server
This post contains a SQL script to get estimated completion times and process information for your currently running database backups &
How to Get Last Backup Times for all Databases in SQL Server
This is a post on how to get the last backup dates and times for all databases on a SQL Server Instance.
