SQL DBA Blog

Author: Peter Whyte

  • Git Log Author Command Example

    If you’re a Git user, you’ll be familiar with the git log command, which allows you to view the commit history for a repository. This blog post is to share an extra tip while using the command, utilising the –author parameter which allows you to filter the commits…

    Read More

  • Git Log Command Examples

    Git log is an essential command when working with git version control. It allows you to see the history of a repository, including details about each commit like the author, date, and commit message. It lets you know what’s changed, when it changed and by who. In this…

    Read More

  • How to Install PowerShell on Ubuntu 20.04

    This post is a guide on installing PowerShell on Ubuntu 20.04. The Ubuntu Linux distribution being used in this demo is running as a Windows Subsystem for Linux (WSL) instance. I have not yet encountered issues with the PowerShell, Ubuntu and WSL cocktail. Be sure to check out…

    Read More

  • How to Check Your SQL Server Version

    This post contains various ways for how to check the running Microsoft SQL Server version numbers, including: – Check SQL Version in SSMS Object Explorer – SQL Query to get SQL Version Info – Check SQL Server Log Files– Run the SQL Server Feature Discovery Report Why Check…

    Read More

  • How to Silently Install SSMS

    This is a note on how to silently install SQL Server Management Studio (SSMS) via command (PowerShell). SSMS is a tool most people use when working with SQL Server. If you need to install SSMS on multiple computers, you may want to use the silent installation feature for…

    Read More

  • 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. We can amend our query outputs in SSMS to Results to Text, rather than the default grid layout. This can be done by clicking…

    Read More

  • 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. This post covers the following:> PowerShell: Delete a File> PowerShell: Delete a Folder> PowerShell: Delete Files in Subfolders Recursively PowerShell:…

    Read More

  • Adding Columns to Tables in SQL Server

    As a SQL Server DBA, adding new columns to tables is a routine task, often driven by evolving business requirements or application enhancements. However, when working with larger tables, replication and/or default values, special care is required to manage potential performance impacts and maintain system stability. Before proceeding…

    Read More

  • 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 your computer. We have to ensure that we run PowerShell as Administrator for this to work. The above is creating a new firewall rule so inbound SQL Server…

    Read More

  • How to Show Line Numbers in SSMS

    This post contains a quick guide on how to show line numbers in the SSMS query window. Useful if you want to see line numbers while you code. As well as general preference, enabling line numbers in SQL Server Management Studio is particularly useful when debugging an error…

    Read More

Recent Posts

Categories

– AWS
– DBA Stories
– Linux
– MySQL
– Other
– Postgres
– PowerShell
– Redshift
– SQL Server
– Windows Server

Tags

Always On Availability Groups (AAG) (3) Certificates & Encryption (3) Change Data Capture (CDC) (2) Database Admin (74) Database Backups & Recovery (13) Database Mirroring (2) Deleting Data (1) Error Messages (4) Git Commands (5) Importing & Exporting Data (2) Linked Servers (3) Linux Admin (2) Logging & Monitoring (1) Measuring Databases (10) Microsoft Patching (2) PowerShell Scripts (1) SQL Server Agent (4) SQL Server Database Files (1) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (14) SQL Server Network Connectivity (3) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance (5) SQL Server Permissions (2) SQL Server Processes (5) SQL Server Replication (2) SQL Server Scripts (13) Windows Admin (21) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (19)