SSMS Silent Install
This is a note on how to silently install SQL Server Management Studio (SSMS) via command (PowerShell). SSMS is a tool most people use to administer SQL Server and to run SQL queries.
This is a note on how to silently install SQL Server Management Studio (SSMS) via command (PowerShell). SSMS is a tool most people use to administer SQL Server and to run SQL queries.
By default, the max number of characters displayed in a single column of a query in SSMS when outputting as text is 256 characters.
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.
Adding new columns to tables in SQL Server is a common task for anyone developing and/or maintaining databases, usually driven by the need for new features on an application/script procedure.
Create a New Firewall Rule with PowerShell This is a short post to share a PowerShell script that will create a new Windows Firewall Rule on a local computer.
This post contains a guide on how to show line numbers in the SSMS query window. Useful if you want to see line numbers while you code.
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.