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 | 3272 Views | Created by Ellis Hiroki [MSFT] - Friday, September 16, 2016 10:00 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 ...Unanswered | 4 Replies | 164 Views | Created by Debbie Edwards - Thursday, December 5, 2019 10:28 AM | Last reply by Debbie Edwards - 5 hours 2 minutes ago -
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 | 545 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 | 105 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 | 615 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 | 120 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 | 107 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 | 109 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 | 99 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 | 91 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 | 98 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 | 506 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 ...Unanswered | 4 Replies | 176 Views | Created by mschandler - Tuesday, December 3, 2019 3:13 PM | Last reply by mschandler - Thursday, December 5, 2019 2:33 PM -
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 ...Unanswered | 2 Replies | 138 Views | Created by Kuharan Bhowmik - Monday, December 2, 2019 5:16 PM | Last reply by Kuharan Bhowmik - Tuesday, December 3, 2019 5:24 AM -
0 Votes
How do I perform an UPSERT task in SQL DW?
I am trying to create a ADF pipeline to load my incremental data in dw_publish table of sql dw. To do that I have connected to storage account for the source which is in csv. Next I am using a copy ...Proposed | 3 Replies | 272 Views | Created by Kuharan Bhowmik - Friday, November 29, 2019 12:10 PM | Last reply by Vaibhav-Chaudhari - Monday, December 2, 2019 6:39 PM -
0 Votes
SnapshotCM to TFS migration
Hi All, One of our client wants to migrate SnapshotCM to TFS. I searched in internet, but didn't find any links or document. Is it ...Proposed | 1 Replies | 215 Views | Created by Mukesh Venkatesh - Friday, November 22, 2019 7:58 AM | Last reply by Mike Ubezzi (Azure) - Friday, November 22, 2019 10:17 PM -
0 Votes
Error Number: 18456 encountered while connecting from SSMS for a newly created user
I created a user in a SQL DW using below commands. Server IP is added to the Azure firewall as well. CREATE LOGIN TEST WITH PASSWORD = ...Proposed | 2 Replies | 225 Views | Created by Lancerique - Thursday, November 14, 2019 11:43 AM | Last reply by Mike Ubezzi (Azure) - Thursday, November 21, 2019 2:45 AM -
0 Votes
Unresolved reference to object sp_executesql in dwh database project
Hi, I am using the (last week released) VS2019 (build 16.3) with a Azure Data warehouse database project. In it I created a stored procedure which uses sp_executesql to execute a ...Proposed | 9 Replies | 556 Views | Created by Thijs Nijhuis (unity) - Thursday, September 26, 2019 8:14 AM | Last reply by NavtejSaini-MSFT - Tuesday, November 19, 2019 4:04 PM -
0 Votes
How to perform the Specify Code/tables backup in SQL dwh?
Microsoft.SqlServer.Management.Smo.UnsupportedVersionException: The 'DwTableDistribution' property is not supported on SqlDatabase edition database of SqlAzureDatabase SQL Server with ...Proposed | 6 Replies | 264 Views | Created by everfor - Monday, November 11, 2019 9:36 AM | Last reply by Vaibhav-Chaudhari - Monday, November 11, 2019 3:07 PM -
0 Votes
Common table expressions followed by INSERT, UPDATE, DELETE, or MERGE are not supported in this version.
1; Msg 104424, Level 16, State 1, Line 1 Common table expressions followed by INSERT, UPDATE, DELETE, or MERGE are not supported in this ...Proposed | 2 Replies | 281 Views | Created by everfor - Thursday, November 7, 2019 4:00 PM | Last reply by NavtejSaini-MSFT - Monday, November 11, 2019 2:29 PM -
0 Votes
oracle to Azure sql Dwh code conversion tool?
We are planning to move from oracle to Azure SQL DWH. is there any tool available to convert the pl/sql code,mviews & views into SQL dwh compatablity?Proposed | 3 Replies | 253 Views | Created by Baba9 - Friday, November 8, 2019 8:37 AM | Last reply by Kalyan Chanumolu-MSFT - Monday, November 11, 2019 3:37 AM - Items 1 to 20 of 599 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!
