Author: Peter Whyte
-
How to Silently Install SSMS
This is a note on how to silently install SQL Server Management Studio (SSMS) via command (PowerShell).
-
How to Delete Files in PowerShell
This is a post on how to delete files in PowerShell, which will be useful when you need to delete files as part of a script in Windows.
-
How to Create a New Firewall Rule with PowerShell
In this bog post I’m sharing a guide on how to create a new Firewall Rule with PowerShell. We’ll create a new inbound rule using a PowerShell script for the…
-
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.
-
How to Check PowerShell Version
This guide explains how to check your PowerShell version on a Windows computer using the $PSVersionTable command.
-
How to Run PowerShell Scripts with Task Scheduler
Automating PowerShell scripts is a much needed task for Windows Administrators. The Task Scheduler provides a reliable way to execute scripts on a predefined…
-
Connecting to SQL Server on Another Domain
This post contains a guide on how to connect to SQL Server with Windows Authentication, but using a different Domain User other than your own.
-
Restart Services on Multiple Hosts using PowerShell
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. If you need to run a command on multiple remote machines, the PowerShell Invoke-Command cmdlet is a…
-
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…
Three guides collect the posts by the job you are doing rather than by date.
PowerShellFiles, CSVs, the firewall, scheduled tasks WSLInstalling it, distros, files across both worlds Windows AdministrationServers, domains, DNS, the tools worth havingThis site started as a SQL Server blog in 2017 and the archive is still here. The new SQL Server writing, and all the scripts, moved to a site of their own.
sqldba.blogScripts, error library, wait types, SSMS- CLAUDE.md: Project Memory for Claude Code
- Install Claude Code on Windows, Native and in WSL
- Claude Code Only Keeps 30 Days of Transcripts
- Claude Code Permissions: Allow and Deny Rules in settings.json
- Claude Code Hooks: Run a Check After Every Edit
- Compact a WSL or Docker Desktop vhdx to Get Disk Space Back
- AI (14)
- Linux & WSL (31)
- Microsoft SQL Server (51)
- Other (15)
- PowerShell (54)
- Windows Server Admin (40)