ad-hoc queries

About this tag
Ad-hoc queries in SQL Server 2016 are explored through the PolyBase feature, which allows querying relational and non-relational data using T-SQL. This capability extends SQL Server to external data stores like Hadoop, enabling users to run ad-hoc queries on diverse datasets without moving data. The discussion highlights how PolyBase simplifies management and querying of both structured and unstructured data, supporting the growing volume of non-relational data in cost-effective storage systems.
  1. PolyBase in SQL Server 2016 | Data Exposed

    This week's episode of Data Exposed welcomes Sahaj Saini, Program Manager on the SQL Server team. Today, Sahaj joins us from our southern California office to show us an exciting new feature of SQL Server 2016 called PolyBase. PolyBase simplifies management and querying of both relational and...