Blog : What’s On Our Mind?

Sharing Our Point of View
By Eric Russo | On June 23rd 2015
data_shape.jpg
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. For those who want to take their analytics up a notch, Microsoft introduced several new “Power” features with Excel 2013: Power Pivot, Power View, Power Maps, Power BI, and Power Query. Filtering and Shaping Data with Excel Power Query Editor Using Excel’s new Power Query editor, you can select a number of variables to use in…
By JP Chen | On June 16th 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. After you had completed the simple steps of enabling Database Mail, configuring your SMTP settings and adding the Database Mail account to a Database Mail profile, you will be ready to start using Database Mail to automate notifications and reports that keep you up to the minute on the status of key…
By Patrick Gates | On June 15th 2015
win_oracle.jpg
When should you run Oracle on Windows? Only if you absolutely have to because of skill set. Here’s why. Ideally, you’ll want to run Oracle products on a supported operating system. If there are any issues, you can get the support as intended. Although Oracle cites its interoperability with Microsoft, both on the desktop and in the cloud, saying “Oracle Database 12c makes developing and deploying Oracle on Windows and .NET easier, faster, and more cost-effective,” if you run a database on an operating system environment different from…
By JP Chen | On June 9th 2015
db_mail.jpg
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. Plus “Database Mail runs outside of SQL Server in a separate process, is scalable, and does not require Extended MAPI client components to be installed on the production server.” But the real advantage of using Database…