Subreport with Shared Dataset

BIDS throws an exception when you preview a report that uses subreports that uses shared datasets. Continue reading

Reports with MultiSelect Parameters Not Working

Yesterday your reports were working, today they just display blank pages. Sometimes a security patch can break things, but they’re easily fixed… Continue reading

Do you know if Database Mail is Having Problems?

Database Mail can experience problems that can be hidden from your scheduled jobs and SSIS packages. Read more to find a query that help you expose Database Mail issues so they can be fixed. Continue reading

SQL Agent Security

SQL Agent is a powerful tool to automate tasks in SQL Server. Understanding its permission model will help you ensure your data stays secure. Continue reading

Configure Database Mail and SQL Agent Alerts

Take some of the drudgery out of a SQL Server installation … here’s a script to configure Database Mail and SQL Agent Alerts. Continue reading