Blogs
Software IT
Microsoft SQL Server is Microsoft's classic relational database management system (RDBMS) and one of the best-selling databases on the market.
The database runs in server mode, but can only be installed on Windows servers, providing data and structure access and manipulation services, which can be used from client applications or tools such as SQL Server Management Studio, SQLCmd, or third-party tools that can use connectors such as ODBC, ADO.NET or OLE-DB to execute TSQL commands on SQL Server...
Hive is a software that works on Hadoop clusters creating a layer that allows the developer to abstract from the management of HDFS and MapReduce files through SQL-based data query operations, with the HiveQL language...
Azure Data Factory (ADF) is a powerful data integration service for Microsoft's Azure platform, enabling you to automate and manage the movement of data between on-premises, cloud and third-party data sources.
It provides a graphical interface to easily create, schedule and monitor data pipelines that are built using Azure technologies such as Azure Data Lake Analytics, Power BI Premium and HDInsight. With these tools, you can create a variety of workloads such as extract-transform-load (ETL), real-time streaming analytics, machine learning, and advanced analytics jobs.
Azure Data Factory integrates with Azure Storage, Azure Blob Storage and Azure SQL Database. It also integrates with other Microsoft products such as Power BI, Machine Learning Studio, HDInsight and R Server.
