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)
1,562 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
26,563 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,400 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
4,991 reads
2019-09-19
508 reads
2019-09-12
485 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,032 reads
Blogs
Redgate Summit Comes to the Windy City
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
Non-Functional Requirements
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
Techorama 2024 – Slides
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Forums
Error while an ADF pipeline runs stored procedures against Azure SQL Server MI
Dears, We are using Azure Data factory pipes to run some stored procedures against...
Clear Trace - Asking for SQL Server 2008
Hi, I have SQL Server 2019 installed and when go the Clear Trace database...
get all txt files $filenameAndPath = code please help
Hello I need to get txt files from directory and send email, when I...
Question of the Day
The "ORDER BY" clause behavior
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers