<img alt="" src="https://secure.hims1nice.com/151009.png" style="display:none;">
" style="background-color: #2c3e50;">


3 things you need to know about R Services for SQL Server 2016

Posted by Lucas Feiock on Jun 14, 2017 10:18:06 AM


Getting Started with R Services for SQL Server 2016

SQL Server 2016 is enterprise ready for transaction processing, data warehousing, and business intelligence.

As part of SQL Server 2016, R Services expands the scope of these existing data technologies to include advanced analytics in enterprise workflows allowing for the building of intelligent, predictive applications by leveraging the R language and in-database analytics. 


Read More

Topics: SQL Server

Azure SQL Data Warehouse Introduction

Posted by Lucas Feiock on May 17, 2017 9:54:38 PM

Azure SQL Data Warehouse is a fully managed, elastic data warehouse-as-a-service for processing enterprise workloads.

Read More

Topics: SQL Server, Azure

Azure SQL Data Warehouse [Data Import Strategies]

Posted by Lucas Feiock on May 17, 2017 9:54:21 PM

The process of loading data into a traditional data warehouse typically follows the pattern of Extracting, Transforming, and Loading (ETL). Most businesses use a dedicated server to perform these operations.

However, with MPP architecture and the ability to load data fast, the new standard is becoming Extract, Load, and Transform or ELT.

Read More

Topics: SQL Server, Azure

Analyzing Unstructured Data with PolyBase in SQL 2016

Posted by Lucas Feiock on Nov 2, 2016 10:10:42 AM
PolyBase is a Microsoft technology that can query Hadoop clusters or Azure Blob Storage. This is achieved by using T-SQL statements to import and export data between relational and non-relational data sources. While PolyBase is similar to Hive's HiveQL, Teradata's SQL-H, Apache Drill, Apache Sqoop, or Cloudera Impala it is different. With PolyBase, SQL Server Developers can use existing skills to query Hadoop. The need for SQL Server Developers to learn Hadoop or Linux is not required.
Read More

Topics: SQL Server

5 Ways to Get Better Data for Better Decisions

Posted by Jim Hodges on Jul 28, 2016 3:00:00 PM

We all want to make good business decisions. They are crucial to the success of our enterprises. The quality of our decisions stem from two factors:

1. Sound decision processes and skills. 

This is why we get MBAs and continue to learn and study all our lives.

2. Good (true) knowledge (data) of the environment and situations which command our attention.

If you make a sound decision based on incorrect or the wrong data, you will get a bad decision and possibly a bad outcome.

Read More

Topics: SQL Server, Power BI

Coming Soon to a Machine Near You, SQL Server 2016!

Posted by Jim Hodges on May 10, 2016 11:09:04 AM

When a software package has been around as long as Microsoft Windows™, Office™, or SQL Server™ (all dating to circa 1990), it seems to become harder and harder to add significant new features to such a mature product. Other than pivot and the ribbon, Office™ is virtually unchanged from the early days. Windows™ has taken more risk yielding successes as well as flops like Millennium™ and Vista™. But SQL Server™ just seems always to get better and better while maintaining continuity. The upcoming 2016 release (June 2016) is no exception.

Read More

Topics: SQL Server, Microsoft, Business Intelligence