SQL DBA/SRE Blog
by Peter Whyte
A blog focused on Microsoft SQL Server Database Administration and Site Reliability Engineering, authored by a seasoned DBA currently working at an S&P 500 company.
For more info, check out my C.V.
Check out my DBA Blog Categories
About this blog
I first started my blogging journey in 2017, driven by the desire to have my own space for technical notes, and for showcasing my skills while helping fellow SQL Server DBA’s in the field. It took a long time of trial and error through-out the years for me to be able to learn how to create & manage websites using WordPress, and to learn how to write and format a proper blog post.
It’s been a long journey, forever learning and forever trying to achieve consistency with publishing new content regularly. With each year, life and career bring unforeseen challenges that may disrupt progress, however the ambition has always been there. My ambition is to continue to publish new content online while continuing to learn and improve every step of the way, in both DBA/SRE skills and maintaining good websites.
I hope you enjoy reading my work here and it helps improve your knowledge for managing SQL Servers, and beyond!
Key Links
Useful links to official documentation pages, or internal pages.
Latest SQL Versions
Version Requirements for SQL Server on Windows Operating System
Editions & Supported Features of SQL Server
United Kingdom
Frequently Asked Questions
(…FAQ’s I made up)
What is a DBA?
A DBA stands for Database Administrator. This is a role in the field of information technology (IT) responsible for managing and maintaining databases. The DBA’s tasks ensure that databases are efficiently running, secure, and available to users. The main focus of this blog is SQL Server, one of many Relational Database Management Systems (RDMS) available on the market.
What is the purpose of this blog?
To provide valuable information for DBAs, software developers, sysadmins, and other IT professionals, offering insights on best practices, troubleshooting particular issues, and information on new tools or software updates. You may see display Ads, and there are no Affiliate links on this site.
What skills are required to be a DBA?
A DBA should have a strong understanding of database management systems (DBMS), SQL, and database design. Key skills include performance tuning, data backup and recovery, security management, and troubleshooting. Familiarity with Operating Systems, Cloud technologies, Automation, and Scripting are focus areas.
How do I become a DBA?
To become a DBA, start by gaining a strong foundation in computer science and database management. You should learn SQL, database design, and how to work with popular DBMS like MySQL, SQL Server, or Oracle. Gaining experience through internships or entry-level IT positions, and earning certifications (such as Microsoft Certified: Azure Database Administrator) can also boost your qualifications. Hands-on practice with database administration tasks like performance tuning, backups, and security will further develop your skills.