Using the OLE DB Provider for SQL Server/Analysis Services, the end-user can connect to a Data Source directly and build a Pivot Table or PivotChart using standard Excel functionality.

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

An interesting session I attended at the PASS Summit in Seattle was one concerning dealing with VLDBs in SQL Server. It was called “Big Data – Working with Terabytes in SQL Server” presented ...

I was once asked what I thought Microsoft's overall product trajectory for SQL Server was, in light of Oracle's rather obvious trajectory of acquiring multiple application vendors who will, in turn, ...

SQL Server 2008 R2 will be available as part of Microsoft’s Small Business Server package. That version has the same features as the standard edition, but is limited to 75 users.

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data.

Microsoft announced late last month that it'll be ending support for two SQL Server capabilities, with cloud services and SQL Server 2022 typically proposed as replacements.

Microsoft today released the 2022 version of its SQL Server database, which features a number of built-in connections to its Azure cloud.