Questions tagged [azure-sql-server]

548 questions
-1
votes
1 answer

Can you drop Azure SQL Tables from Azure ML?

I am currently developing an Azure ML pipeline that is fed data and triggered using Power Automate and outputs to a couple of SQL Tables in Azure SQL. One of the tables that is generated by the pipeline needs to be refreshed each time the pipeline…
-1
votes
1 answer

Azure data factory: data migration from Oracle 12g to Azure SQL server

I am asked to migrate the existing on premises Oracle to Azure SQL server using Azure data factory. I have no prior experience with Azure data factory especially on data migration . Is there any articles out there to explain the end to end migration…
-1
votes
1 answer

How do Azure SQL scaling features change schema design?

In other words, how should schema design in Azure SQL differ from schema design for SQL on VM or hardware? What additional factors should the DBA consider when designing schemas for Azure SQL databases and managed instances? In order to narrow the…
-1
votes
1 answer

ResourceMoveProviderValidationFailed Error

while moving VM from one resource group to another this error encountered while there is no SQL VM associated with VM still getting this error { **"code": "ResourceMoveProviderValidationFailed",** "message": "Resource move validation failed.…
-1
votes
2 answers

Single SQL query to find null values in all columns in a data base

I would like to identify the number of null values in each column in all tables.I have a data base it consist of around 250 tables.Most of them are in use.The problem is almost all tables contain unwanted columns which created for some short term…
Eldho Baby M
  • 115
  • 1
  • 3
  • 13
-1
votes
1 answer

How to calculate local time based on GMT?

I am trying to figure out the local time for various countries based on the GMT time data I have for them. I would also need to know if any of them observe Daylight Savings Time as well. Is there a way to achieve this without CLRs? Here is some…
-1
votes
1 answer

Maximum number of consecutive trading holidays from a date/calendar table

I am trying to find the maximum number of consecutive trading holidays from a Trading date/calendar table. I have a flag isTradingHoliday = 1 in the TradingDate table that denotes the dates which are trading holidays, otherwise isTradingHoliday = 0.…
ITNube
  • 31
  • 5
-1
votes
2 answers

Time zone to work on both Azure SQL and Pre-SQL 2016

I'm currently migrating my system to Azure SQL so I need to convert the time zone from the UTC standard to the local time zone when using GETDATE(). This is straight forward with 'AT TIME ZONE..', however we also have a couple of clients who host…
-1
votes
1 answer

Running Average of 3 Days Trading and then Populate that Value for Trading Holidays

I have a table with Data for Different Companies and Closing Price for Trading Days. I need to calculate a 3 Day Running Average for every Company. I need to then join with a calendar table to populate Close Price and Avg3DayClosePrice for all dates…
ITNube
  • 31
  • 5
-1
votes
1 answer

SQL for Dates with no ClosePrice for all companies

I have a fact table where I have ClosePrice for Company Tickers and TradingDates. I also have a dimCalendar table where all dates are there and a flag is maintained for Trading Holidays. Somehow I need to have a new fact table or materialized view…
ITNube
  • 31
  • 5
-1
votes
1 answer

Azure SQL takes a very long time to run SELECT * FROM INFORMATION_SCHEMA.TABLES

I tried to use Azure SQL Database with Tableau for visualizing data. First issue was that Tableau takes a huge time on connecting to db on start (about 10-30 minutes). After connecting it works fast. I provided some investigations and determined…
-1
votes
1 answer

cannot connect to SQL with managment studio

I created a virtual machine with SQL in Azure. but I can't connect with management studio (SSMS) from out of my VM any idea?
-1
votes
4 answers

Produce a per customer per month sales report via SQL eg group by two columns and sum the third

I rarely write SQL (Azure SQL) however I am trying to generate a per month sales total per customer. Customer: |Username |ID | |user1 |1 | |user2 |2 | |user3 |3 | Order: |CustomerId …
rollsch
  • 2,518
  • 4
  • 39
  • 65
-1
votes
1 answer

How to migrate to a non-SQL Server virtual machine

I provisioned an Azure VM with SQL Server pre-installed on Azure, but the decision has been made to re-install SQL Server with a different license. According to Azure documentation that means that I need to "deploy a new virtual machine and migrate…
Qwelm
  • 33
  • 6
-1
votes
1 answer

Can you not add a DB user to an Azure SQL instance from the portal?

It's the year 2017, I'm wondering if you can you add a DB user to an Azure SQL instance from the portal? Or?
arcom
  • 612
  • 4
  • 11
  • 18
1 2 3
36
37