Learn how to use Fivetran HVR software to ETL data into your One Lake Storage from a PostgreSQL database.
2024-12-06 (first published: 2024-11-27)
1,471 reads
Microsoft Fabric changes the paradigm for how you might store data in your warehouse.
2023-08-07
212 reads
Deploy resources in Azure using reusable code with Terraform modules.
2022-10-10
11,588 reads
2022-07-06
345 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
30,036 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,491 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
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Setting page visibility and the active page are often overlooked last steps when publishing...
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item Using table variables in T-SQL
I am trying to check out elastic query between two test instances we have...
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers