SQL Server 2005's Integration Services feature fulfills the core needs of ETL (Extract Transform and Load) within the enterprise. This technology isn't your old Data Transformation Services (DTS), but ...

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

Microsoft SQL Server 2016, the latest version of Redmond's core operational database, has reached GA. This release, which has been available in public preview for just over a year, is probably one of ...

Note – This book abbreviates SQL Server 2008 Reporting Services as SSRS and SQL Server 2005 Reporting Services as SSRS2K5. New features available in SSRS and not in SSRS2K5 are labeled with “New in ...

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.

It was barely a month ago that Microsoft announced the general availability of SQL Server 2017 after having released the product in preview and release candidate forms earlier in the year. Today, at ...

SQL Server 2008 R2, which ships this month, allows end users to tap into the powerful business intelligence features of SQL Server via tight integration with popular Microsoft applications like Excel.

Today, at its Ignite conference in Orlando, Microsoft is announcing the general availability of a new version of its flagship operational database, SQL Server 2017. SQL Server is a product I have ...

A Java Web application often uses a SQL Server database. SQL Server now comes bundled with a reporting tool, Reporting Services. RS has generated a lot of attention among developers since it first ...