PolyBase scale-out group in Azure for free
create a sql server polybase scale out group in azure for free
2021-06-23 (first published: 2021-04-12)
2,039 reads
PolyBase
Access external data from Azure Synapse Analytics using Polybase
Learn how you can use Polybase technology in Azure Synapse to load data into your warehouse.
2020-07-28
28,016 reads
Adding a Database with Polybase External Tables to Always On Availability Group
Learn how to ensure your PolyBase objects are accessible from all nodes in an Availability Group.
2020-05-26
3,823 reads
Use Polybase to consume Oracle data from SQL Server on Linux 2019
Learn how to set up Polybase in containers to access an Oracle database.
2020-01-09
5,198 reads
2019-09-19
531 reads
2019-09-12
507 reads
PolyBase in SQL Server 2019 – The End of ETL?
PolyBase has been around since 2016, but Microsoft is enhancing it in 2019 with the ability to connect to more data sources. You can now use PolyBase to connect to other SQL Server instances, and it’s easy to set up with a wizard. In this article Benjamin Weissman explains what’s new in PolyBase and walks you through setting it up and connecting to an external table.
2019-08-08
2019-05-22
PolyBase Revealed: SQL Server to SQL Server
Today I’m going to cover something I’ve been waiting to do for just about three years: use PolyBase to connect one SQL Server instance to another SQL Server instance....
2019-05-15
Azure DWH part 14: PolyBase to access to Non relational data
In this article, we will learn how to work with PolyBase using Azure SQL DWH.
2020-12-25 (first published: 2017-08-21)
3,168 reads
Blogs
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers