Category: Uncategorized
-
Decrypt and Save a Text or CVS with PGPY and Python
Hopefully this helps someone to Decrypt and Save a Text or CVS file with PGPY and Python. Use Kleopatra and OpenPGP to generate and save your key. You can obtain it by Exporting “Backup Secret Keys”. Then run this code to decrypt and save the file in whatever location you need. That’s it! Keeping it…
-
Best Science-Themed Gifts: Get Your Nerd On
Are you struggling to find the perfect gift for the scientist in your life? Look no further! We’ve compiled a list of the best creative gift ideas that are sure to impress the science-loving person in your life. Here are our top 5 Best Science-Themed Gifts. A periodic table throw blanket This cozy blanket is…
-
Get Data from NetSuite using Azure Data Factory
Get Data from NetSuite using Azure Data Factory. As Netsuite is an oracle product, getting data into your data warehouse can be a little tricky. Here is a helpful guide to get started. Side Note: Want to learn SQL or Python for free. In less then 10 minutes a day and less than an hour…
-
Use Azure Blob Storage for SFTP
This feature is in preview at time of writing and may be subject to change. Here is a quick guide on how to Use Azure Blob Storage Gen2 for SFTP for cheap serverless SFTP. Step by step guide on setup and access. By using local users, this allows you to create a series of SSH…
-
Connect to Azure SQL using Active Directory and Grant Access outside Organization
Learn how to Connect to Azure SQL using Active Directory and Grant Access outside users outside of your Organization. This comes in handy when you have a user that sits outside of your organization and they need to log into a SQL environment you have provisioned for them. They will need to be invited as…
-
Best Men’s Fashion Blog Links
Cheap Business Casual Capsule Wardrobe for Men The Capsule Wardrobe Guide for men 2022 Best Male Fashion Watches on Amazon Under $50 The Guide on How to Care for Men’s Sweaters The Basic Bastard Wardrobe Guide Basic Layering Tips for Men Affordable Wedding Bands For Men: The Best Cheap Wedding Bands Ideal Men’s Haircut for…
-
Visual Studio Database projects to Deploy Azure Synapse Pool
Visual Studio Database projects to Deploy Azure Synapse Pool Side Note: Want to learn SQL or Python for free. In less then 10 minutes a day and less than an hour total? Signup for my free classes delivered daily right to your email inbox for free! Now back to the article… Get Visual Studio 2019…
-
Automatically pausing and resuming Azure Workspace Synapse Pool Using Azure Data Factory
Automatically pausing and resuming Azure Workspace Synapse Pool Using Azure Data Factory. Create a new Azure Data Factory Pipeline Add the Web Task and name it “PauseDW” In the settings, follow the following steps. copy the following command. MOre on this command can be found here. https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}/resume?api-version=2019-06-01-preview Most of this information can be found in…
-
Looping SQL Tables to Data Lake in Azure Data Factory
When you load data from a SQL Server, instead of individual pipelines, it is best to have one dynamic table controlled process. Learn how to loop through SQL tables dynamically to load from SQL Server to Azure Data Lake. Looping SQL Tables to Data Lake in Azure Data Factory Setting up the ETL_Control Database Create…
-
Streaming ETL with Azure Data Factory and CDC – Create a Parameter Driver Pipeline
In this series we look at building a Streaming ETL with Azure Data Factory and CDC – Create a Parameter Driver Pipeline. This is Part 6, The rest of the series is below. Enabling CDC Setting up Audit Tables Provisioning Azure Data Factory Provisioning Azure Blog Storage Create Data Source Connection in ADF Create Incremental…