What if we had 50 SQL Servers and wanted to plot the history of SQL Agent jobs or any other common metric? And what if we wanted to create a template and be able to feed a different list of servers every time? This could be challenging but hopefully, PowerBI can be dynamic.
We can move existing files, in the existing Storage Account to the archive tier, or upload files as we normally would to an existing account and can then mark them for archiving. This process is completely manual but with the help of PowerShell can be easily automated.
DML Triggers are commonly used to apply some business rules to the data in the table. The most common implementation would be updating the date_updated column automatically whenever the data in the table changes. Learn how to avoid firing trigger when doing an update without disabling it.
Ransomware is a type of malicious software that blocks access to user files until a ransom is paid. Learn what steps to take to be able to recover quickly with minimal data loss.