Peter Whyte

Category: Microsoft SQL Server

Microsoft SQL Server Blog which includes troubleshooting, performance tuning, and database administration guides from an experienced SQL DBA, Peter Whyte.

Drop Table if Exists in SQL Server

July 26, 2022

The DROP TABLE command in SQL Server is used to remove a table from the database permanently. However, attempting to drop a non-existent table can result in…
Read More
Why Use WHERE 1=2 in SQL

May 5, 2022

In a previous blog post, I explained why WHERE 1=1 is often used in SQL queries. This time, let’s discuss WHERE 1=2 — or any condition that results in a FALSE…
Read More
SQL Server: Searching for a String (Text) in All Tables

November 30, 2020

When working with SQL Server, you might need to find where a specific string exists in a database. This is especially useful when working with large or…
Read More
Show Only the Domain of an Email Address in SQL Server

November 27, 2020

When working with email data in SQL Server, you may often need to show only the domain of an email address. Extracting email domains is useful for analyzing…
Read More
Disk Usage by Top Tables Report in SQL Server

October 4, 2020

The Disk Usage by Top Tables Report in SQL Server is a quick way to get the sizes of all tables within a database. It’ll show all tables largest to smallest…
Read More
Creating a Linked Server with a MySQL Database

July 15, 2020

This is my third Linked Server demo post, and this time, we’re connecting to a MySQL database.
Read More
Check & Restart SQL Server Services on Linux

July 14, 2020

As of the 2017 Edition of SQL Server we have been able to install SQL Server on Linux. Linux will likely be more of an unfamiliar environment for traditional…
Read More
How to Apply Force Encryption in SQL Server

May 6, 2020

If you’re planning to allow external connections to a SQL Server, one of the first security measures to implement is encryption, both at rest and in transit.
Read More
Include Execution Trace Messages in SQL Server Error Logs

May 5, 2020

Execution trace messages in SQL Server Agent error logs can be helpful for diagnosing issues. This guide explains how to enable this option.
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