Azure SQL Data Warehouse announcement
-
Link
We are excited to announce the general availability of Azure SQL Data Warehouse in four additional regions—North Europe, Japan East, Brazil South, and Australia Southeast. These additional locations bring the product worldwide availability count to 18 regions – more than any other major cloud provider.
Read More Here!
-
1 VotesResources and Support for Azure SQL Data Warehouse
Official Pages: HomepageDocumentationMSDN Reference LibraryVideo Tutorials Request Pages: Feature ...Sticky | 0 Replies | 3399 Views | Created by Ellis Hiroki [MSFT] - Friday, September 16, 2016 10:00 PM
-
0 Votes
Help with RLS and delete operation
Hello, I did filters, applied to tables and work perfect. Also in my security functions I return all rows for "admin users" of my company. The problem is when I try to ...Unanswered | 3 Replies | 173 Views | Created by clizana - Wednesday, December 18, 2019 1:10 PM | Last reply by Mike Ubezzi (Azure) - Thursday, December 26, 2019 5:29 PM -
0 Votes
Strategy for Query and Processing instances of Azure SQL Data Warehouse
Hello Experts, We have an instance of Azure SQL data warehouse that currently hosts a DB of ~100TB and does incremental data processing 3 times a day for data subjects that ...Unanswered | 3 Replies | 108 Views | Created by MSBI Dev 2012 - Monday, December 23, 2019 5:39 AM | Last reply by Gonzalo Bissio - Thursday, December 26, 2019 1:39 PM -
0 Votes
Hash Distribution vs nvarchar(max)
Hello Everyone, I am facing a very big issue: I have a table to be created where has a field with nvarchar(max) data type that I must keep. It avoid to the table ...Unanswered | 2 Replies | 81 Views | Created by apimenta - Monday, December 23, 2019 1:57 AM | Last reply by Kalyan Chanumolu-MSFT - Tuesday, December 24, 2019 2:46 AM -
0 Votes
Memory Percentage Graph... What does it mean? What is ideal?
I have been watching our memory graph in the Azure portal. It seems that after a pause or scale, the memory usage will drop really low. After this as data is loaded in our nightly jobs, ...Proposed | 2 Replies | 150 Views | Created by Dorky_D - Thursday, December 19, 2019 5:16 PM | Last reply by NavtejSaini-MSFT - Monday, December 23, 2019 2:52 PM -
0 Votes
How to migrate a database from on-premises to Azure Data Warehouse
Hi, It seems that the Data-Warehouse migration utility is no longer available for download (link is gone). I am trying to migrate a db from my local desktop to ...Proposed | 2 Replies | 150 Views | Created by Marios Philippopoulos - Friday, December 20, 2019 12:39 PM | Last reply by NavtejSaini-MSFT - Sunday, December 22, 2019 12:48 AM -
0 Votes
Is there a way to find out the updated rows between two tables (ex. staging and publish) using stored procedures in SQL Datawarehouse?
I want to find out what are the rows in the staging table that has been updated since it was last copied to the publish table. So that I can take the rows and update them in the publish table and ...Proposed | 4 Replies | 374 Views | Created by Kuharan Bhowmik - Monday, December 2, 2019 5:16 PM | Last reply by Kalyan Chanumolu-MSFT - Friday, December 20, 2019 2:38 AM -
0 Votes
sys.dm_pdw_nodes_exec_requests has null values
My goal is to join sys.dm_pdw_exec_requests to sys.dm_pdw_nodes_exec_query_stats. The DMV sys.dm_pdw_nodes_exec_query_stats provides great detail on query ...Unanswered | 4 Replies | 185 Views | Created by derek- - Tuesday, December 17, 2019 9:21 PM | Last reply by derek- - Thursday, December 19, 2019 4:40 PM -
0 Votes
Azure Synapse Analytics Questions - Data Factory
I have lots of questions regarding Azure Synapse Analytics (There doesn't appear to be a Forum for it yet) We have all our data Factories is a specific service. Should be be moving ...Answered | 8 Replies | 480 Views | Created by Debbie Edwards - Thursday, December 5, 2019 10:28 AM | Last reply by Debbie Edwards - Monday, December 16, 2019 4:30 PM -
0 Votes
Issue SAS token - DP 201 - Data Bricks - Setup environment
Hi I am completing my learning path for DP 201 and right now at Perform data engineering with ...Answered | 2 Replies | 218 Views | Created by Gurang Arora - Thursday, December 12, 2019 9:33 AM | Last reply by Mike Ubezzi (Azure) - Friday, December 13, 2019 9:43 PM -
2 Votes
Has anybody used the DISTRIBUTION=REPLICATE feature in ADW yet?
I was curious if anybody has tried the new REPLICATE feature that is currently in Public Preview. I have several smaller tables that I re-created using DISTRIBUTION=REPLICATE ...Proposed | 4 Replies | 689 Views | Created by Bjackman - Wednesday, December 13, 2017 7:16 PM | Last reply by Marshall, Paul - Friday, December 6, 2019 1:22 PM -
1 Votes
How to access Azure Synapse GUI
Hi, I am looking for steps to create Azure Synapse Analytic service. When i search for it in portal, it ask me to enter sql server name and database name. But in one of ...Proposed | 2 Replies | 272 Views | Created by CloudLearner444 - Friday, December 6, 2019 5:38 AM | Last reply by Cloud learner - Friday, December 6, 2019 8:21 AM -
8 Votes
SSMS, Intellisense not working - Azure SQL Data Warehouse
When connected to Azure SQL Data Warehouse, Intellisense is not working at all. If I connect to Azure SQL Database, or an on-prem SQL Server instance, intellisense works ...Answered | 5 Replies | 775 Views | Created by Henrik A F - Wednesday, March 7, 2018 6:27 AM | Last reply by NavtejSaini-MSFT - Friday, December 6, 2019 12:28 AM -
0 Votes
how to provide Star schem data warehouse access to Power BI user based Org Hiearhecy power bi is external user
Hi Teams, i have star schema inside i have orgdim Zone country city postalcode - lower ...Proposed | 1 Replies | 269 Views | Created by manish0000 - Wednesday, December 4, 2019 11:17 AM | Last reply by Mike Ubezzi (Azure) - Thursday, December 5, 2019 8:10 PM -
0 Votes
Azure Synapse Analytics Questions - Migrating a database to DW
We tend to get started with a data base when we are just doing development and proof of concept testing. Then we would decide to move into a data ...Proposed | 1 Replies | 247 Views | Created by Debbie Edwards - Thursday, December 5, 2019 10:33 AM | Last reply by NavtejSaini-MSFT - Thursday, December 5, 2019 6:40 PM -
0 Votes
Azure Synapse Analytics Questions - Data Bricks
A final Question, If you set up all your Data bricks, note books, Data science services up within Azure Synapse Analytics, is this as cost effective as setting them up as external ...Proposed | 1 Replies | 239 Views | Created by Debbie Edwards - Thursday, December 5, 2019 10:36 AM | Last reply by NavtejSaini-MSFT - Thursday, December 5, 2019 6:40 PM -
0 Votes
Azure Synapse Analytics Questions - best practice and Logic Apps
You can now do all your ETL Processing etc within the one service. Whats the best practice? If you use a Warehouse does that mean everything should be within the one service? What ...Proposed | 1 Replies | 239 Views | Created by Debbie Edwards - Thursday, December 5, 2019 10:35 AM | Last reply by NavtejSaini-MSFT - Thursday, December 5, 2019 6:40 PM -
0 Votes
Azure Synapse Analytics Questions - Data Lake
Another Azure Synapse Analytics Question If you use a data Lake outside of Azure Synapse Analytics service, can you still add it and look at the data against your data warehouse ...Proposed | 1 Replies | 221 Views | Created by Debbie Edwards - Thursday, December 5, 2019 10:31 AM | Last reply by NavtejSaini-MSFT - Thursday, December 5, 2019 6:40 PM -
0 Votes
Azure Synapse Analytics Questions - Data Warehouse
Another Azure Synapse Analytics Question IS it OK to simply use this as the data warehouse and have all the other services as separate services? Or are you paying for ...Proposed | 1 Replies | 255 Views | Created by Debbie Edwards - Thursday, December 5, 2019 10:30 AM | Last reply by NavtejSaini-MSFT - Thursday, December 5, 2019 6:39 PM -
0 Votes
Not able to use Synapse Analytics service
Hi, MS has recently launched Synapse Analytics service its in preview stage. I want use it I have registered for preview I got a response from MS team as well but contents of that mail are not ...Answered | 12 Replies | 843 Views | Created by Aayush3195 - Monday, November 18, 2019 6:35 AM | Last reply by Vaibhav-Chaudhari - Thursday, December 5, 2019 5:32 PM -
1 Votes
Migration Strategy: Restoring a SQL Server 2016 backup from an on-prem data warehouse to Azure Data Warehouse.
I have a 200GB Sql Server backup file given to me by a vendor - (really 50 backup files of 4GB each, not sure why they did it this way). I want to restore the backup files to an existing Azure ...Answered | 4 Replies | 356 Views | Created by mschandler - Tuesday, December 3, 2019 3:13 PM | Last reply by mschandler - Thursday, December 5, 2019 2:33 PM - Items 1 to 20 of 606 Next ›
Azure SQL Data Warehouse announcement
-
Link
We are excited to announce the general availability of Azure SQL Data Warehouse in four additional regions—North Europe, Japan East, Brazil South, and Australia Southeast. These additional locations bring the product worldwide availability count to 18 regions – more than any other major cloud provider.
Read More Here!
