Azure SQL Migrations using Azure Data Studio
This article looks at database migration with the Azure Data Studio extension, making it easy to move databases from an on premises SQL Server to one in Azure.
This article looks at database migration with the Azure Data Studio extension, making it easy to move databases from an on premises SQL Server to one in Azure.
The future of work is uncertain, but not everyone is ready for remote work to continue.
Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon explains the Azure SQL options.
I recently began writing an article to compare the performance of several window functions to traditional query methods. I began with my favorite function, LAG, but soon found that there were so many other ways to write the query that the article never covered the additional window functions. The article was quite fun to write, […]
When you work with ETL and the source file is JSON, many documents may get nested attributes in the JSON file. Your requirements will often dictate that you flatten those nested attributes. There are many ways you can flatten the JSON hierarchy, however; I am going to share my experiences with Azure Data Factory (ADF) […]
How to use Flyway configuration files to minimize typing during ad-hoc development from PowerShell or DOS; you just type in the Flyway commands you need and hit "go" and the config files take care of all the tiresome connection, authentication and project details.
In this article we will walk through a clear end-to-end process of securely mounting an ADLS gen2 account in Databricks.
Your manager doesn't always know what you're doing, and rarely knows what you've done. That's your job.
The ODBC Driver for Salesforce from CData provides ODBC-based access to live Salesforce data, allowing you to interact with Salesforce data in a range of BI, reporting, and ETL tools — as well as directly using SQL queries. In this article, we demonstrate how to connect to Salesforce data using an ODBC connection in Alteryx Designer to conduct self-service BI, data preparation, data blending, and advanced […]
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
By Arun Sirpal
I speak to many people who use cloud technologies, especially database tech and how...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers