Select Page

Blog

Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.

Category: MS SQL

Data Shaping with Microsoft Excel Power Query

Anyone who works with data probably has some comfort working with Microsoft Excel. The software’s tabular presentation of data, combined with its ability to easily export, import, and sort, gives it the core capabilities of data analysis.

Eric Russo | June 23, 2015

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.

JP Chen | June 16, 2015

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.

JP Chen | June 9, 2015

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.

Eric Russo | June 8, 2015

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.

Andy McDermid | April 8, 2015

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.

Pinal Dave | February 20, 2015

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.

Eric Russo | October 3, 2014

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?

Eric Russo | August 7, 2014

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.

Patrick Gates | June 9, 2014