Shrinking a database is a bad thing, but if you have to do it, then here is how to do it right...

This series of articles will cover the first steps you should take when entering a new environment, aiming to improve overall...

How to remotely control multiple computers without having to log into them? Do any task from one central location, and make it scalable?

Azure SQL database is a fully managed relational database in the Microsoft cloud. It is a scalable, durable and performant database...

A great business analysts are never saturated with data, they need more and more. Data analysis frequently calls for data enrichment, to...

Author: Eric Rouach, Madeira Data Solutions Date: March 2022 The following guide describes how to execute and schedule any T-SQL command...

If you are using an old version of SQL Server, then you have some good reasons to upgrade. Here are five of them...

Part 2: Create your first ADF pipeline Author: Eric Rouach, DBA at Madeira Data Solutions Date: 2022-02 Description: The following will...

Filtered Indexes are pretty great, honestly. If, of course, you can actually create them and use them in your environment. But, what if not?

Part 1: Setup Your Environment Author: Eric Rouach, DBA at Madeira Data Solutions Date: 2022-02 Description: The following will guide you...