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
2,777 reads
This article walks through using Biml with 3rd party connectors to replicate external data to SQL Server in SSIS.
2019-03-21
877 reads
With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud.
2019-01-02
704 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
1,787 reads
Using a CData DataCmdlet and sqlps to replicate data from Google Spreadsheets to a SQL Server database in PowerShell
2017-06-01
564 reads
This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.
2017-04-24
13,359 reads
This article demonstrates using Angular2 and the CData API Server to build dynamic Web pages using SQL Server data.
2017-02-08
3,526 reads
A brief comparison of three different JDBC Drivers built for connecting with MySQL
2016-05-19
1,490 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Sometimes in life you have to do things you really don’t like to do....
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
Hi, I need to include a very simple schema in all of my database...
This is my first time dealing with CLR assemblies and we have setup some...
Hi, I have a requirement to convert a date value like '7th March 2020' ...
Ask SSC