Bruno Bragatto - database administrator

[SCRIPT] – How to monitor Backup, Restore, DBCC etc… WITH ETA

Hi everyone, Sometimes we need to monitor a specific activity, for example a Backup, Restore, DBCC etc… And we also need to have, possibly, an estimated time of “arrival” (or ETA) it takes to finish […]

[TUTORIAL] – Creating your first SQL Server 2019 Lab on Virtual Box from the Scratch – Part 2: Installing and Configuring Windows Server 2016

Hi everyone, This is the part 2 of a 3 posts series on how to create your first SQL Server 2019 Lab correctly You may want to check the Part 1 of this series before […]

[TUTORIAL] – Creating your first SQL Server 2019 Lab on Virtual Box from the Scratch – Part 1: Downloading what you need

Hi everyone, this post has a very specific objective: Helping you to install and configure CORRECTLY your Lab environment FROM THE SCRATCH! And let’s be realistic: It will never be a “from Zero to Hero” […]

[SCRIPT] – How to find a specific String inside of all the Stored Procedure in a Database

Sometimes we found ourselves into specific situations where we need to find all the stored procedures or functions containing a specific string in their codes, like a table name, specific command etc… For example, last […]

[SCRIPT] – Date Condition using the DATENAME Function

Sometimes it’s necessary to create a Condition based in specific Date (like first day of the year, fifth day of the month, the second Monday of the month etc… ). I’ve been in so many […]

[SCRIPT] – Enable Query Store on all databases (except on those that are already enabled)

Greetings, The script below is a simple and very effective way to enable Query Store on all the databases that don’t have it yet. If you want to enable Query Store for any further database […]