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

Database replication is a valuable tool that allows companies availability and scalability with their data. To help support customers in this area, Dell is releasing version 8.6 of SharePlex, its ...

I have a need to compare multiple different versions of essentially the same SQL Server 2005+ databases and bring the table structures up to that which is in the newest version. It should compare the ...

The Microsoft SQL Server team has made incremental updates to SQL Server Data Tools (SSDT), updating the Schema Compare utility, improving Microsoft Azure SQL Database security and supporting Parallel ...

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

Microsoft has agreed to purchase Zoomix, a small Jerusalem company that provides data-quality technology, to bolster its SQL Server business, the company confirmed Monday. Microsoft did not reveal the ...

Brien M. Posey is a freelance technical writer who has contributed to dozens of books and is a six-time Microsoft MVP award winner. Many IT professionals live by the maxim that if something isn’t ...

While SQL Server 2008 was little more than a service-pack level upgrade, the 2012 version of Microsoft’s database has a boatload of new features and delivers solid performance improvements.

Brien M. Posey is a freelance technical writer who has contributed to dozens of books and is a six-time Microsoft MVP award winner. Many IT professionals live by the maxim that if something isn’t ...