azure

Azure Data Factory : Your First Data Pipeline

  • Article

Introduction Azure Data Factory is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. We can create and schedule data pipelines which can move data between various supported data stores. We can also use for data transformation before loading it into […]

5 (1)

2020-08-11

1,744 reads

Installing SQL Server 2019 using the Azure Cloud Shell

  • Article

Introduction Microsoft released SQL Server on Linux, starting from SQL Server 2017. SQL Server 2019 (15.x) has the same underlying database engine on all supported platforms, including Linux. Therefore, many existing features and capabilities operate the same way on Linux. Platform File System Red Hat Enterprise Linux 7.3, 7.4, 7.5, 7.6, or 8 Server XFS […]

5 (2)

2020-06-01

1,726 reads

Processing Data Using Azure Data Lake, Azure Data Analytics, and Microsoft’s Big Data Language U-SQL

  • Article

Data analytics has become one of the powerful domains in the world of data science. An enormous amount of data is being generated by each organization in every sector. Computer science has found solutions to store and process this data in a smart way through a distributed file system. One such example is Azure Data Lake. It uses the Hadoop Distributed File System, and to perform analytics on this data, Azure Data Lake storage is integrated with Azure Data Analytics Service and HDInsight. In this article, Suhas Pande will explain how to store data using Azure Data Lake and how to perform data analysis on it using U-SQL, a big data SQL and C# language.

2019-04-29

Blogs

T-SQL Tuesday #129 – Let’s Build a Time Capsule

By

It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting...

Daily Coping 11 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Why a 60GB Database Backup Grew to 1TB in Size

By

Recently, I was alerted to a network file share that was running low on...

Read the latest Blogs

Forums

COPY Activity Failing

By SSCNewbee

Hi All I am copying from DLS to SQLMI and my COPY activity is...

multiplied columns from Oracle linked server

By cphite

  Wasn't sure exactly where to put this one... We populate an Oracle data...

Job that runs slow how to use more CPU

By sqlfriend

We have a web application job that runs from web calling to update database...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The D in ACID

See possible answers