Learning Corner #6 – Grouping sets in SQL Server

Grouping sets in SQL Server always comes into handy when you find yourself in the need to perform data aggregation based on groups. The groups are made by defining a set of attributes that the engine will use to split the data.


How To #3 – Get a list of current backup/restore processes

Getting a list of current backup and restore processes running on your system comes in handy when a lot of people are working on the same environment (and work can overlap) or when you have many automatic backup tasks and want to see which ones are currently running and the time to completion. Don’t be Read More