Tom Fenton shows you two ways to overcome the gotchas when setting up an ODBC connection to a remote database. This article is a follow-up to one I wrote in August 2017, "How To Set Up a SQL Express ...

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. In an earlier column, I showed how ...

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