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 ...

The biggest feature in the SQL Server 2019 preview launched at Ignite is SQL Server Big Data clusters. Travis Wright, Microsoft's principal program manager for SQL Server, explains exactly what this ...

Microsoft continues to make positive strides in the world of open source. The company once considered open source software to be an anathema, but now it’s common for Microsoft to pull software ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

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's drive to put Azure SQL Data Warehouse on more equal footing with SQL Server is finally paying off. Azure SQL Data Warehouse gets less press than its online transaction processing brethren, ...

SQL Server is primarily built around a row-based table structure that connects related data elements in different tables to one another, avoiding the need to redundantly store data in multiple places ...

With the latest public preview available, it’s time to decide if you want to upgrade to Microsoft’s most cloud-connected version of SQL Server so far. Three decades on, SQL Server is still a database ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target. Logging is an essential feature for any application, as it is ...

In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools have ...