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

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