LOB columns have certain restrictions such as the inability to perform online index rebuild. Identifying them maybe important for planning maintenance...
SQL Server Identify User Permissions
Identifying all permissions that a user has over certain type of SQL objects can be useful for audit and assessment purposes. The script below will re...
Identify SQL Server Broken Dependencies
Broken dependencies happen when the relationship between two objects is broken. Prompt identification may help identify and prevent failing processes....
SQL Server Alerts
SQL Server default alerts for new server builds will help you identify critical issues in the system as soon as they occur. The following scripts will...