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,813 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,813 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,785 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,586 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,620 reads
Using a CData DataCmdlet and sqlps to replicate data from Google Spreadsheets to a SQL Server database in PowerShell
2017-06-01
934 reads
This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.
2017-04-24
51,982 reads
This article demonstrates using Angular2 and the CData API Server to build dynamic Web pages using SQL Server data.
2017-02-08
6,327 reads
A brief comparison of three different JDBC Drivers built for connecting with MySQL
2016-05-19
3,258 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
I have a couple of SQL Agent job steps which run PowerShell commands of...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers