SQL DBA Blog

Author: Peter Whyte

Get Last Database Restore Date and Time in SQL Server

July 23, 2022

This guide provides a script to retrieve the last restore date and time for each database in SQL Server. It’s particularly helpful for tracking restore operations or verifying backups during disaster recovery scenarios. The script below queries the sys.databases and dbo.restorehistory system tables to get the most recent…
Read More
List All SQL Agent Jobs in SQL Server

July 21, 2022

This post provides a SQL script to list all SQL Server Agent Jobs on a Microsoft SQL Server instance. The sysjobs and sysjobsteps tables we are querying are in the M-S-D-B database. Fun fact, I am unable to publish a post with this actual database name without seeing…
Read More
How to Check WSL Distro Versions

July 20, 2022

This is a quick post on how to check your Windows Subsystem for Linux (WSL) distribution versions, with added info on what being on a different WSL version means. To check your WSL version we can simply run wsl -l -v in our PowerShell terminal window. This will…
Read More
How to Restore a Database in SQL Server

July 19, 2022

Restoring a database in SQL Server is an essential task for any Database Administrator. Whether it’s part of a disaster recovery plan, setting up a test environment, or moving data between servers, you’ll likely restore databases countless times in your career. You can restore databases through the SQL…
Read More
How To Install Windows Subsystem for Linux (WSL)

July 18, 2022

To install WSL (Windows Subsystem for Linux), we first enable the WSL Windows Feature using PowerShell, then install WSL Linux Distributions via the Microsoft Store. This post will help guide you through enabling and installing Windows Subsystem for Linux (WSL) on your local Windows computer. WSL allows Windows…
Read More
Git Log Oneline Command Examples

July 7, 2022

To check our commit history on a Repository within Git, we use the git log command. When using this command we scroll through the commit log within our Terminal by hitting the Enter key, and then we need to hit q on our keyboard to exit reading the…
Read More
What’s New in the SQL Server 2022 Install

May 29, 2022

SQL Server 2022 was officially unveiled at Microsoft Build 2022, an annual event aimed at software developers passionate about Microsoft technologies. The conference, which focuses on Microsoft Azure updates and other key tools, is a fantastic opportunity for professionals to stay informed, learn, and network. It includes a…
Read More
How To Change From WSL2 to WSL1

May 8, 2022

This is a post on how to change a Windows Subsystem for Linux (WSL) Distribution from running on Version 2 to Version 1. Windows Subsystem for Linux (WSL) supports two versions:> WSL2: The latest version with full Linux kernel support, offering better compatibility and performance. > WSL1: The…
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 value, such as WHERE 1=9. Essentially, the point is to use a condition that is guaranteed to…
Read More
How to Install Postgres on Ubuntu 20.04

May 2, 2022

This post is a short note on how to install Postgres on Ubuntu 20.04. I’m doing this in WSL, however this shouldn’t make any difference if you’re on the same Ubuntu version. First, lets update our local packages by running the following apt command – This Postgres installation…
Read More

Recent Posts

Granting the VIEW SERVER STATE Permission in SQL ServerJanuary 28, 2025
Why Is the Database in “In Recovery” Mode?January 26, 2025
How to View the Definition of a Stored ProcedureJanuary 25, 2025
SQL Script to Show Exclusive Locks on TablesJanuary 23, 2025
How to Get SQL Server’s IP AddressJanuary 15, 2025

Categories

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

Tags