This repository contains all codes for my workshop "Improve your Skills as a SQL Server DBA" All scripts are created for the use of Microsoft SQL Server (Version 2016 or higher) To work with the ...

A database is the backbone of any enterprise application. And most of these applications use database management systems (DBMS) to create, store and manage data. These DBMS software, like Oracle, IBM ...

Microsoft's SQL Server toolbox is a morass of acronyms, from SMO to SSMS to SOS, and differentiating one from the other can be a challenge. I recently caught up with Vicky Harp, lead program manager ...

I often work with student or junior DBAs who ask about the skills they will need to be effective in the modern technical landscape. And, as the technology changes, or course so do the required skill ...

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...