Azure SQL Database
An Azure relational database service.
5,338 questions
1 answer
One of the answers was accepted by the question author.
Copy to Azure Postgresql with upsert
I want to copy from data lake to azure database postgresql using upsert option, is that possible? I don't want to truncate or remove records, to insert or update if they exist. If not, what are my other options?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 85%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 42%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Activate Sandbox
I can't activate sandbox on this unit When I try to activate I don't receive phone verification code, and now I get Disallowed phone number. Any help with this?
asked 2020-11-23T07:58:36.683+00:00
mohammed ahmed
26
Reputation points
accepted 2020-11-24T11:53:20.673+00:00
mohammed ahmed
26
Reputation points
1 answer
One of the answers was accepted by the question author.
Handshake fails trying to connect from Azure Databricks to Azure PostgreSQL with SSL
We're trying to connect to an Azure Database for PostgreSQL flexible server from Databricks using the jdbc driver org.postgresql.Driver. Since the flexible server enforces SSL, we added the ssl and sslmode options to our existing code: driver =…
asked 2020-11-21T12:23:57.117+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 71%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
Tobias Himmighöfer
21
Reputation points
commented 2020-11-24T07:08:31.24+00:00
PRADEEPCHEEKATLA-MSFT
84,051
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Postgres AD Authentication
We are looking at having multiple databases in a Single Server setting on Azure Database for Postgres SQL. Per documentation Customers can manage database permissions using external (Azure AD) groups. Azure AD authentication uses…
asked 2020-11-16T18:27:59.463+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 55.00000000000001%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Raj Patrao
21
Reputation points
accepted 2020-11-19T01:58:44.88+00:00
Raj Patrao
21
Reputation points
1 answer
AZURE APP, AZURE POSTGRESQL, EMAIL
I have .net app deployed on azure web app, connected with azure postgres db. I push SAP BW data into azure postgres using azure data factory. Data processed in db and final processed/ not processed output is stored in db table. I want to trigger…
asked 2020-11-11T10:52:48.123+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 41%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Charmi
1
Reputation point
answered 2020-11-12T11:38:33.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
Creation of PostgreSQL replica server after point-in-time restore fails with timeout
Sorry, I couldn't find any place to report this issue. Please correct me if there is more suitable resource for Azure bugs. Preconditions We have Azure PostgreSQL server X with replica server Y. In case of emergency with Azure PostgreSQL server X…
asked 2020-10-21T19:42:10.477+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 64%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPO%3C/text%3E%3C/svg%3E)
Pavel Ottens
1
Reputation point
commented 2020-11-11T02:25:09.097+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
0 answers
bulding cte to aggregate different columns and using pivot
Hi All, Need some help/feedback on best way to approach this table: I'm trying to show a company with 1 client And for that clients how many solo interviews were conducted on their behalf And for those that required group_interviews :…
asked 2020-10-30T21:18:53.447+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 24%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
fk_inprocess
1
Reputation point
commented 2020-11-04T09:36:36.657+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EchoLiu-MSFT
14,576
Reputation points
2 answers
One of the answers was accepted by the question author.
calculating 2 dates within the same column based on condition
Hi All, I have the following table call chek_Status: This table tracked daily the client and shows them if they are on yearly, monthly or weekly subscription plan. It also shows if they are new new business (when they sign up) to when they cancel or…
asked 2020-10-22T18:53:05.843+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 15%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
learning_step_by_step
61
Reputation points
accepted 2020-10-22T21:58:38.09+00:00
learning_step_by_step
61
Reputation points
1 answer
How to add Azure devops to Azure Postgres database firewall
I have a firewall in place but I try to run migration from Azure Devops but this is blocked due to the restrictions of the firewall, how can i allow Devops in my firewall
asked 2020-10-15T19:37:56.067+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 66%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
rebirthtobi
1
Reputation point
answered 2020-10-19T08:29:23.603+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
How to scale down vCores on PSQL server on Japan East?
We have a few PSQL databases running on Azure's Japan East location. We are looking to reduce costs of our services, but unfortunately when trying to adjust the settings of the resource we are given the message: "This subscription is restricted from…
asked 2020-10-14T09:35:54.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 89%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Robert Davenport
1
Reputation point
answered 2020-10-14T21:17:41.49+00:00
Manishk-MSFT
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Create a new columns that shows the count based on 2 other columns
I have the following table called call_logs sqlfidle: http://www.sqlfiddle.com/#!18/57b3a/1 Date call_time call_duration 2001-10-01T00:00:00Z 60 30 2001-10-01T00:00:00Z 60 15 …
asked 2020-10-08T22:49:15.917+00:00
learning_step_by_step
61
Reputation points
accepted 2020-10-09T15:31:08.517+00:00
learning_step_by_step
61
Reputation points
1 answer
Azure Postgres - Pricing calculation for Backup retention period of 14 days
Backup retention period for Azure database for Postgres is 7 days by default. What is the cost if we increase to14 days . The pricing calculator website does not give option to calculate for this. …
asked 2020-10-01T15:10:26.347+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 71%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
MS Techie
2,686
Reputation points
commented 2020-10-07T17:50:25.823+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
Error with CTE when it doesnt recognize the table
I'm trying to run this query, but unfortunately I keep getting the error of "first_table" doesn't exist. Is there a way to fix this. I've tried every scenario i could think of and still nothing. any help willl be very helpful with first_table…
asked 2020-10-01T20:13:45.437+00:00
learning_step_by_step
61
Reputation points
commented 2020-10-06T00:04:38.88+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
In Azure Postgres , does the latest offering of "Flexible server (Preview)" support certificate authentication
In Azure Postgres , does the latest offering of "Flexible server (Preview)" support certificate authentication Can i get the pricing link for this flexible server. Please advise.
asked 2020-10-01T10:49:06.937+00:00
MS Techie
2,686
Reputation points
answered 2020-10-05T11:38:40.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma
17,586
Reputation points
1 answer
One of the answers was accepted by the question author.
Failed to connect to Azure PostgreSQL with SSL enabled from AzureDataStudio
When i try to connect to Azure PostgreSQL with SSL enabled using AzureDataStudio , with SSL Mode=Verfiy-full, i get below error root certificate file "C:\Users\mstechie\AppData\Roaming/postgresql/root.crt" does not exist Either provide…
1 answer
Certificate rotation using azure's pgbouncer docker image
We use the pgbouncer docker image and want to know whether this image has been updated to contain the new certificate Cert rotation: https://video2.skills-academy.com/en-gb/azure/postgresql/concepts-certificate-rotation#what-update-is-going-to-happen …
asked 2020-09-21T06:29:19.713+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 5%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Brendan
1
Reputation point
commented 2020-10-02T02:01:45.787+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
2 answers
DevOps for Azure Database for PostgreSQL
Is there any Azure DevOps option to configure CI CD for Azure Postgres Database PaaS option ? Please help
asked 2020-09-25T17:12:24.963+00:00
MS Techie
2,686
Reputation points
commented 2020-09-30T04:18:41.36+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
One of the answers was accepted by the question author.
Does the PaaS offering from Azure , that is Azure PostgreSQL support custom certificate?
https://video2.skills-academy.com/en-us/azure/postgresql/concepts-ssl-connection-security From the above Microsoft URL , i can see that Azure PostgreSQL supports having an SSL certificate , in connection string. Eg: psql "sslmode=verify-full…
asked 2020-09-18T06:51:03.213+00:00
MS Techie
2,686
Reputation points
commented 2020-09-29T17:27:56.457+00:00
Anurag Sharma
17,586
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure PostgresSQL hyperscale citus - Modify the password policy
We are moving Azure postgres single server instance to hyperscale mode. On hyperscale postgres , as per documentation roles need to be created from portal .I need clarification on following 1)Is it possible to create user / role from psql 2)Is there…
asked 2020-09-17T11:17:56.417+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 96%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHN%3C/text%3E%3C/svg%3E)
Honey Nadackal
126
Reputation points
accepted 2020-09-29T04:55:59.7+00:00
Honey Nadackal
126
Reputation points
1 answer
Azure PG edit pg_ident.conf
I was wondering if it was possible to edit the pg_ident.conf file. I am hoping that a mapping will resolve the issue our application is having with the @hostname. I want to avoid changing the code. I can currently connect to Google PostgreSQL…
asked 2020-09-23T16:30:29.487+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 75%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Michelle Schwan
1
Reputation point
commented 2020-09-28T18:10:38.287+00:00
Mike Ubezzi
2,776
Reputation points