Troubleshooting Microsoft Reporting Services email subscriptions can be a pain. How many times have you created a new subscription a few minutes in advance and not received it, then you are unsure if you set the schedule time correctly, or if you pressed the save button, or if the fix you made to reporting services didn’t work? It’s a time consuming process, but thankfully, there is a better way. Bad Example - Setting the report to run in a few minutes is annoying and can go wrong Instead, you can run some SQL commands on your reporting services to trigger the running and resending...

My workplace (SSW) is looking at standardizing our MSSQL backup procedures by having the same maintenance plan on each SQL server in the origination. I was asked to make this plan put backups to a local hard drive on each SQL server, which I disagreed with. My boss, Adam Cogan (Microsoft Regional Director) asked for Greg Low’s (Microsoft Regional Director, SQL Server MVP and owner of the SQL Down Under podcast) opinion on the matter. He advised that he also runs local backups on all of his MSSQL Servers, and then later copies them to a centralized network location. The main points I was arguing...