Peter Whyte
LightNews LightNews
banner
peterwhyte.bsky.social
Peter Whyte
@peterwhyte.bsky.social
1 followers 0 following 13 posts
A SQL Server Database Administrator & Blogger:
🌐 https://peter-whyte.com
Posts Replies Media Videos
peterwhyte.bsky.social
peter-whyte.com/2022/07/how-...
How to Restore a Database in SQL Server - SQL DBA Blog
This post shares a demo of restoring a SQL Server database via command, which includes restoring from backups with multiple files.
peter-whyte.com
March 17, 2025 at 9:12 PM
peterwhyte.bsky.social
peter-whyte.com/2022/08/how-...
How to Backup a Database in SQL Server - SQL DBA Blog
This post contains a demo on how to backup a SQL Server Database and includes some information on the types of backups available in MSSQL.
peter-whyte.com
March 17, 2025 at 9:11 PM
peterwhyte.bsky.social
peter-whyte.com/2025/02/powe...
PowerShell Tail: A Familiar Approach to Log File Monitoring - SQL DBA Blog
This post introduces and demo's a custom Tail function for PowerShell that mirrors the behavior of the Linux tail command.
peter-whyte.com
March 1, 2025 at 9:21 PM
peterwhyte.bsky.social
peter-whyte.com/2025/03/ssms...
SSMS 21 (Preview Release) - SQL DBA Blog
This week I installed SQL Server Management Studio (SSMS) Version 21 for the first time, which is currently in preview release. #ssms21
peter-whyte.com
March 1, 2025 at 5:25 PM
peterwhyte.bsky.social
peter-whyte.com/2020/04/how-...
How to Enable TCP/IP Connections in SQL Server - SQL DBA Blog
In this post I'm showing how to enable TCP/IP connections for SQL Server, which can be done via command or SQL Server Configuration Manager.
peter-whyte.com
February 27, 2025 at 2:49 PM
peterwhyte.bsky.social
peter-whyte.com/2025/02/log-...
Log and Filter sp_who2 Results in SQL Server - SQL DBA Blog
Sharing a simple SQL script that logs sp_who2 results into a temporary table, allowing you to filter and sort SQL sessions for review.
peter-whyte.com
February 25, 2025 at 10:01 PM
peterwhyte.bsky.social
peter-whyte.com/2022/08/how-...
How to Check Table Sizes in SQL Server - SQL DBA Blog
Showing you how to check table sizes in SQL Server, various methods including SQL Script and via SQL Server Management Studio (SSMS).
peter-whyte.com
February 22, 2025 at 10:03 PM
peterwhyte.bsky.social
peter-whyte.com/2020/09/crea...
Create a Link Between Local Windows Files and WSL - SQL DBA Blog
Creating a link between local Windows files and WSL (Windows Subsystem for Linux) is a useful way to share files between the two environments.
peter-whyte.com
February 19, 2025 at 10:31 PM
peterwhyte.bsky.social
peter-whyte.com/2025/02/how-...
How to Open PowerShell as Administrator - SQL DBA Blog
This guide shares the various ways of how to open PowerShell as Administrator, including from Command Prompt and Task Manager.
peter-whyte.com
February 18, 2025 at 10:32 AM
peterwhyte.bsky.social
The History of SQL Server
peter-whyte.com/2025/02/the-...
The Evolution of Microsoft SQL Server - SQL DBA Blog
An experienced Microsoft SQL Server Database Administrator talking about the history of MSSQL, with links through-out for further info.
peter-whyte.com
February 16, 2025 at 9:14 PM
peterwhyte.bsky.social
Download & Install SSMS -
peter-whyte.com/2024/12/down...
Download and Install SQL Server Management Studio (SSMS) - SQL DBA Blog
Sharing how to download and install SQL Server Management Studio (SSMS) on your computer, including tips to help improve your efficiency.
peter-whyte.com
February 16, 2025 at 9:09 PM
peterwhyte.bsky.social
peter-whyte.com
Peter Whyte - SQL Server DBA Blog
A SQL DBA blog, sharing SQL scripts and tips for optimizing, securing, and maintaining highly available, reliable database systems.
peter-whyte.com
February 16, 2025 at 6:52 PM
peterwhyte.bsky.social
peterwhyte.com
Peter Whyte (SQL DBA / Blogger) - Edinburgh, Scotland
Hi, my name is Peter Whyte, a Database Reliability Engineer (DBRE) and Blogger from Edinburgh, Scotland. This is my portfolio website.
peterwhyte.com
February 16, 2025 at 4:09 PM