Data Partitioning is a very useful feature in SQL Server 2005 and beyond. I have discussed this database feature in previous blog entries but it is also available in SQL Server Analysis Services which ...

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

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