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

Use File System Task Results in an Email

Here’s a simple how-to on emailing the results of a batch file execution to some email recipients in an SSIS package. Continue reading

Are You Using OData?

I’ve recently began expirmenting with an OData implementation. My initial thoughts are, “Wow, this is cool!” Here’s why… Continue reading