Many new features of SQL Server 2008 have grabbed the headlines in the past year or so but quietly Microsoft has been enhancing SQL Server Integration Services also.

Another on-premises version of Microsoft's BizTalk enterprise integration server is coming next year. And Logic Apps will be hostable on-premises in 2019, too.

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.

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

An open source project gives DBAs the ability to channel PowerShell for automating and scaling complex SQL Server tasks, starting with the most basic: database backups.

Attunity, a provider of real-time data integration and event capture software, has introduced a suite of Operational Data Replication (ODR) solutions integrated with Microsoft SQL Server Integration ...

Java, SQL Server and JDBC tutorial In this Microsoft SQL Server and JDBC tutorial, you'll learn how to connect to a Microsoft SQL Server in Java using JDBC. The steps are relatively straightforward: ...

SQL Server 2022 also includes enhanced support for JSON data, query intelligence for better performance and a Ledger feature that enables blockchain-style tamper-proofing in the database.

Integration of Python for data science, graph processing for NoSQL-like functionality, and it runs on Linux as well as Windows. At almost 30 years of age, Microsoft's flagship database has learned ...

The latest SQL Server comes packed with support for Linux, automatic tuning and other enhancements that will enhance and simplify the use of the database platform.