Turns out there's a shortage of solutions online for easily managing partitioned tables in SQL Server. Well... That's where I come in!

(Part 3/3 of “Getting started with Azure Data Factory”) Author: Eric Rouach, DBA at Madeira Data Solutions Date: April 2022 In this demo,...

I published a very simple script to query for all the objects referenced by a specific object in the local database (e.g. a view)...

So you have an old SQL Server. It's time to make a change, but where do you start?

SQL Sentry uses a service to monitor targets. But what if this monitoring service is down? Who will alert about the alerter not alerting?

You can configure auto-scaling in two ways. The first is called Optimized Auto-Scale, and the second is called Custom Auto-Scale...

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