Skip to content
IRZU INSTITUTE

IRZU INSTITUTE

Inštitut za raziskovanje zvočnih umetnosti

  • ABOUT
  • EVENTS
    • ARTISTIC
    • EDUCATIONAL
    • INTERVIEWS
    • ONLINE
    • PRODUCTION
  • PRODUCTS
    • DIRECTIONAL AUDIO SPEAKERS
    • BREATHING EXERCISE GAMES
    • VIRTUAL REALITY
    • INTERACTIVE MIDI
    • SMARTDRUMS ANDROID SOFTWARE
    • SMARTGUITARS OPEN SOURCE
    • UNIVERSAL RECORDING CABLES
    • ANDROID TO SHEETS LOGGING
    • ANDROID TO CALENDAR LOGGING
    • WEBCAM LIE DETECTOR OVERLAY
  • RESEARCH
    • OPEN SOURCE BIOLOGY
    • ACOUSTICS & DSP
    • DATA MANAGEMENT
    • ELASTIC & LUCENE
    • FFT & WAVELETS
    • GAME DEVELOPMENT
    • JS, REACT, & NODE
    • KERNEL STREAMING
    • LINUX & ANDROID
    • LOW VOLTAGE IC
    • MEMS SYSTEMS
    • MQTT & IOT AUTOMATION
    • REST/HTTP & GRAPHQL
    • VIRTUALIZATION
    • 3D PRINTING & FABRICATION
  • EDUCATION
    • CRISPR WORKSHOP
    • TASKER WORKSHOP
    • PUREDATA WORKSHOP
    • SMARTDRUMS WORKSHOP
  • POSTDOCS
    • TELEMEDICINE & GAMIFICATION
    • EDC IN CLINICAL TRIALS
    • ARTIFICIAL INTELLIGENCE
  • INTERNSHIPS

Tag: Azure SQL

DATA MANAGEMENT RESEARCH

Is it possible to update the existing Azure SQL Database using bacpac?

September 26, 2023admin

No, it is not possible to restore a bacpac file to an existing Azure SQL database. A bacpac file is a data-tier application package that contains the schema and data…Read moreIs it possible to update the existing Azure SQL Database using bacpac?

RESEARCH

on the Azure Sql Server, why sysdb is created and what is it’s purpose?

September 20, 2023admin

In Azure SQL Database, you don’t have the full suite of system databases that you might expect from an on-premises SQL Server installation (like master, model, msdb, and tempdb). Instead,…Read moreon the Azure Sql Server, why sysdb is created and what is it’s purpose?

DATA MANAGEMENT RESEARCH

Azure SQL / MS SQL Server Administration at Atlantis IT Group

September 5, 2023admin

Azure SQL / MS SQL Server Administration Remote Long Term Responsible for maintaining existing databases with high-availability solutions, replication, backup, restore, encryption, and disaster recovery solutions. Configure & Monitor Performance/Storage/Memory…Read moreAzure SQL / MS SQL Server Administration at Atlantis IT Group

DATA MANAGEMENT RESEARCH

How to avoid duplicate Batch Id’s in a table in Azure SQL db using python and Azure Blob Trigger

August 31, 2023admin

For context, I’ve got files that are uploaded daily to an Azure Storage Container. When files are uploaded at the same time, I have trouble avoiding duplicate Batch Id’s inside…Read moreHow to avoid duplicate Batch Id’s in a table in Azure SQL db using python and Azure Blob Trigger

DATA MANAGEMENT RESEARCH

In production Environment what is better between Azure VM and Azure SQL considering the huge data amount of 1 TB to 2 TB

August 19, 2023admin

Choosing between Azure SQL Database and Azure Virtual Machines (VMs) for a production environment with a large data size (1 TB to 2 TB) depends on several factors, including performance,…Read moreIn production Environment what is better between Azure VM and Azure SQL considering the huge data amount of 1 TB to 2 TB

DATA MANAGEMENT RESEARCH

On Azure, how do I find the ip address of an app service to create a firewall rule for it on Azure SQL?

August 9, 2023admin

I have created an Azure SQL server, setting ‘Allow Azure services and resources to access this server’ to no. I have a. ASP.Net application running as an App Service and…Read moreOn Azure, how do I find the ip address of an app service to create a firewall rule for it on Azure SQL?

DATA MANAGEMENT RESEARCH

Azure Data Factory Copy to Parquet file uniqueidentifier

July 27, 2023admin

Right now I am haunted by a question regarding copying data from Azure SQL to a parquet file using the azure data factory copy-activity. The Azure SQL database conains various…Read moreAzure Data Factory Copy to Parquet file uniqueidentifier

DATA MANAGEMENT RESEARCH

Data Validation after migration from the Azure Data Factory

July 24, 2023admin

Hi, I would be migrating 1.5 TB data from on-premises (Oracle) to the Azure SQL database using the Azure Data Factory (SHIR). Question-1 -Please inform how to perform the data…Read moreData Validation after migration from the Azure Data Factory

RESEARCH

sql server – Pull code from on prem database to create AZURE SQL table including indexes, constraints, keys, etc. using pyspark

June 19, 2023admin

There’s no built-in TSQL api to generate full-fidelity DDL for existing objects. The Sql Server Management Objects (SMO) .NET library is the official component that does DDL generation. So not…Read moresql server – Pull code from on prem database to create AZURE SQL table including indexes, constraints, keys, etc. using pyspark

DATA MANAGEMENT RESEARCH

azure synapse copy -: xml Copying from on-premises to azure data lake having null values for CDATA element

June 18, 2023admin

Hi , We have differnt kpi data in form of xml. During copying these xml to azure data lake , these xml converted into json. Json files are very much…Read moreazure synapse copy -: xml Copying from on-premises to azure data lake having null values for CDATA element

RESEARCH

How to understand collation of INFORMATION_SCHEMA.COLUMNS in Azure SQL Database?

June 13, 2023admin

I try to do this: CREATE TABLE #SourceColumns (Id INT NOT NULL, Field VARCHAR(MAX) COLLATE DATABASE_DEFAULT NOT NULL); insert into #SourceColumns values (1, ‘test’) select * from INFORMATION_SCHEMA.COLUMNS join #SourceColumns…Read moreHow to understand collation of INFORMATION_SCHEMA.COLUMNS in Azure SQL Database?

DATA MANAGEMENT RESEARCH

Which Azure service is recommended to synchronize between Azure SQL databases ?

June 12, 2023admin

Hi everyone, I would like to know which Azure service is recommended to migrate progressively from an old Azure SQL database to a new one ? Most of the tables…Read moreWhich Azure service is recommended to synchronize between Azure SQL databases ?

DATA MANAGEMENT RESEARCH

F&O Export to Data Lake to Azure SQL DB

June 11, 2023admin

Hi everyone, I am asking this question for learning purposes. I have used the Export to Data Lake features to get some tables from F&O into ADLS Gen 2. I…Read moreF&O Export to Data Lake to Azure SQL DB

DATA MANAGEMENT RESEARCH

sql server – Enable Azure SQL DAC (Dedicated Admin Connection)

June 8, 2023admin

This page claims that you can connect to Azure SQL with a Dedicated Admin Connection (DAC but not Data-tier Application): learn.microsoft.com/en-us/sql/database-engine/configure-windows/diagnostic-connection-for-database-administrators?view=sql-server-ver16 The article even goes so far as to specify…Read moresql server – Enable Azure SQL DAC (Dedicated Admin Connection)

DATA MANAGEMENT RESEARCH

azure sql database – Linked Servers and Application Intent

June 8, 2023admin

I’m attempting to improve performance of a set of views that we have on a local server, pulling data from an Azure database. Our system provider advised us to use…Read moreazure sql database – Linked Servers and Application Intent

RESEARCH

c# – Is the singleton approach recommended for Azure SQL DB?

June 8, 2023admin

We are Azure SQL DB. Right now we are creating, open & close connection for every incoming request. Like below on Startup.cs builder.Services.*AddScoped*<IDbConnection>(_ => new SqlConnection(“”)); builder.Services.*AddScoped*<Func<IDbConnection>>(svc => () =>…Read morec# – Is the singleton approach recommended for Azure SQL DB?

DATA MANAGEMENT RESEARCH

Implement a Relational database in Azure SQL database

June 6, 2023admin

In this 1 hour long project based course,you will learn to create an azure account and implement an azure sql database.You’ll get to know various purchasing models and select the…Read moreImplement a Relational database in Azure SQL database

DATA MANAGEMENT RESEARCH

sql server – Azure App Service connecting to SQL Azure gets all connections in pool used intermittently

June 6, 2023admin

I have an application built in .net 6 that runs in Azure as an App Service. It connects to a SQL Azure database to run queries, update data etc. Mostly…Read moresql server – Azure App Service connecting to SQL Azure gets all connections in pool used intermittently

DATA MANAGEMENT RESEARCH

sql server – How should I handle index maintenance on partitioned tables in Azure SQL DB?

June 5, 2023admin

let’s start saying that i have no experience with partitioned tables and i’m not quite sure how to handle index maintenance (Rebuild / Reorganize). Consider my scenario: we have 3…Read moresql server – How should I handle index maintenance on partitioned tables in Azure SQL DB?

RESEARCH

sql server – how to migrate an azure sql database to another subscription within the same tenant

June 2, 2023admin

how to migrate an azure sql database to another subscription in the same tenant Scenario: I have a database server with approximately 600 databases in subscription A , I want…Read moresql server – how to migrate an azure sql database to another subscription within the same tenant

DATA MANAGEMENT RESEARCH

sql server – How to replace all instances of text between two characters in a huge JSON string using T-SQL in an Azure SQL database?

May 29, 2023admin

How to replace text between 2 characters MULTIPLE TIMES in a huge string (50,000 characters) in T-SQL? I have a JSON output from my Azure Pipeline which we drop into…Read moresql server – How to replace all instances of text between two characters in a huge JSON string using T-SQL in an Azure SQL database?

3D PRINTING DATA MANAGEMENT RESEARCH

Unable to setup TDE via Azure SDK for python

May 23, 2023admin

I’m trying to setup transparent data encryption on my Azure SQL server with the help of a customer managed key I have stored on my key vault. I’m doing all…Read moreUnable to setup TDE via Azure SDK for python

DATA MANAGEMENT RESEARCH

Getting started – building an App that takes data and processes it

May 21, 2023admin

Hi Azure Community, I am a complete noobie on here and i am looking to get kick started which i think i will be able to find my momentum. Essentially…Read moreGetting started – building an App that takes data and processes it

3D PRINTING RESEARCH

Azure SQL Connection through ADF having transient failure

May 14, 2023admin

We have build ADF Pipeline where we have a step to connect to Azure SQL and run a query. So the ADF pipeline runs every single day and this step…Read moreAzure SQL Connection through ADF having transient failure

DATA MANAGEMENT RESEARCH

Azure Data Factory Upsert Azure SQL Database Sink

May 11, 2023admin

I am using Copy activity to upsert data into my desitnation table in Azure SQL Database based on primary keys. ADF creates Interim tables in the specified schema which is…Read moreAzure Data Factory Upsert Azure SQL Database Sink

DATA MANAGEMENT RESEARCH

Azure Data Factory “Stored Procedure Activity” causes SQL server deadlock error 1205

May 6, 2023admin

In Azure Data Factory, I have a “Stored Procedure Activity” that executes a stored procedure which updates a single row in a single table in Azure SQL Server database instance…Read moreAzure Data Factory “Stored Procedure Activity” causes SQL server deadlock error 1205

DATA MANAGEMENT RESEARCH

Can not use Query Hints inside Azure SQL

April 28, 2023admin

Hey, In an Azure project we are querying two remote databases and then joining them using an INNER JOIN. The query takes rather long and analysing the query plan with…Read moreCan not use Query Hints inside Azure SQL

RESEARCH

azure sql database – AzureSql/sql server – Concurrent transactions, readlock and updatelock

April 26, 2023admin

I have a transaction where 1. Transaction start 2. I run an update on a row with a given id that is marked currently active and mark it inactive 3.…Read moreazure sql database – AzureSql/sql server – Concurrent transactions, readlock and updatelock

RESEARCH

How do I add an image to Azure SQL Database?

April 24, 2023admin

I’ve been rewriting my database recently and wanted it to be able to accept images. However in case of Azure it’s a lot more tricky, since adding images directly from…Read moreHow do I add an image to Azure SQL Database?

RESEARCH

permissions – attach a database to azure sql

April 23, 2023admin

I would like to attach a .mdf file to my Microsoft Azure SQL database via SQL Server Management Studio, but when I try to right click to the “database” I…Read morepermissions – attach a database to azure sql

ACOUSTICS & DSP DATA MANAGEMENT RESEARCH

asp.net core mvc – Intermittent Azure App Service “hang” issue

April 20, 2023admin

We’re experiencing a strange issue with one of our Azure App Services. At various unpredictable points in the day the app will suddenly appear to hang for around 30-50 seconds,…Read moreasp.net core mvc – Intermittent Azure App Service “hang” issue

RESEARCH

Connection to Azure SQL database is failing with “unable to connect to port 1433” message

April 18, 2023admin

From my machine I am able to connect Azure SQL DB using SQL Server Studio and microsoft libraries. However, When I use a replication software along with the driver provided…Read moreConnection to Azure SQL database is failing with “unable to connect to port 1433” message

DATA MANAGEMENT RESEARCH

how to connect Azure SQL through Azure data factory both are hosted on different resource group

April 17, 2023admin

I am trying to connect Azure SQL through Azure data factory both are hosted on different resource group. I have tried to add the IP address for SQL firewall setup…Read morehow to connect Azure SQL through Azure data factory both are hosted on different resource group

RESEARCH

SQL Server SEQUENCE is resetting itself every few days on Azure SQL.. why?

April 14, 2023admin

I tried to replicate your issue in my environment by creating sequence with below code: CREATE SEQUENCE MySeqName1 start with 1 increment by 1 minvalue 0 maxvalue 5 cycle cache…Read moreSQL Server SEQUENCE is resetting itself every few days on Azure SQL.. why?

RESEARCH

azure – How to update SQL Server table from ADF?

April 14, 2023admin

I need to update the Azure SQL Server table if another SQL Server tables is updated. For example: I have one Azure SQL table dbo.Azuretable and I also have a…Read moreazure – How to update SQL Server table from ADF?

RESEARCH

I need to append multiple table from multiple DB dynamically in same Azure SQL DB Server (Cloud)

April 13, 2023admin

I have 98 database and 352 tables in each database. All the database have same table schema. I have to append dynamically all the tables to a single destination database.…Read moreI need to append multiple table from multiple DB dynamically in same Azure SQL DB Server (Cloud)

RESEARCH

SQL Server to Managed Instance – New managed instance link feature

April 12, 2023admin

I have been looking at the managed instance link feature. Specifically, using the DAG feature to replicate a database on SQL Server 2019 Enterprise Edition, to SQL Managed Instance. I…Read moreSQL Server to Managed Instance – New managed instance link feature

RESEARCH

sql server – SQL Azure table partitioning ,need help to understand how to apply to an existing table

April 11, 2023admin

While trying to optimize access to a table on an Azure SQL Db I found this link. Now the major issues I’ve got are on this table which has around…Read moresql server – SQL Azure table partitioning ,need help to understand how to apply to an existing table

DATA MANAGEMENT RESEARCH

sql server – Copy data between tables considering foreign key relationship

April 11, 2023admin

I tried to use Export option from SSMS which gives an error saying failed due to foreign key relationship. How to copy data between tables(more than 400+) of two different…Read moresql server – Copy data between tables considering foreign key relationship

DATA MANAGEMENT RESEARCH

How to save Relational Data from Azure SQL Server (MS SQL) as a “Document Store” in Azure Cosmos DB for Mongo DB

April 6, 2023admin

I am creating an application and writing data to my centralized database i.e. Azure SQL Server (MS SQL). I want to save this relational data as a “Document Store” in…Read moreHow to save Relational Data from Azure SQL Server (MS SQL) as a “Document Store” in Azure Cosmos DB for Mongo DB

DATA MANAGEMENT RESEARCH

Re: Reports uploaded with terraform – not able to …

March 29, 2023admin

Hi @Arildsen ,   To troubleshoot this issue, there are a few potential solutions to consider:   1.Check the Azure SQL database connection settings: Verify that the connection settings for the Azure…Read moreRe: Reports uploaded with terraform – not able to …

RESEARCH

Pega Upgrade: Need help to understand gaps of Azure SQL Database

March 28, 2023admin

We are currently on-prem with oracle DB Pega 7x and migrating to Azure with Pega 8.7.   We want to use Sql as PaaS in azure but cannot use Azure…Read morePega Upgrade: Need help to understand gaps of Azure SQL Database

RESEARCH

Azure SQL Hyperscale Architecture Concepts and Foundations

March 25, 2023admin

Over the years, many new features and improvements have been continuously developed as part of and alongside the traditional SQL database architecture. As cloud computing platforms began to take prominence…Read moreAzure SQL Hyperscale Architecture Concepts and Foundations

DATA MANAGEMENT RESEARCH

migration – How to move Azure SQL managed instance cross tenants?

March 25, 2023admin

How to move Azure SQL managed instance cross tenants? I have some critical DBs hosted by Tenant_A’s SQL MI A which need to be moved to Tenant_B’s SQL MI B.…Read moremigration – How to move Azure SQL managed instance cross tenants?

DATA MANAGEMENT RESEARCH

Query a Database using GraphQL from your Static Web Apps [22 of 22]

March 18, 2023admin

Discover how to connect your Azure SQL Database to your Static Web Apps, and access it through a secure data endpoint generated for you with Azure Static Web Apps database…Read moreQuery a Database using GraphQL from your Static Web Apps [22 of 22]

DATA MANAGEMENT RESEARCH

azure data factory – Are there differences in how bindings are handled when using the bulk insert feature in ADF and SQL?

March 15, 2023admin

When using a copy activity and SQL Server connector in ADF pipeline, there are observed differences between how ADF handles a “bulk insert” operation and how SQL Server handles “bulk…Read moreazure data factory – Are there differences in how bindings are handled when using the bulk insert feature in ADF and SQL?

DATA MANAGEMENT RESEARCH

Bathula Varun – azure devops – Lourdes, Newfoundland and Labrador – Canada

March 13, 2023admin

  EDUCATIONAL QALIFICATION :      B. Tech from JNTU – 2016   SKIL SET Azure :   Azure Data Factory(ADF), Databricks, ADLS, GitHub, On-Premises SQL, IaaS SQL, PaaS, Azure VMs,…Read moreBathula Varun – azure devops – Lourdes, Newfoundland and Labrador – Canada

DATA MANAGEMENT RESEARCH

python – inserting 8k + character strings into azure sql data warehouse using pyodbc

March 7, 2023admin

As the title states, im trying to insert an 8k+ string into azure sql data warehouse using pyodbc in a python notebook. I’ve seen a few answers related to changing…Read morepython – inserting 8k + character strings into azure sql data warehouse using pyodbc

DATA MANAGEMENT RESEARCH

Delimiter issue – Copying Data from Azure SQL to Snowflake

March 7, 2023admin

I am trying to load data from Azure SQL to Snowflake. I am under the constraint to use the copy activity only. I am using a lookup table to reference…Read moreDelimiter issue – Copying Data from Azure SQL to Snowflake

RESEARCH

Unable to connect (Power BI to Azure SQL Database)

March 7, 2023admin

Slowly bit by bit I’m getting steps ahead in setting up my SQL database on Azure and connecting it to Power BI Desktop on Azure Virtual Machine, but there is…Read moreUnable to connect (Power BI to Azure SQL Database)

DATA MANAGEMENT RESEARCH

Modernize Your Apps with Azure SQL Managed Instance and Unlock the Benefits of the Cloud

March 3, 2023admin

Microsoft sponsored on-demand webinar Webcast Abstract Azure SQL Managed Instance is an intelligent cloud database service combining the broadest SQL Server engine compatibility with the benefits of a fully managed…Read moreModernize Your Apps with Azure SQL Managed Instance and Unlock the Benefits of the Cloud

DATA MANAGEMENT RESEARCH

Best Data Management Software for Azure Data Share

February 25, 2023admin

Part of the Azure SQL family, Azure SQL Database is the intelligent, scalable, relational database service built for the cloud. It’s evergreen and always up to date, with AI-powered and…Read moreBest Data Management Software for Azure Data Share

DATA MANAGEMENT RESEARCH

azure – How to map a json object to a column in Sql

February 24, 2023admin

I am trying to load and transform data from an API to Azure SQL using ADF copy activity. The data from json API(source) is in below format. { “fdgdhgfh”: {…Read moreazure – How to map a json object to a column in Sql

DATA MANAGEMENT MQTT & IOT AUTOMATION RESEARCH

terminology – What does “edge” mean when talking about Azure SQL?

February 23, 2023admin

Real-time data insights for IoT servers, gateways, and devices Azure SQL Edge, a robust Internet of Things (IoT) database for edge computing, combines capabilities such as data streaming and time…Read moreterminology – What does “edge” mean when talking about Azure SQL?

DATA MANAGEMENT RESEARCH

What are the advantages of using Token based authentication in Azure SQL DB? How to decide whether to choose this approach for DB connection from your application?

February 21, 2023admin

The token-based authentication method allows middle-tier services to obtain a token from Azure AD and use it to connect to Azure SQL Database. It also enables more sophisticated scenarios, including…Read moreWhat are the advantages of using Token based authentication in Azure SQL DB? How to decide whether to choose this approach for DB connection from your application?

DATA MANAGEMENT RESEARCH

azure sql database – Dynamically update filed value in ADF Copy activity

February 21, 2023admin

I am trying to perform copy activity in ADF. Source for the pipeline is API(Json response) and Sink is Azure Sql data base. I want to check, if the enddat…Read moreazure sql database – Dynamically update filed value in ADF Copy activity

RESEARCH

Azure SQL Database ‘sp_executesql’ not supported on this version of SQL Server

February 19, 2023admin

When I execute the following the code below on my Azure SQL Database I get the following error: ‘sp_executesql’ not supported on this version of SQL Server EXECUTE sp_executesql @ColumnMetadataSQL,…Read moreAzure SQL Database ‘sp_executesql’ not supported on this version of SQL Server

RESEARCH

sql server – How to prevent deletion of Azure SQL db in SSMS

February 19, 2023admin

We tried to follow this URL: protecting azure sql databases from accidental deletion, but it only prevents it from the Portal? As per this Document, While a delete lock on…Read moresql server – How to prevent deletion of Azure SQL db in SSMS

3D PRINTING RESEARCH

Login to Azure SQL with JWT token in python – [SQL Server]Login failed for user ‘

February 16, 2023admin

I try to connect to Azure SQL using SQLAlchemy in python, authenticating with JWT generated for App registration. Despite checking almost any combination of parameters and granting all potentially meaningful…Read moreLogin to Azure SQL with JWT token in python – [SQL Server]Login failed for user ‘

DATA MANAGEMENT RESEARCH

How to create the field mapping in Azure cognitive search

February 11, 2023admin

I have been using the Azure cognitive search to create the search index where the data source will be the azure SQL database. I have created the search index for…Read moreHow to create the field mapping in Azure cognitive search

RESEARCH

Azure SQL Alter compatibility level Strategy

February 9, 2023admin

But 120 and 130 are pretty old. 160 is the latest and greatest. What strategy you should apply depends a little on what your concerns are. Functionally, there are not…Read moreAzure SQL Alter compatibility level Strategy

DATA MANAGEMENT RESEARCH

SQL Database from Azure VM to Azure SQL Server : DB Size ( 300 GB DB)

February 2, 2023admin

What you need is called an “online” migration and Azure Data Migration Service (DMS) is the tool/service you need. This tutorial of the old version should help you do all…Read moreSQL Database from Azure VM to Azure SQL Server : DB Size ( 300 GB DB)

DATA MANAGEMENT RESEARCH

How can i connect to Azure SQL Database using Managed Identity?

January 31, 2023admin

I have setup Managed Identity on my App Service and given the database access. I have a console app and used Microsoft.Data.SqlClient 3.0.1 as a nuget package that I test…Read moreHow can i connect to Azure SQL Database using Managed Identity?

RESEARCH

Azure SQL DB Index Recommendations

January 28, 2023admin

For the SQL Azure Databases in multiple regions and multiple subscriptions, we keep getting recommendations/warning regarding the addition of indexes is required, but those recommendations are implemented already and those…Read moreAzure SQL DB Index Recommendations

DATA MANAGEMENT RESEARCH

Re: How to connect to Azure SQL Database with MSI …

January 26, 2023admin

Hi @AlaaAlmaghrbi, AFAIK, power bi not only allow you to use SQL connector to get data but also other type of data drivers with correspond connection strings.(you need ensure this type…Read moreRe: How to connect to Azure SQL Database with MSI …

DATA MANAGEMENT RESEARCH

scheduled tasks – How to sync data from Azure SQL managed instance to On-premise SQL server instance on weekly Basis

January 26, 2023admin

Please what are the options for me in the following scenario. We have a SQL managed instance on Azure, our client has requested that they want their data (managed instance)…Read morescheduled tasks – How to sync data from Azure SQL managed instance to On-premise SQL server instance on weekly Basis

DATA MANAGEMENT RESEARCH

Calling external REST endpoints from Azure SQL Database

January 25, 2023admin

Davide Mauri joins Scott Hanselman to discuss a recently announced feature of Azure SQL DB that makes integration with REST APIs incredibly easy. A new system function enables Azure SQL…Read moreCalling external REST endpoints from Azure SQL Database

RESEARCH

Unable to Scan Azure SQL Database with Azure Purview

January 24, 2023admin

I’m not sure why I’m unable to scan a particular Azure SQL Database with Azure Purview. This is puzzling as I’m able to scan other Azure SQL Databases From the…Read moreUnable to Scan Azure SQL Database with Azure Purview

DATA MANAGEMENT RESEARCH

Connecting PowerBI in US to Azure SQL Database in …

January 14, 2023admin

We have a requirement to store weekly snapshot of data from a certain source system to build a PowerBI report. If the data is being stored in Azure SQL DB…Read moreConnecting PowerBI in US to Azure SQL Database in …

DATA MANAGEMENT RESEARCH

backup – Azure SQL Database – Restore options for Continuous Integration Builds

January 3, 2023admin

We have a Azure SQL Database (PAAS) that acts like a master database for testing new code. The goal is to set up a pipeline that creates a writeable copy…Read morebackup – Azure SQL Database – Restore options for Continuous Integration Builds

DATA MANAGEMENT RESEARCH

sql server – How to ensure an app builder doesn’t have acccess to database?

December 24, 2022admin

So, we have made a web application login protocol via which users can query a database on Azure SQL Server with sensitive data. Now partner-organizations want to use the same…Read moresql server – How to ensure an app builder doesn’t have acccess to database?

RESEARCH

sql server – Unable to open database properties window in SSMS

November 16, 2022admin

I am using Azure SQL MI. Using SSMS, I backed up an SQL db to an Azure container. After that I am unable to open the Properties windows of that…Read moresql server – Unable to open database properties window in SSMS

DATA MANAGEMENT RESEARCH

azure – Sitecore 10 AKS Development Instance – SQL Persistence

November 10, 2022admin

I have followed Barts’ excellent tutorial to get a development instance of Sitecore 10.2 up and running on AKS. github.com/bplasmeijer/Sitecore-Symposium-2020-Containers-AKS There is one flaw though, when the windows AKS node…Read moreazure – Sitecore 10 AKS Development Instance – SQL Persistence

DATA MANAGEMENT RESEARCH

Import/Export Data from SQL (Azure Virtual Machine) to Azure SQL

September 26, 2022admin

Our current web application uses Azure SQL Database. We need to create a scheduled process for importing/exporting data from a SQL database in Azure Virtual Machine to Azure SQl database.…Read moreImport/Export Data from SQL (Azure Virtual Machine) to Azure SQL

RESEARCH

sql server – Azure SQL optimize IN query

September 22, 2022admin

I’m trying to optimize the IN query on Azure SQL. This IN query has more than 50k records. With the optimization, I will use the INNER join. This is what…Read moresql server – Azure SQL optimize IN query

3D PRINTING RESEARCH

azure sql database – ADFv2 Lookup Activity timeout after 2 hours even after increasing query timeout value

July 20, 2022admin

I have a lookup activity that timeouts after the 2 hours (120 mins) which is the default (could be just a coincidence) even after increasing the query timeout to 720…Read moreazure sql database – ADFv2 Lookup Activity timeout after 2 hours even after increasing query timeout value

RESEARCH

azure sql database – Best practice of creating table with CSV file & using Varchar(MAX)

July 9, 2022admin

I have a question regards to creating a table in Azure SQL Server by importing a flat file (csv). I am having an issue with size of length with table…Read moreazure sql database – Best practice of creating table with CSV file & using Varchar(MAX)

RESEARCH

Re: Gateway for Azure SQL Server

March 31, 2022admin

Hi All,   I am using a Azure SQL Server. And I am using a VPN while connecting to this server. Without a VPN we cannot connect to this Datasource.…Read moreRe: Gateway for Azure SQL Server

RESEARCH

Gateway for Azure SQL Server

March 25, 2022admin

Hi All,   I am using a Azure SQL Server. And I am using a VPN while connecting to this server. Without a VPN we cannot connect to this Datasource.…Read moreGateway for Azure SQL Server

RESEARCH

Azure SQL Server Firewall IP address range

March 3, 2022admin

Will a range of 0.0.0.0 to 255.255.255.255 be OK to enter? Is there a range of IP addresses that will give me an ‘Allow All’. Its not practical for me…Read moreAzure SQL Server Firewall IP address range

DATA MANAGEMENT MQTT & IOT AUTOMATION RESEARCH

Azure architecture question for transfer data to Azure SQL Database

February 28, 2022admin

I want to switch my on premise data collection to Azure environment. At the moment I`m saving up to 500k (messages) on data a day.Before storing the data in the…Read moreAzure architecture question for transfer data to Azure SQL Database

RESEARCH

Effect on Azure SQL Server DB permissions of Azure Active Directory Group rename

January 12, 2022admin

Hey,Renaming an AAD group would not have any impact on existing permissions and everything should be same.Based on my experience, the name change is not reflected automatically in user details…Read moreEffect on Azure SQL Server DB permissions of Azure Active Directory Group rename

DATA MANAGEMENT RESEARCH

How to manage windows azure SQL Database

January 10, 2022admin

You can use the full SQL Server Management Studio to do the majority of the tasks. You can download the tool here: www.microsoft.com/en-gb/download/details.aspx?id=29062 To connect to your Azure SQL database,…Read moreHow to manage windows azure SQL Database

DATA MANAGEMENT RESEARCH

azure data factory 2 – How to dynamically use toLabel function with SOQL query to SalesForce API within ADF?

January 8, 2022admin

My objective is to stage data from SalesForce to Azure SQL Database using ADF. In the past we used queries written in SOQL to load the data. However, when the…Read moreazure data factory 2 – How to dynamically use toLabel function with SOQL query to SalesForce API within ADF?

RESEARCH VIRTUALIZATION

What are the units tracking resource usage for the S0 Azure SQL Database?

December 28, 2021admin

This is in regards Azure accounts on the 12 months trial that come with free services. The free services include a SQL Server Database using the DTU model in tier…Read moreWhat are the units tracking resource usage for the S0 Azure SQL Database?

RESEARCH VIRTUALIZATION

Backward compability for Azure Managed Instance, Azure SQL server and SQL server

December 27, 2021admin

Dear Community I’m thinking about moving database located on SQL Server 2012 to Azure managed instance or SQL server 2019. I was reading about backward compatibility of those two sql…Read moreBackward compability for Azure Managed Instance, Azure SQL server and SQL server

RESEARCH VIRTUALIZATION

Azure Analysis – SQL Diagnostic Manager 11.1

December 25, 2021admin

The Analyze tab runs prescriptive analyses on Azure SQL servers to identify and resolve SQL Server performance problems. The analysis engine scans your SQL Server configuration for potential problems and…Read moreAzure Analysis – SQL Diagnostic Manager 11.1

RESEARCH VIRTUALIZATION

Azure Serverless SQL – Failover Group – Always Running

December 25, 2021admin

When I place an Azure SQL serverless database inside a failover group, I notice that there is near constant activity on the server. Thus I am billed per second for…Read moreAzure Serverless SQL – Failover Group – Always Running

DATA MANAGEMENT VIRTUALIZATION

sql server – Where to find Azure SQL Database backups?

December 23, 2021admin

I have created an azure SQL database, single database. I would like to see where my backup files are saved. I know in Data Management > Backups I can see…Read moresql server – Where to find Azure SQL Database backups?

DATA MANAGEMENT ELASTIC & LUCENE VIRTUALIZATION

Our client trying to move the Azure sql server from one resource group to another

December 21, 2021admin

Our client trying to move the Azure SQL database resources from one resource group to another . The Azure SQL server having around 1600 databases. 4 Elastic pool have exist…Read moreOur client trying to move the Azure sql server from one resource group to another

VIRTUALIZATION

Can I register Azure SQL Database with my ArcGIS E…

December 19, 2021admin

Can I register Azure SQL Database with my ArcGIS Enterprise Base deployment? Right now, I have a 10.9 ArcGIS Enterprise Base deployment in Azure. In the cloud builder, the option…Read moreCan I register Azure SQL Database with my ArcGIS E…

Copyright © 2023 IRZU INSTITUTE | Deneb by Firefly Themes
Scroll Up