Configure Email Alerts via T-SQL

You can run the following SQL script to ensure email alerts are configured for the LSCopy and LSRestore jobs:

Views – 450

Using sp_WhoIsActive

Here is an awesome extentions of the sp_who and sp_who2 (undocumented) sprocs DBA’s use to see slow running queries etc. Download link for…

Keeping Indexes online while reindexing

This will also display the SQL Statement that is the offending blocker. Online index operations: Online index operations were added as an availability…

SQL Administration Part 1

Here are some SQL Administrative queries:

sp_configure Use Type the following to see the options the system sproc “sp_configure” has available to…