Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
0
votes
1 answer

Custom Rank Calculation by a percentage range

I have this requirement of calculating a custom rank. I need to calculate Annualized % Return for all the 6 companies. I get rank from their return %. Let's consider this as input data. Now I need to calculate Custom Ranking where if another…
ITNube
  • 31
  • 5
0
votes
1 answer

How to create a user who has ReadOnly access in the Database but has ALL privileges on the schema in the Database?

I am trying to create a user who can select all tables within a DB in AzureSQL. but has privileges to Insert,delete, update on his own schema(ODS) within the DB?
Gokul Krishnan
  • 1
0
votes
1 answer

Is there a kind of log on Azure SQL Server to check when some function was created/dropped?

Some functions that I created on my Azure SQL Server database suddenly disappeared, is there some way (some kind of log) where I can check when it happened (maybe also who did that too)?
Ygor Alberto
  • 41
  • 6
0
votes
1 answer

Apply different Adjustment Factor for different date range

I have a Table with SalesPerson and Sales for different dates. I have another table where I have SalesPerson and multiple date ranges where different Adjustment factor needs to be applied. I can do this with a case statement when there is one or no…
ITNube
  • 31
  • 5
0
votes
2 answers

How to get a subscription ID of a different subscription (not the subscription that you are deploying to) in the ARm template?

I am trying to setup auditing for the SQL server in Azure and for the same, I need to send the logs to an Event Hub which is not in the same subscription as the SQL server. I am trying to do add this to the SQL server ARM template, however, I do not…
Akash Masand
  • 1,441
  • 14
  • 30
0
votes
1 answer

Getting error for HierarchyId while fetching the data from another server and inserting it into my server c#

Error is The type of column 'MemberHId' is not supported. The type is 'SqlHierarchyId'. In both the server the datatype is same "HierarchyId". I am just using the ADO.Net. The assembly is Microsoft.SqlServer.ManagedDTS version- 13.0.0.0 We are…
Rajiv Bansal
  • 45
  • 1
  • 8
0
votes
1 answer

Trouble with update nuget Microsoft.Azure.Management.Sql from version 0.5 to version 1.33

We use nuget Microsoft.Azure.Management.Sql (version 0.5) in our project. But I have updated the version 0.5 to version 1.33 (last version on the current time). And I have a troubles with some models and methods: Class RecommendedAction from…
Alexander I.
  • 2,380
  • 3
  • 17
  • 42
0
votes
1 answer

SSMA. Connect to Azure SQL Database Managed Instance to migrate from MySQL to Azure SQL

I just started using SSMA with the aim to migrate data from a MySQL server to my own Azure SQL database to work with the data in an Azure Logic app, which does not support MySQL very well. My idea is to run the an SSIS package to migrate data…
JohanLarsson
  • 475
  • 1
  • 8
  • 23
0
votes
1 answer

How to configure the alert whenever the primary Azure SQL Database goes down?

In Azure, how can you configure an alert or email notification when a SQL Server failover happened whenever you have setup a SQL server with Failover groups and failover policy is set to automatic? So, can anyone suggest me how to configure the…
Pradeep
  • 5,101
  • 14
  • 68
  • 140
0
votes
0 answers

Error -Login failed for user 'XXXX' azure SQL server database

I have a Python 3.6 Django azure web app, i am using Azure sql server database. For few months the user gets the following error: ('28000', "[28000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Login failed for user 'XXXX'. (18456)…
Nir Elbaz
  • 556
  • 4
  • 19
0
votes
1 answer

Restore to Azure SQL PAAS database a bak file?

Okay so I figured since Azure has a lot of tools and I am failing at best processes to just ask on SO. What I can do: BACPAC creation Creation is directly from SSMS with hovering over the database in Object Explorer. Right Click>Tasks>Export Data…
djangojazz
  • 14,131
  • 10
  • 56
  • 94
0
votes
1 answer

Get distinct rows based on one column with T-SQL

I have a column in the following format: Time Value 17:27 2 17:27 3 I want to get the distinct rows based on one column: Time. So my expected result would be one result. Either 17:27 3 or 17:27 3. Distinct T-SQL uses distinct on multiple…
Jouke
  • 459
  • 1
  • 7
  • 20
0
votes
3 answers

In Azure, how can you configure an alert or notification when a SQL Server failover happened?

In Azure, how can you configure an alert or notification when a SQL Server failover happened if you setup a SQL server with Failover groups and failover policy is set to automatic? If it can't be setup in Monitor can it be scripted elsewhere?
CKelly
  • 71
  • 5
0
votes
0 answers

Full text index not getting updated on Insertion of new records (Azure SQL Server 2017)

I have used full text index on two columns of one table. After applying, full text index applied on all the existing rows. So I am able to search through all the records using Contains. Then I have added one record into table but full text index…
Vivek Patel
  • 1,028
  • 1
  • 10
  • 22
0
votes
1 answer

Powershell script to create security groups in Azure Active Directory to manage access to Azure SQL

Below is a script that creates groups in Azure AD and then assigns SQL roles to the groups. The script has a dependency on ODBC 17 and sqlcmd utility version 15 and this makes it a bit hard to use in an Azure devops pipeline. I was wondering if…
Dries Venter
  • 31
  • 2
1 2 3
…
36 37