Blog

3 Slick Scripts for Database Mail Alerts and Reports

Database Mail enables you to send e-mail messages from the SQL Server Database Engine. Database Mail uses the standard Simple Mail Transfer Protocol (SMTP) to send mail.

7 Steps to Setting Up Database Mail

As an alternative to SQL Mail, Microsoft suggest using Database Mail. They advise using Database Mail because SQL Mail will be removed in a future version of SQL Server, so using Database Mail in new development work should save you some future heartache.

RAID For SQL Server: What RAID Should You Use?

Which RAID should you use with SQL Server? Learn the differences between RAID 0, RAID 1, RAID 5, and RAID 10, along with best practices.

Tips for Upgrading From SQL 2008 to 2012 or 2014

Datavail SQL Server DBA, Andy McDermid, lays out helpful tips for upgrading from SQL 2008 and beyond. Click to learn more.

SQL Server In-Memory tables – Where is data stored?

SQL Server 2014 introduced the concept of InMemory OLTP which has been a lesser explored topic for many.

SQL Data Load Error

So you’ve decided to use a relational data source to load data into an Essbase cube using the EAS SQL Interface and a load rule.

Grasp the Business Value of a Complete SQL Server Health Check

What criteria should help a manager properly evaluate the merits of a paid health check?

4 Top Trends in Database Management

Trends come and go, but many new concepts for database management are not flavor-of-the-month fads but have staying power, as well as the power to transform organizations.

Investigating Missing SQL Indexes to Increase Performance

If your organization uses a relational database, chances are it relies on an SQL server.