Category: SQL Server

SQL Server 2016 introduces updatable nonclustered columnstore indexes. The complexity of that phrase should not mask the simplicity and importance of its application. Updatable nonclustered columnstore indexes make possible what Microsoft calls “Real-Time Operational Analytics.” It would be hard to overstate the importance of making real-time transactional data available immediately for data mining and advanced […]

Architecture and Installation The folks at Microsoft have created quite a buzz with the integration of R scripting into SQL Server. In recent years, the open-source statistical program R has established itself as the de-facto statistics and analysis package for big data. But it has always been possible to query SQL Server from R using […]

Part Two: Transact-SQL Queries of Hadoop Data Three tasks are necessary if we are to query Hadoop data with Polybase. We must define the connection information, we must define how the semi-structured Hadoop data is to be parsed, and we must specify the row-and-column format for the parsed data that we will use to write […]

Installation and Configuration of SQL Server 2016 Polybase Introduction Among SQL Server’s many new features introduced in 2016 is Polybase, a bridge between relational data stored in SQL Server and bulk data stored in the Hadoop ecosystem. Hadoop is an excellent store for what many folks call “semistructured” data. That is, data which cannot be […]

SQL Server 2008 R2 and Sql Server 2012 brought with them lots of new features to please data warehouse admins, BI developers, and analysts. Lest the OLTP folks felt left out, Microsoft introduced in 2014 in-memory optimization technology, code-named Hekaton, along with other features designed to please database administrators concerned with transaction processing. It’s the […]