SSMS Maximum Characters Displayed
By default, the SQL Server Management Studio (SSMS) maximum number of characters displayed in a single column of a query, when outputting as text is 256 characters.
How to Delete Files in PowerShell
This is a post on how to delete files in PowerShell – useful for when you need to delete files as part of a script in Windows.
Adding Columns to a Table in SQL Server
Adding new columns to tables in SQL Server is a common task for anyone developing or maintaining databases, usually driven by the need for new features on an application/script procedure.
SSMS Show Line Numbers
This is a tip on how to show line numbers in the SQL Server Management Studio (SSMS) query window. Showing line numbers in SSMS is something that you may prefer to have enabled as default.
How to Add a Filegroup to a Database in SQL Server
This post contains a demo on how to add a new Filegroup to a database in SQL Server. Most databases work well with single data/log files and do not need this.
How to Check Your PowerShell Version on Windows
This post is a guide on how to check your current PowerShell version on a Windows machine. It’s important to keep all software as up-to-date as possible, we all know it.
Disabling Change Data Capture (CDC) in SQL Server
This post is a note on how to disable Change Data Capture (CDC) in SQL Server and follows on from yesterday’s post:
How to Enable Change Data Capture (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 Windows 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.
