Peter Whyte

All Posts

Everything published on this blog since 2017, newest first. The Windows, PowerShell and WSL material is the active side of the site; the SQL Server writing has moved to sqldba.blog.

If you are looking for something specific, the two guides below collect the posts by topic rather than by date:

🐧 WSL Complete Guide 📜 PowerShell Complete Guide SQL Server posts Windows

  • Exporting SQL Server Query Results to CSV

    This guide explains how to export a SQL Server query results to a CSV file using SSMS.

    Read More

  • How to Backup a SQL Server Database

    Ensuring regular backups of your SQL Server database is essential for data protection and disaster recovery. Whether you prefer using SQL commands or SQL…

    Read More

  • How to Properly Copy SQL Dates into Excel

    When copying a SQL query result directly into Excel, DATETIME columns often don’t display as expected. Excel doesn’t seem to handle milliseconds well, making…

    Read More

  • What is Stack Exchange Data Explorer (SEDE)?

    As a DBA, I’ve found Stack Exchange Data Explorer (SEDE) to be an invaluable tool for analyzing data from the Stack Exchange network. It’s essentially a web-based SQL playground, allowing you to run queries and uncover hidden insights without downloading any data. Just open the tool, write a query, and explore the results. Why I…

    Read More

  • 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.

    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 issue on your test Postgres environment. Resetting…

    Read More

  • How To Install PostgreSQL on Windows

    🛠️Part of the Windows Administration Complete Guide, every Windows administration post on this site, grouped by the job you are doing. 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…

    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…

    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…

    Read More

Start with a guide

Three guides collect the posts by the job you are doing rather than by date.

PowerShellFiles, CSVs, the firewall, scheduled tasks WSLInstalling it, distros, files across both worlds Windows AdministrationServers, domains, DNS, the tools worth having
Looking for SQL Server?

This site started as a SQL Server blog in 2017 and the archive is still here. The new SQL Server writing, and all the scripts, moved to a site of their own.

sqldba.blogScripts, error library, wait types, SSMS
Latest posts
Browse by topic