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 ...
Global software house Microsoft is making big data the focus of SQL Server 2019, set for release later this year. A key part is data virtualisation, eliminating complex ETL processes. Microsoft says ...
I've been playing with the new SQL Server Data Tools, and I'm impressed by the way Microsoft has gotten the product out for review and is improving it with user-requested functionality. I've been ...
Having spent the last article showing how we can use WMI to perform a query for the current space on a drive, we need to take a it a step forward and begin tracking this data in a way that we can then ...
Microsoft said a new Always Encrypted security feature highlights its upcoming SQL Server 2016 -- "the biggest leap forward in Microsoft's data platform history" -- shipping this summer in a public ...
When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...