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.

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.

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.

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.

That is why bridging the SQL expertise gap is about so much more than simply plugging resource holes. It is about unlocking ...

PolyBase, Microsoft's SQL Server-Hadoop integration technology, is now in the mainstream Enterprise version of SQL Server.

SQL Server support on these platforms extends to the core database engine and to SQL Server Integration Services (SSIS). So if you were excited to move SSAS or SSRS over to Linux, you’ll have to wait ...

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.

In addition to the database engine and tools, SQL Server Integration Services is available on Linux, and I would be surprised if Microsoft didn't port the other components of the SQL Server ...

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.