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

Microsoft has dabbled in the ETL (extract-transform-load) marketplace for a long time, in fact, almost 2 decades. Way back in the day, SQL Server shipped with a command-line tool known as the Bulk ...

Visual Studio 2022 has been out for some eight months now, but it still lacks full support for SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS), a top feature request.

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

Acta Technology has become the first data integration software provider to embed Web services capabilities into an extraction, transformation and loading (ETL) tool, its ActaWorks 5.2. This ...

As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...