Database Mail · SQL Server · SQL Server Backups

Creating a HTML SQL Server Backup Report

Following my last post (Setting up Database Mail to use my Gmail account) where Database Mail was set up to send to a GMail account, this post looks at how to send reports in HTML direct to a mailbox using just a stored procedure. To make life easier, also adding colour to highlight any issues. I create a… Continue reading Creating a HTML SQL Server Backup Report

Database Mail · SQL Server

Setting up Database Mail to use my Gmail account

This week I had to setup a sandbox environment to test sending some HTML reports (created by a SQL Server stored procedure, more on this next week) I’d prepared for a client, and wanted delivered to my mailbox each morning. For the purpose of this demo I used my Gmail account. I created my sandbox… Continue reading Setting up Database Mail to use my Gmail account

Database Mirroring · Security · SQL Server

When automatic failover doesn’t work

Recently encountered an issue on a client site where they have automatic Database Mirroring failover but when it came to failing over it didn’t work!  (the automatic failover of the database worked but the website couldn’t connect).This quickly becomes a stressful place to be, especially if the database is client facing and you are new… Continue reading When automatic failover doesn’t work