Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features. While in-memory online transaction processing (OLTP) tables may sound like a ...

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

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

In the original proposal for the World Wide Web, Tim Berners-Lee wrote: A generic tool could perhaps be made to allow any database which uses a commercial DBMS to be displayed as a hypertext view. We ...

Recently, my good friend and co-worker Aaron Bertrand and I were producing a video for the upcoming PASS Summit 2015 event. (Learn more about the international SQL ...