Relocate User DBs in an Instance

Did you inherit an instance and your user DB files are in a crappy directory? Use this to standardize… Continue reading

Thoughts on PowerShell and Installing SQL Server

What I learned from working with PowerShell in-depth for the first time to automate the installation and configuration of SQL Server 2014 Continue reading

Encrypt SQL Server Connections

How to create and configure a self-signed certificate for use in testing SSL encrypted connections to SQL Server 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

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

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