PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...

SQL has dominated data querying for decades. Newer query languages offer more elegance, simplicity, and flexibility for modern use cases. For the last three decades, databases and Structured Query ...

SQL Server 2016, the next major release of Microsoft’s flagship database and analytics platform (which is available as a Community Technology Preview [CTP] as of this writing), includes exciting ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Microsoft recently updated SQL Server Data Tools (SSDT) with support for Visual Studio 2012, improved LocalDB functionality and new SSDT Power Tools. SSDT, if you're unfamiliar with it, is a ...

A recent project at my current employer called for creating a new web frontend to an existing MSSQL database. My boss, having created a sophisticated MySQL and PHP-driven black diamond web site in PHP ...

Microsoft's SQL Server business has hit the $5 billion mark in terms of annual revenue and is growing like gangbusters, according to CEO Satya Nadella. But licensing experts believe this stunning ...