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 ...

Welcome to my box of tricks (SQL scripts) for Microsoft SQL Server instance and database administration! I've put considerable effort, over many years, into creating my own scripts, as well as ...

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 ...

This template provides a baseline for evaluating enterprise DBA candidate’s skill set, ranging from application deployment support to database design.

I'm supposed to be a software developer/consultant. However, I'm also the guy people look at when the application isn't running "fast enough." With business applications, speeding up the application ...

Struggling with SQL Server? Get the no-cost DBA playbook. See how to simplify your work, improve SQL Server performance and enjoy happier workdays when you download our free DBA playbook. This easy-to ...

I am getting a lot more unsolicited questions these days such as this one: “My co-workers tell me there is no future for SQL Server DBAs. Will I have a job in the long-term? I’m confused and ...

Companies today are faced with the trade-off of the security of having an on-premises solution and the convenience of moving their data to the cloud. With Microsoft, companies no longer have to make ...