• Optimized Bulk Loading of Data into Oracle

    SQL Server 2008 and SQL Server 2008 R2 (Enterprise editions) support bulk loading Oracle data using Integration Services packages with the Microsoft Connector for Oracle by Attunity. For SQL Server 2005 and the non-Enterprise editions of SQL Server 2008 ...read more
  • Bulk insert command fails to insert the correct characters?

    Bulk insert command is not inserting correct characters from a flat file into the table. For instance, the character “Ñ” is displayed as “+æ“ after getting imported in the table. In other words the characters from ...read more
  • Can TLS certificate be used for SQL Server encryption on the wire???

    During our recent interactions with a few customers, we were asked following questions about TLS certificates with SQL server: 1. Can TLS certificate be used with SQL Server 2008 for server-side encryption? 2. If Yes, How? To start with, let’s ...read more
  • Failure of SQL Server 2008 Installation due to MSI error

    Issue: Installation of SQL Server 2008 might fails with below error on 64-Bit Operating system. MSI Error: 1719 The Windows Installer Service could not be accessed. This can occur if you are running Windows in safe mode, or if Windows Installer ...read more