SQL DBA Blog

Author: Peter Whyte

  • Understanding Implicit vs. Explicit Data Conversion in SQL Server

    This post is here to help you understand implicit vs explicit data conversions in SQL Server. What is Data Conversion? Data conversion involves transforming data from one type to another. SQL Server facilitates this through two primary methods: Implicit Conversion> Occurs automatically when SQL Server can safely convert…

    Read More

  • Show Line Numbers in SQL Server Management Studio (SSMS)

    This is a quick tip on how to show line numbers in SQL Server Management Studio (SSMS) query windows. Enabling line numbers can be useful, especially when you get an error message that points to a specific line in your code. While not strictly necessary, some developers prefer…

    Read More

  • Reset Default PostgreSQL User Password

    A common scenario working with Postgres is when you have forgotten your default Postgres user password. This is the password you will have entered during your Postgres installation. This is a guide on how to reset the default Postgres user password. This should hopefully help you resolve this…

    Read More

  • How To Install PostgreSQL on Windows

    PostgreSQL is a free open-source RDMS that is widely used and forked. Other than PostgreSQL itself, Redshift is the only other forked database I’ve ever touched. This blog post is a very simple wizard run-through of installing PostgreSQL and Stack Builder on Windows for testing. # Install PostgreSQL…

    Read More

  • Show Available Disk Space in SQL Server

    This blog post is to share a script that you can run in SQL Server (versions 2008 R2 and above) which shows the available disk space for all local volumes on a SQL Server host. I’m also including a quick note on how to get this information with…

    Read More

  • Killing SQL Server Processes (SPIDs)

    In SQL Server, processes (SPIDs) can sometimes become blocked, leading to performance issues. As a Database Administrator, you may need to terminate such processes to maintain system efficiency. This guide demonstrates how to identify and kill blocking SPIDs. Contents: > Creating a Blocking SPID> Killing a Blocking SPID>…

    Read More

  • Renaming a computer that hosts SQL Server

    When renaming a computer hosting SQL Server, you need to update system metadata to maintain connectivity for remote connections and applications. This process involves updating SQL Server’s registered hostname to match the new computer name. To rename a computer that hosts SQL Server, checkout my latest post on…

    Read More

  • Installing SQL Server 2017

    Installing SQL Server is relatively straightforward, but ensuring proper configuration from the outset helps avoid issues later. This guide walks through the key steps and best practices for setting up SQL Server 2017, highlighting essential pre-installation considerations and post-installation tasks. Before starting, consult Microsoft’s official docs: Planning a…

    Read More

  • Get Estimated Database Backup/Restore Time Script

    This post contains a SQL script to get estimated completion times and process information for your currently running database backups & restores in SQL Server. Backing up a database can often take a very long time. It depends on various factors, one obvious reason being, that the bigger…

    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)