Blog

Datavail DBAs Weigh in on First Ever SQL Server Geeks Conference

Recently several of our DBAs based in and around Bangalore had the opportunity to attend the SQLServerGeeks Annual Summit 2015 (SSGAS). Learn more today.

Introducing Stretch Databases for SQL Server 2016

Stretch Databases are part of the new SQL Server 2016 from Microsoft. What are “stretch databases” and how do they work? This post offers a summary.

Installation Requirements for SQL Server 2016

Microsoft is getting ready to release SQL Server 2016, which offers exciting new capabilities for hybrid cloud/premises computing from many different devices and connections. Here’s the early word on what you’ll need to run SQL Server 2016.

SQL Server 2016 Brings New Features, Enhanced Analytics

Microsoft is touting SQL Server 2016 for its ability to deliver mission-critical performance & help users obtain deeper insights across data. Read more.

Basics of Using Dynamic Data Masking

Data Masking is a security feature which hides or obfuscates sensitive data from certain users. Learn the basics of using it with SQL Server 2016 here.

Three NoSQL Databases to Consider

NoSQL options are increasing, but the three most popular – MongoDB, Cassandra, and HBase – remain strong contenders. Click here to read more.

Refactoring Databases: A Strategy for Improving Performance and Data

Database professionals can improve existing assets by using the refactoring concept, which allows slow and steady improvement through incremental changes.

Using Microsoft Excel Power Query to Shape Databases

With the release of Excel 2013, Microsoft introduced a set of powerful new features called Power Functions. These include Power Pivot, Power View, Power Maps and Power BI. These Power features take data shaping to a whole new level.

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.

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.

11.1.2.4 Essbase Configuration Bug

A minor Essbase configuration flaw introduced in Hyperion / Oracle EPM 11.1.2.3 remains present in 11.1.2.4.

FDM Enterprise Edition 11.1.2.4 and ODI

As mentioned in one of our previous blog posts about Hyperion / Oracle EPM 11.1.2.4, the 32-bit “classic” edition of Financial Data Quality Management is no longer available