Adding columns to tables in SQL Server is a fundamental task for both database developers and administrators. Whether prompted by the pursuit of application features or script enhancements, this process demands precision and careful consideration of potential complications. In this blog post, we’ll walk…
In SQL Server, Session Process IDs (SPIDs) play a crucial role in identifying and managing SQL connections. The KILL SPID command serves as a tool for terminating troublesome sessions. This article provides an overview of the KILL command and its practical applications. Exercise caution…
Restoring databases in SQL Server is a routine task and is the responsibility of Database Administrators. The nature of a DBA job often means experiencing periods of calm with sudden spikes in demand, such as needing to restore numerous databases at once, or in…
Changing the schema of a table in SQL Server is a task that might not come up often, but it’s crucial to make this change with care when it does. Whether you’re a Database Administrator or a Developer, knowing how to do this is…
When your SQL Server database starts experiencing performance issues, it’s crucial to have tools at your disposal to quickly diagnose and address the root causes. One such tool is a performance troubleshooting script that provides insights into SQL Server’s current state, including worker threads,…
Today, now more than ever we need to safeguard our data, especially when allowing external connections to a SQL Server. We need to ensure fundamental measures are in-place to guarantee data security is enforcing encryption both at rest and in transit. This guide walks…
_
Hi, my name is Peter Whyte. I’m an experienced SQL Database Administrator (DBA) & Blogger, working remotely from home in Edinburgh, Scotland.
I help maintain High Availability SQL Server database environments, troubleshoot issues, and optimize performance within my role as a Site Reliability Engineer (SRE) at GoDaddy. This blog includes a lot of information and skills required working as a SQL Server DBA.