While I always configure transaction log backups for every database in non-simple recovery model, and to compliment it I also have monitoring in place if transaction log doesn't get...
2023-04-02 (first published: 2023-03-31)
I should mention outright that this post applies to SQL Server version 2016 and up.Over the years I have relied on the backup history tables in msdb to check...
2020-01-15 (first published: 2020-01-06)
517 reads
If your organization uses a password policy (there are very good odds these days that it does) and, especially stricter password requirement for administrative users, your might have experienced...
2019-11-26 (first published: 2019-11-18)
729 reads
Event notifications are kinda like a trigger in the sense that they respond to specific event, specifically in response to DDL statements and SQL Trace events.
The major difference between...
2019-11-21 (first published: 2019-11-13)
892 reads
I am in a situation where I have to incorporate SQL Server Agent alerts in my monitoring and alerting strategy.I needed a query (DMV) to get details on what...
2019-11-18 (first published: 2019-11-07)
643 reads
This is a simple powershell script to query and display hardware and OS information from a remote computer.
It uses CIM (Common Information Model) that is available since Powershell version 3 so as long as you have version 3 and up, you should be able to run this script against any server that you have access to.
2019-08-14 (first published: 2019-08-06)
1,441 reads
If you are new at your job or a new client you would like to gather and review the sql server meta data to understand the environment and get...
2019-08-01 (first published: 2019-07-10)
614 reads