A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Excel Book1 opens spontaneously
I have Microsoft365, Office 2021, 64xbit. I placed file (MASTER09.xlsm), folder (Metadata15) and folder (MS15XLS.DLL) on my OneDrive account. Metadata15 and MS15XLS.DLL must be on your C drive in to run MASTER09.xlsm. MASTER09 runs up to 16 stock…
Microsoft 365 and Office | Excel | For business | Windows
Execution Plan lists deleted index
Looking at the profiler, I am seeing an execution plan that lists a deleted Columnstore index: However, I deleted this index 10 days ago, and it does not appear in the indexes for that table, nor in a query I found that lists all the indexes in…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
ANGULAR CORS ERROR
I AM WORKING IN ANGULA AND I AM TRYING TO DO A LOGIN AUTHENTICATION. BELOW IS MY INTERCEPTOR CODE BUT WHEN I TRY TO LOGIN, THIS IS THE ERROR CODE IT IS GIVING ME
Community Center | Not monitored
Tag not monitored by Microsoft.
Swagger file generation failed for Http trigger function app with cosmos db nuget package
I have an isolated dotnet 6 function app which uses cosmos db nuget package ("Microsoft.Azure.Cosmos" Version="3.26.2"). I am not able to generate swagger document for this as I am getting runtime exception Bad IL format. The format…
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
Azure Cosmos DB
An Azure NoSQL database service for app development.
How to get data from cosmos db in real time into my mern stack dashboard?
Hello,i have used azure cosmos DB as a storage for storing azure IOT data using stream analytics.Then i connect my NodeJS to azure cosmos dB using cosmos DB keys,then make an API and use this API to show data on my react application. Now i want to…
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
Azure Cosmos DB
An Azure NoSQL database service for app development.
C# storing data in a database
I made this method to store some data into my SQL database. Does anybody know what is wrong or why it doesn't run? public SqlConnection con = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=cdDB;Integrated…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Developer technologies | C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
Speech to Text subscription key to be used in API Management?
Hi, I was trying to use API management instance with Azure Speech to Text API. How can I use the subscription key for Speech to Text aside from the subscription key of APIM? I have imported this API Definition on our API Management. …
Azure API Management
An Azure service that provides a hybrid, multi-cloud management platform for APIs.
Faster Bulk filecopy to remote server using powershell
I have a situation where I have to setup a normal windows file copy operation to a group of remote servers behind a loadbalancer using powershell. This is what I have already where I am passing a bunch of parameters and able to perform file copy on…
Windows for business | Windows Server | User experience | PowerShell
Azure VM status permissions
Hi All i have a resource groups lets say resourcegroup1 it has Azure Virtual Desktops in it and my requirement is to know what is the status of the Virtual Machine(Azure virtual desktop VMs) in this resource group i.e it is running or stopped state…
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Azure Role-based access control
An Azure service that provides fine-grained access management for Azure resources, enabling you to grant users only the rights they need to perform their jobs.
Azure Virtual Desktop
A Microsoft desktop and app virtualization service that runs on Azure. Previously known as Windows Virtual Desktop.
Microsoft Security | Microsoft Entra | Microsoft Entra ID
A cloud-based identity and access management service for securing user authentication and resource access
BEGIN and END in a SQL Server Stored Procedure
What are the general standard/convention regarding using BEGIN and END in a SQL Server Stored Procedure? I totally understand using BEGIN and END for complex SQL Server Stored Procedures to separate logical chunks of code, but should they necessarily…
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
[MS-WCCE] ICertRequestD2::GetCAProperty incorrect description for CR_PROP_CAXCHGCERTCHAIN
This applies to [MS-WCCE] §3.2.1.4.3.2.16 PropID = 0x00000010 (CR_PROP_CAXCHGCERTCHAIN) "CA Exchange Certificate Chain" The documentation says that: Contains CA's certificate stored in the Signing_Cert_Certificate datum and its parent…
Windows development | Windows Open Specifications
SSIS Package to read data from JSON file
Hi Team, I have a requirement where I need to read the JSON file which is getting created at shared location in every few second, and load the JSON data in database. I wanted to understand if I can create a SSIS package which can be schedule to…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Spoke to onprem connection
Hi All, I just deployed this ARM template from Microsoft. I created a rule on the firewall to allow ping from on-prem VM to the spoke VM as follows: name: allowping protocol: ICMP: Source Addresses:…
Azure Firewall
An Azure network security service that is used to protect Azure Virtual Network resources.
Form Recognizer billing is different to the marketing side
Hey, on the marketing side, the price per 1k requests is around 10$ but on the Pricing Tier page its way higher for the pre-build invoice service. Can someone explain that?
Azure Document Intelligence in Foundry Tools
An Azure service that turns documents into usable data. Previously known as Azure Form Recognizer.
Can not enter new record via Access front end after linking tables to SQL Express
I have a Time & Billing Access program. I just migrated the tables to a SQL Express database and using it as the back end: tables all linked to the front end Access program. I can enter a new records to all of the tables except the TimeSheet…
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
Azure Free Account Card Verification Issue
Hello Microsoft, I'm trying to access Microsoft free account and getting issue at "Identity Verification by card" area. I have tried lot of times using different different email addresses and using the cards of particular persons but…
Community Center | Not monitored
Tag not monitored by Microsoft.
Problem while adding a new connection in a local network gateway
Hello, I want to create a Site-to-site VPN between my network and an Azure Vnet, I created a VPN Gateway in the Vnet, and the local network gateway also, I've a problem while adding a new connection, the virtual network gateway didn't been…
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
Ways to minimize risk of corruption of an accdb (back end, only tables)
Hi. Several weeks ago, after compacting (via VBA code) an accdb (back end on a server), I couldn't find anymore some indexes in a (important...) table. In the compacted accdb, I found the MSysCompactError table (as expected, as compacting didn't go…
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
Azure SQL Managed Instance Network Configuration
We are migrating SQL Server running on Azure VM to Azure SQL Managed Instance. We read below Network constraint in MSFT document. "Microsoft peering: Enabling Microsoft peering on ExpressRoute circuits peered directly or transitively with a…
Azure SQL Database
An Azure relational database service.
MS Access link table issue
Hello, I have a MS Access application which has link table from SQL Server Database (Express Edition). Now, the issue is, on some users pc its ask for SQL Server password while on some it does not. I linked the SQL Table with password saved. Its…
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access