All Questions
Tagged with azure-sql-managed-instance sql
20 questions
-2
votes
1
answer
97
views
SQL query to group parameters into same column where ID is the same
I am trying to write a query that will groups several columns under one main column type called parameters instead of creating a record per parameter.
This what I currently have in my table called ...
1
vote
1
answer
107
views
sql: how to find consecutive dates where condition is met in aggregate
I am working in Azure SQL MI. I am struggling with a certain SQL query. I have a "timesheet" table like the following:
EmployeeID DateWorked LaborType Hours
-----------------------...
- 2,113
0
votes
1
answer
953
views
Resolve performance problem in recursive CTE
I have a dimensional (star schema) data model that supports BI on labor data. It includes an employee dimension table. This table is a type 2 slowly-changing dimension table, i.e., it stores history ...
- 2,113
2
votes
2
answers
224
views
Merge two XML columns in SQL Server
Hope, someone out there can help me with SQL Query, I am trying to merge two XML column, I am currently using SQL Azure 2019.
First XML
<HOME>
<VALIDITYLIST>
<VALIDITY STATE=...
0
votes
1
answer
804
views
Linked Server on SQL Server Managed Instance
I have SQL Server Managed Instance. Now I want to get data from on-premises SQL Server to SQL Server Managed instance through linked server on a daily basis.
The on-premises SQL Server has only ...
- 34
0
votes
0
answers
331
views
Azure SQL Managed Instance Drop/Deletion Event logs
We have an Azure SQL Managed Instance having number of databases on it . We have to enable audit logs of SQL Managed Instance from diagnostic settings and also enabled logs by executing queries on MI ...
- 109
0
votes
1
answer
353
views
Scheduled SQL Server backup ultimately restored to Azure SQL
I have been working in on-premises SQL Server since 1999 and am now trying to engage with Azure SQL.
I have identified one of our SQL DBs that we want to lift into Azure for reporting. (We will be ...
- 439
2
votes
1
answer
367
views
How to make SQL Server use the Olson time zones instead of Windows ones by default
I'm trying to make my SQL Server use the Olson time zones instead of the Windows ones.
The web doesn't really give an answer on how to do it and make it system wide.
I don't know if that's possible to ...
- 135
0
votes
2
answers
1k
views
Cannot Create Contained Database on Azure SQL Managed Instance
In my Azure SQL Managed Instance, I'm unable to create CONTAINED databases and use ordinary logins and passwords with them (not Azure AD users).
In SSMS > New Database > Options, the Containment ...
- 3,613
0
votes
1
answer
724
views
Update and delete queries are taking longer to run in Azure managed instance
I am in the process of migrating a data warehouse to Azure from our on premise solution. The nightly load process for the on premise solution takes between three and four hours to run depending on ...
- 75
1
vote
2
answers
4k
views
SQL Server job error on email notification
I have configured a database email, operators, and such on my SQL managed instance, to receive an email when a job fails.
In the email, we get something like this "The yyy_job failed on step 3&...
- 771
0
votes
0
answers
576
views
SQL bulk insert csv with currency sign separator ¤
I have a .csv file with a currency sign field separator (¤), when I execute this query to bulk load it to a table it raise an error.
The file is UTF-8 encoded.
BULK INSERT dbo.test
FROM 'file.csv'
...
- 105
0
votes
0
answers
136
views
SQL Managed Instance Making Connectivity Easier for Users
So we just switched to SQL Managed Instnace. As much as it pains me, we had more than a few places where untrained users were querying our production database(s). The switch to a business critical SQL ...
- 167
1
vote
2
answers
6k
views
How do I connect Power BI to my Azure SQL Managed Instance on an Azure VNET?
I have an Azure SQL Managed instance with public endpoint disabled (we store sensitive data and do not want an exposed endpoint on the DB). We have a VNET and when we need to access our SQL managed ...
- 97
0
votes
1
answer
168
views
Azure SQL Does not allow login for Created Clients
I created several users for Azure SQL using the free acccount in a database in Azure Data Studio following the recommended procedure:
add client ip addresses to firewall
create login on the master ...
- 1,033