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

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

In a previous blog entry, I discussed the issue surrounding ORDER BY’s in VIEW’s and backward compatibility. The blog was entitled: “ORDER BY in a View is not allowed – or is it?”. Well, it looks like ...