Cosmos DB Data Migration Between Containers using Databricks and PySpark
In this article learn how to use PySpark scripts in Azure Databricks service to copy data between Cosmos DB containers.
2021-11-05
Azure Migration
Autoscaling in Microsoft Azure
The ability to scale up and down without maintaining extra hardware is one of the best cloud computing features. In this article, Mahendran Purushothaman explains autoscaling in Microsoft Azure.
2021-07-14
Migrating SSIS packages to Azure - Lift and Shift using Azure Data Factory
Unlike an on premises SQL Server, Integration Services (SSIS) works very differently on Azure. If there are requirements to run our existing SSIS packages on Azure, then we need to understand our options. In this article we will talk about our options for migrating SSIS to Azure and what components are required to migrate SSIS packages. […]
2021-04-05 (first published: 2021-03-22)
9,008 reads
Unlocking the “PASS Pro” Educational series
Thanks to the consent of the speakers, the expert-led educational training courses covering the following four topics: Data Modernization, Azure Migration, Azure Synapse, Azure SQL, are now available to all. You can watch the sessions and learn from a range of experts online, for free.
2021-03-17 (first published: 2021-03-01)
Blogs
Big Queries, Big Money
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
A New Word: Fardle-dun
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric...
Forums
Getting ANY of the data
Comments posted to this topic are about the item Getting ANY of the data
Why Would You Do That?
Comments posted to this topic are about the item Why Would You Do That?
The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner
Comments posted to this topic are about the item The Paradox of NOLOCK: How...
Question of the Day
Getting ANY of the data
I have this data in two tables:
-- Beer table BeerIDBeerNamebrewer 5Becks Interbrew 6Fat Tire New Belgium 7Mac n Jacks Mac & Jack's Brewery 8Alaskan AmberAlaskan Brewing 9Kirin Kirin Brewing -- Beercount table BeerName BottleCount Becks 5 Fat Tire 1 Mac n Jacks 2 Alaskan Amber 4 NULL 7 Corona 2 Tsing Tao 4 Kirin 12What is returned from this query?
SELECT * FROM dbo.BeerCount AS bc WHERE bc.BeerName=ANY (SELECT b2.BeerName FROM dbo.Beer AS b2);See possible answers