Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
2
votes
0 answers

How can I script the Descriptions of Columns in MS SQL Server Management Studio?

I have a table named Assignment in my Azure SQL Server (version 12.0.1400). The table itself, as well as most of the columns, have Description filled in. I've entered those Description values using the Table Designer in SQL Server Management Studio…
Emre Sevinç
  • 8,211
  • 14
  • 64
  • 105
2
votes
1 answer

How to generate records based on preceding rows value change/version history using SQL Server (TSQL)

I have a table where I need to maintain record versioning based on records insertion and update on per day basis. The "RecordVersion" table looks like below: VersionID RecordID RecordValue DateID (FK Calendar) --------- -------- …
Khorshed Alam
  • 314
  • 2
  • 11
2
votes
1 answer

Approach for using Azure VM for SQL

Following is the exact scenario in my application: SQL Server database is hosted on-premise locally in US office for development purpose. Developers are distributed in 3 different regions (US, India and Australia). Developers from India and …
Nirman
  • 6,715
  • 19
  • 72
  • 139
2
votes
2 answers

How create a database in azure elastic pool with entity framework core?

I would like to create a database with entity Framework core that would be automatically added to my azure elactic pool. I do that with a DatabaseFacadeExtension that execute SQL command after the db creation like suggested here: Azure SQL Server…
Kassoul
  • 21
  • 2
2
votes
1 answer

How to check all access rights for specific user in Azure SQL Database?

I have below questions about schema/privilege: May User have multiple DB roles(schema)? What is db_denydatareader used for? (it seems can have different DB roles among databases, right?) What are difference between db_datareader and…
DaiKeung
  • 1,077
  • 1
  • 19
  • 38
2
votes
1 answer

How to delete Azure SQL audit logs using PowerShell?

My Azure SQL Server has been storing the audit logs for over a year, and storage size is in the TBs. I would like to keep the logs for 3 months max and delete the rest, how can I do this using PowerShell? Would setting the RetentionInDays parameter…
Hassan K
  • 23
  • 4
2
votes
1 answer

SQL Deployment with ARM Templates including schema and table (dacpac, PowerShell)

I want to deploy a Azure SQL Database with schema and table using PowerShell, Azure Resource Manager Templates and dacpac. How can I do that?
quervernetzt
  • 10,311
  • 6
  • 32
  • 51
2
votes
1 answer

azure sql DB_ID doesn't work

I have created manually a database called SnapshotsDb in Azure Sql Server via SSMS. Trying to get the ID of the SnapshotsDb using DB_ID() function: DECLARE @db_id int; SET @db_id = DB_ID(N'SnapshotsDb') PRINT @db_id Not output If I try same logic…
Cristian E.
  • 3,116
  • 7
  • 31
  • 61
2
votes
2 answers

Error Migrating SQL Server Database to Azure

So I am completely new to .Net Core development, and was given a codebase that I am trying to host on Microsoft Azure. I have the local database file (.mdf) in SQL Server Management Studio, and am trying to deploy it to an Azure Database, However it…
Kevin Marin
  • 43
  • 4
2
votes
1 answer

Can I script Data Classifications in SQL Azure

I am looking into SQL Data Classifications in SQL Azure. To do this I must log onto the Azure Portal for each database and configure the Data Classifications. I have 100 databases for seperate clients all with the same schema. Is there a way I can…
JKennedy
  • 18,150
  • 17
  • 114
  • 198
2
votes
2 answers

Can I set SQL Azure Vunerability Assesment at a server level instead of database level?

So Recently I found a pretty neat feature where SQL Azure can schedule vunerability assesment scans regularly To configure this you must go onto each database on your server and configure the storage and who you want to receive the reports. Lets say…
JKennedy
  • 18,150
  • 17
  • 114
  • 198
2
votes
0 answers

TCP Keep Alive in windows is running but the program is not affected for Azure SQL

To keep Azure SQL alive MS have provided this workaround , After following this workaround the keep alive messages are sent I traced over wireshark . But still my application is facing Connection Reset after 30 minutes .. I have made a normal…
Arun Kumar G R
  • 178
  • 2
  • 13
2
votes
1 answer

Connect to Azure SQL Server through Azure VPN Gateway

I have an Azure SQL Server & Azure SQL Database, a virtual network with two subnets, a vm and an Azure VPN Gateway. The VM is on Subnet1. Azure VPN Gateway uses GatewaySubnet. In the Azure SQL Server > Firewalls and virtual networks > I have added…
Jeffrey
  • 2,095
  • 3
  • 20
  • 36
2
votes
1 answer

Azure Data Factory V2: Create linked service for Azure Sql server using Azure Active Directory

Creating linked service(Azure Data Factory V2) for Azure Sql supports SQL Authentication. I want to know if it also supports Azure Active Directory Integrated Authentication.
user1612738
  • 131
  • 9
2
votes
1 answer

Is there a limit on how many databases Azure Sql Server (PaaS) can have? And/Or is there a size limit on how much data an Azure Sql Server can hold?

Is there a limit on how many databases Azure Sql Server (PaaS) can have? And/Or is there a size limit on how much data an Azure Sql Server(PaaS) can hold?
Andrew Taylor
  • 72
  • 2
  • 9
1 2 3
…
36 37