Easily push SQL Server data to Salesforce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesforce or update existing records with data from a SQL Server database. 
The post Use the CData SSIS Components to Insert New or Update Existing Salesforce Records from SQL Server appeared first on SQLServerCentral.

Not a week goes by without news of a new cyberattack. In this article, Robert Sheldon explains the cybersecurity threats in today’s world.
The post Cybersecurity threats appeared first on SQLServerCentral.

A key finding from Redgate’s recent State of Database Monitoring Survey of over 2,500 IT professionals was that 79% of respondents reported using either a third-party or in-house monitoring tool. It’s notable because it’s an increase of 10 percentage points from the same survey last year. But when should you use an in-house tool, and when should you take the plunge and invest in a third-party monitoring tool like SQL Monitor?
The post 5 things to look for in a monitoring tool appeared first on SQLServerCentral.

With Amazon DocumentDB developers and DBAs can balance availability, read scalability, and latency with five pre-configured consistency levels. The data in an Amazon DocumentDB cluster is accessible just like a MongoDB 3.6 cluster. The CData Software Drivers for MongoDB provide a SQL-like interface to MongoDB data through standards-based drivers. This allows users to see their data in the […]
The post Connecting to Amazon DocumentDB with MongoDB Drivers appeared first on SQLServerCentral.

Database objects often have references to external databases which makes continuous integration problematic. In this article Liz Baron and Sebastian Meine demonstrate a solution.
The post How to successfully deploy databases with external references appeared first on SQLServerCentral.

I have worked in more than one regulated industry, and since the banking crisis of 2008, I have witnessed a sea change in the approach to regulation.  The UK Financial Services Authority (FSA) was seen to be a toothless tiger.  The UK government replaced the FSA with two separate bodies, each with its own more […]
The post Design your systems and processes for auditability appeared first on SQLServerCentral.

In this article we look at how to use string functions to concatenate, replace, trim and get substrings in SQL Server, Oracle and PostgreSQL.
The post SQL String functions in SQL Server, Oracle and PostgreSQL appeared first on SQLServerCentral.

Although it is easy to get started with Flyway, there are times when real-life can trip you up. Discover the fastest ways to restore the previous version of the database, to recover from a failed Flyway migration that leaves the database in an indeterminate state, and then how to adapt your database development process to avoid these problems.
The post Dealing with Failed SQL Migrations in MariaDB or MySQL appeared first on SQLServerCentral.