Dynamically Generate Replication Tasks with Biml and Custom Connectors
This article walks through using Biml with 3rd party connectors to replicate external data to SQL Server in SSIS.
2021-02-19 (first published: 2019-03-21)
1,723 reads
This article walks through using Biml with 3rd party connectors to replicate external data to SQL Server in SSIS.
2021-02-19 (first published: 2019-03-21)
1,723 reads
With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud.
2020-07-17 (first published: 2019-01-02)
4,457 reads
SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]
2019-04-30
3,448 reads
TDS remoting services provide a native SQL experience with local and remote ODBC data sources (contrast with limitations of using OLE DB).
2017-08-28
3,379 reads
Using a CData DataCmdlet and sqlps to replicate data from Google Spreadsheets to a SQL Server database in PowerShell
2017-06-01
878 reads
This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.
2017-04-24
49,505 reads
This article demonstrates using Angular2 and the CData API Server to build dynamic Web pages using SQL Server data.
2017-02-08
6,109 reads
A brief comparison of three different JDBC Drivers built for connecting with MySQL
2016-05-19
3,044 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers