Azure SQL Database
An Azure relational database service.
5,608 questions
4 answers
One of the answers was accepted by the question author.
How we can add week days like Monday , Tuesday so on and time with it.
This query shows week by week data collection, But how we can add week days like Monday , Tuesday so on and time with it. Declare @beginDate int = 0; Declare @pendDate int = 1; CREATE TABLE #Test(WeekStart varchar(15), WeekEnd varchar(15)) …
1 answer
One of the answers was accepted by the question author.
Use Autonomous Transaction in Azure SQL Database
Hello, I need to replicate Oracle's autonomous transaction in Azure SQL Database. I know I can use CLRs in SQL On-premise and Azure SQL Database Managed Instance, but I have a requirement to work on Azure SQL Database and CLRs are not supported in…
asked 2020-09-30T14:10:36.84+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, 71%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
G Cocci
211
Reputation points Microsoft Employee
commented 2020-10-01T20:34:37.787+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Batch: execute Java processes
I'm looking at Azure Batch in order to let it executes on a distributed pool of VMs a set of Business Rules. I've seen that there is a Java SDK but it's not clear where I've to put "my business logic". I've seen that Java SDK let me define and…
asked 2020-09-24T14:21:28.233+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(60.8, 50%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Roberto Sidoti
21
Reputation points
accepted 2020-10-01T19:41:31.49+00:00
Roberto Sidoti
21
Reputation points
1 answer
Changing the Azure SQL db master db compatability level
Hello, Are there potentially adverse results from changing and Azure SQLdb's master databases compatibility level? Thanks Frank
asked 2020-09-23T18:08:25.013+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(172.8, 0%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFC%3C/text%3E%3C/svg%3E)
Frank Canapa (RAPP)
1
Reputation point
commented 2020-10-01T15:50:14.333+00:00
Frank Canapa (RAPP)
1
Reputation point
1 answer
Azure SQL Features for Standard and Premium in DTU model and GP and Business Critical in vCore based purchasing Model
I would like to know whether the features mentioned in the below URL are same for both Standard and General purpose service tiers under the two purchasing models namely DTU and vCore. …
asked 2020-09-28T23:50:50.343+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(0, 7.000000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Pallab Chakraborty
401
Reputation points
commented 2020-10-01T13:02:06.013+00:00
Pallab Chakraborty
401
Reputation points
2 answers
One of the answers was accepted by the question author.
Is it possible from Azure SQL database hosted in one subcription to query Azure SQL Database hosted in different subcription under same tenant?
Is it possible from Azure SQL database hosted in one subscription to query Azure SQL Database hosted in different subscription under same tenant?
asked 2020-09-30T12:49:26.78+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(128, 49%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Amol Pawar
21
Reputation points
accepted 2020-10-01T09:43:39.927+00:00
Amol Pawar
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Failure to notify user of completed Job
Hello. I'm using Windows 2016 and MS SQL Server Management Studio 18.6 I created a Job and want to be notified when it completes. I created Mail account and profile. Email Test works fine. I created a Job for backup. In Job 'properties' I selected…
![](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(294.40000000000003, 94%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
Always on 2012 on windows 2012 on azure vm
Hi support May I know windows 2012R2 sql 2012 always on support on azure vm? Can use azure shared disk as fsw(cloud witness is not support in windows 2012)?
asked 2020-09-26T06:19:33.373+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(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,326
Reputation points
commented 2020-09-29T15:09:06.307+00:00
Shashank Singh
6,251
Reputation points
1 answer
CI/CD Implementation for AZURE SQL DB in Azure DevOps
Hi Team, I want to implement CI/CD Process for Azure SQL Database.As i have implemented for Azure Data factory,But i don't have any idea about CI/CD process for Azure SQL database.Could you please someone help me out to implement this if anyone has…
asked 2020-09-10T07:03:14.48+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(169.60000000000002, 98%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
pankaj chaturvedi
86
Reputation points
commented 2020-09-29T12:36:31.27+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,606
Reputation points
2 answers
Can't open SQL Server Management Studio 18 - "MRU Package did not load correctly" and "Cannot create the window"
This issue is driving me crazy. I can't open SQL Server Management Studio (SSMS) 18. When I try to open it I get the follow things: Starts fine with the small window that says "Microsoft SQL Server Management Studio v18.6"... But then I…
asked 2020-09-20T03:48:48.1+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(0, 52%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kurka
1
Reputation point
commented 2020-09-29T12:28:18.93+00:00
Anurag Sharma
17,606
Reputation points
2 answers
How to convert this query to 52 weeks rolling based data.
I have CTE which is quite manual so everytime I have to change week number and days thing in this query. With CTE_Deprivation_Live20 As ( Select m.PeopleID ,DateDiff(yy,P.DateOfBirth,GetDate()) as Age, m.LocationName,m.ActiveStart,m.ActiveEnd, …
asked 2020-09-28T02:51:48.833+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(44.800000000000004, 46%, 14%)' 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)
RXR
121
Reputation points
commented 2020-09-29T08:23:32.11+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,581
Reputation points
1 answer
One of the answers was accepted by the question author.
Entity Framework automatically creates database when it doesn't exist
We have a problem that is unfortunately costing us alot of money. We are using MVC 5 with Entity Framework 6. Our problem is, if we are using a database that doesn't exist, it will create it, but it creates a General Purpose Gen5 database. As we usually…
asked 2020-09-21T06:51:29.73+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, 84%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Søren Pedersen
21
Reputation points
accepted 2020-09-29T07:42:36.44+00:00
Søren Pedersen
21
Reputation points
3 answers
One of the answers was accepted by the question author.
What is the OS used by Azure SQL
We are in the process of certifying our product with Azure SQL as back end. Considering our entire product being hosted on AKS , Linux based VM , would like to know the OS type of Azure SQL.
asked 2020-07-27T06:35:45.963+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-29T05:22:13.823+00:00
Honey Nadackal
126
Reputation points
1 answer
One of the answers was accepted by the question author.
Are Instance Pools and Elastic Pools same when it comes to Azure SQL PaaS?
Are Instance Pools and Azure SQL Elastic Pools same thing when it comes to Azure SQL PaaS ? In the video https://www.youtube.com/watch?v=aRwJGaB3zsA it mentions about Instance Pool, so i would like to know if it is same as Elastic Pool or not. Thanks
asked 2020-09-26T01:04:47.093+00:00
Pallab Chakraborty
401
Reputation points
accepted 2020-09-28T19:22:28.04+00:00
Pallab Chakraborty
401
Reputation points
2 answers
One of the answers was accepted by the question author.
How to bind database to new TDE Cert?
This is the code I use for the binding to new cert. USE [AGplaceholder] GO ALTER DATABASE ENCRYPTION KEY ENCRYPTION BY SERVER CERTIFICATE NEWTDECert; GO From this Updating an expired SQL Server TDE certificate article. However, it's not working when…
asked 2020-09-28T12:40:20.737+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, 3%, 36%)' 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)
CharlieLor
556
Reputation points
accepted 2020-09-28T17:54:25.837+00:00
CharlieLor
556
Reputation points
1 answer
Azure machine learning - Trying to use an analytical function from SQLite results in error
When trying to use the LAG function from SQLite on an Apply SQL Transformation module from Azure Machine Learning designer results in a error, saying the sintax near "(" was wrong. The SQL code: select t1.id, t1.veiculo, lag(t1.id)…
asked 2020-09-24T19:59:36.63+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, 43%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFF%3C/text%3E%3C/svg%3E)
Felipe Fritzen
1
Reputation point
commented 2020-09-28T13:43:09.237+00:00
Felipe Fritzen
1
Reputation point
3 answers
Unable to correctly pass parameter to command parameter in Azure Elastic job stored procedure [jobs].[sp_add_jobstep]
Dear Experts, I have this on premise job which purges data weekly on my database. I have replicated similar job using Elastic job agents for Azure SQL DB. The syntax for the job script is below. I see that the job is not running on Elastic job agents…
asked 2020-09-24T12:11:44.9+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(124.80000000000001, 54%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
mo boy
396
Reputation points
commented 2020-09-28T05:20:49.943+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(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Monalv-MSFT
5,896
Reputation points
1 answer
Azure Managed Database Backup Reporting
We've setup a Managed database in a SQL Managed Instance and we need to report on the backup status. I appreciate that backups are a mixture of full, incremental and transaction logs, but we need some form of reporting to indicate when a backups are run.…
asked 2020-09-17T14:14:47.903+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(224.00000000000003, 73%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKI%3C/text%3E%3C/svg%3E)
Kevin I
1
Reputation point
commented 2020-09-25T22:09:58.55+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
What is the PERSISTED_VERSION_CLEANER process?
I would like to know about this process: What is its purpose? When is it running? What does it perform? Why does it use a lot of CPU&DATAIO? I cannot find any documentation about PERSISTED_VERSION_CLEANER.
asked 2020-09-16T06:28:18.523+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(118.4, 40%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Роман Губ'як
11
Reputation points
commented 2020-09-24T12:57:19.927+00:00
Роман Губ'як
11
Reputation points
11 answers
One of the answers was accepted by the question author.
how can a row version be less than a previous one in a later insert in a later batch
Hi we run 2014 developer where this occurred. i'm looking at evidence that a row version in my most recent set of inserts has a lower value than that of an insert from a previous batch. i thought that was impossible. arent row versions always…
asked 2020-09-22T21:19:50.85+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(41.6, 70%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
db042190
1,516
Reputation points
answered 2020-09-24T06:59:10.63+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(217.60000000000002, 21%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Simon Sabin
1
Reputation point