Archive to the Lake
Microsoft Fabric changes the paradigm for how you might store data in your warehouse.
2023-08-07
196 reads
Microsoft Fabric changes the paradigm for how you might store data in your warehouse.
2023-08-07
196 reads
Deploy resources in Azure using reusable code with Terraform modules.
2022-10-10
11,388 reads
2022-07-06
342 reads
In this article I demonstrate how to use Delta Lake's time travel functionality for ETL logging along with steps to take to implement.
2022-07-01
This article will describe how to add your local timestamp at the end of the each file in Azure Data Factory (ADF). In general, ADF gets a UTC timestamp, so we need to convert the timestamp from UTC to EST, since our local time zone is EST. For example, if the input Source file name […]
2021-04-22
29,013 reads
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
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....
2019-04-09
Read a step by step guide to setting up an Azure Data Lake Storage account.
2021-02-05 (first published: 2019-03-19)
5,403 reads
This article will help with gaining confidence and familiarity with Microsoft Azure's Data Lake Analytics offering to process large datasets quickly while demonstrating the potential and capabilities of U-SQL to aggregate and process big data files.
2019-02-20
2,259 reads
In this tip we learn how to update the Azure SQL Data Mart in an automated way.
2019-01-01
1,758 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers