SSMS Maximum Characters Displayed
By default, the max number of characters displayed in a single column of a query in SSMS when outputting as text is 256 characters.
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.
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.