In the name of all that is sweet and holy, stop sending yourself ugly badly-formatted tabular data in text mode. Instead, give this procedure a try and make your Database Mail messages beautiful. SQLTableToHTMLTable will generate the HTML for you without a ton of effort so that a table looks like a table in your…… Continue reading Send HTML Mail the Easy Way
Tag: monitoring
What’s running right now?
sp_activespids will tell you There’s a lot of ways to see what requests are running on a MS SQL instance. For years I’ve trusted this handy custom stored procedure, sp_activespids, to get it done quickly and with little overhead. It’s been around in one form or another for almost 20 years. I’ve made most of…… Continue reading What’s running right now?