Pchome电脑之家

SQL Server 2005中的SSIS维护计划

SQL Server的每一个版本都已经逐渐变得越来越自我调整和自我维护了。然而，对于基本维护的需求，例如删除索引碎片，更新统计数据，检查数据库一致性，以及进行备份仍然是不会消失的。你可以想象一下，索引的维护就像是给你的汽车换油，备份就像是买保险。
it168

SQL Server的SSIS非常好的实践:优化数据表

【IT168 专稿】本文将继续讨论SQL Server目标适配器，异步传输，DefaultBufferMaxSize和DefaultBufferMaxRows，BufferTempStoragePath和BLOBTempStoragePath，以及DelayValidation属性。 第一篇：SQL Server集成服务非常好的实践:语句优化 非常好的实践5：SQL Server目标适配器 ...
dbta

Upcoming Webinar Shows How to Move MV Data to SQL Server using BlueFinity's mv.SSIS

BlueFinity will demonstrate how to create a simple SSIS transformation to move MultiValue data into Microsoft SQL Server using mv.SSIS in a free webinar on Tuesday, January 31. Microsoft SQL Server's ...
Visual Studio Magazine

Why No Full SQL Server Reporting/Integration Services in Visual Studio 2022?

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

Attunity Extends Change Data Capture and Operational Data Replication with Support for SQL ...

Attunity Ltd., a provider of real-time data integration and event capture software, has announced a new release of its change data capture (CDC) and operational data replication (ODR) software with ...
MCPmag

Creating an SSIS Catalog with PowerShell

When deploying SQL Servers and when you need to implement some of kind of business intelligence, chances are you're going to need a SQL Server Integration Services (SSIS) catalog. A SSIS catalog is a ...