386,729 questions

Sort by: Updated
Updated Created Answers
2 answers

New to SQL in Microsoft Access and having major issues

I am tasked with tracking Overtime hours worked by Department/Employee. Our work week is 35 hours, first 5 additional is Straight Time, any additional is OT (at time and a half). Tables collect Week of Date, Employee, # of OT Hours and Department. I…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
881 questions
asked 2021-01-31T20:49:37.337+00:00
Mark Davis 1 Reputation point
answered 2021-02-02T23:13:20.447+00:00
C Data 6 Reputation points
1 answer One of the answers was accepted by the question author.

PluralizationService.Pluralizeの適用対象について

ドキュメント（https://learn.microsoft.com/ja-jp/dotnet/api/system.data.entity.design.pluralizationservices.pluralizationservice.pluralize?view=netframework-4.8） では.netcoreは適用されていませんが、実際にビルドするとエラーなく読み込めてしまいます。 …

C#
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.
11,015 questions
asked 2021-01-29T07:21:58.103+00:00
sora huziu 21 Reputation points
accepted 2021-02-02T23:08:17.383+00:00
sora huziu 21 Reputation points
1 answer

this is unavailable due to your account permissions

I've set up another user on our Azure system. I would think that they would have access to the features I've requested. But this is not the case. When they log in they see the following: "Apps: This is unavailable due to your account…

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,127 questions
asked 2021-02-02T09:17:59.243+00:00
Renae Adam 1 Reputation point
answered 2021-02-02T23:04:38.25+00:00
Marilee Turscak-MSFT 36,866 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Apply SQL transformation : conditional rounding

Dear, I would like for a specidified column ("PagesTot"), apply a rounding (to 100's) when the number of pages goes over 500. I use for this the "apply sql transformation" module. SELECT PagesTot, CASE WHEN…

Azure SQL Database
asked 2021-01-25T07:47:23.52+00:00
Mohamed El Hamrouni 231 Reputation points
accepted 2021-02-02T22:57:17.93+00:00
Mohamed El Hamrouni 231 Reputation points
2 answers One of the answers was accepted by the question author.

how to use SET ANSI_NULLS ON in a script wich creates several sprocs?

I have seen this script in docs. why does it repeat SET ANSI_NULLS ON and SET QUOTED_IDENTIFIER ON before each batch that creates a sproc?. Is it necessary at all repeating them? or just the first ones would work the same? USE [master] GO…

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,656 questions
asked 2021-02-02T14:36:23.113+00:00
Pablo gil 86 Reputation points
answered 2021-02-02T22:26:09.157+00:00
Erland Sommarskog 112.7K Reputation points MVP
1 answer

Azure Bastion | Cannot install packages

The following is my Infrastructure on Azure cloud Kubernetes cluster with AKS Bastion host to make AKS private Everything was first till a few days ago (I am deploying a new cluster from scratch now) The cluster with bastion host and others…

Azure Container Instances
Azure Container Instances
An Azure service that provides customers with a serverless container experience.
709 questions
Azure Bastion
Azure Bastion
An Azure service that provides private and fully managed Remote Desktop Protocol (RDP) and Secure Shell (SSH) access to virtual machines.
264 questions
asked 2021-02-01T07:31:05.983+00:00
Mihir Shah 1 Reputation point
answered 2021-02-02T22:16:47.313+00:00
Marilee Turscak-MSFT 36,866 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Azure AD B2C Always redirected to login

I have a new Blazor Server application in .Net 5.0. Using the setup wizard, I entered the necessary information to connect to a new Azure AD B2C , and created the project. I set up the Azure AD using the following document (as well as the additional…

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,127 questions
asked 2021-02-02T21:06:43.087+00:00
Michael Vanderpool 41 Reputation points
accepted 2021-02-02T22:13:34.55+00:00
Michael Vanderpool 41 Reputation points
1 answer One of the answers was accepted by the question author.

Syntax error in copying blob folder to Data Lake Storage Gen1

Hi everyone, I am trying to copy files from my blob storage account to Data Lake Storage Gen1 using "AdlCopy" inside the Data Lake Analytics Account. I go to "+ New Job" and use the below syntax: AdlCopy /source…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,485 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,922 questions
asked 2021-01-29T06:32:10.327+00:00
Ajay Singh 21 Reputation points
accepted 2021-02-02T22:01:26.717+00:00
Ajay Singh 21 Reputation points
2 answers

SQL Server 2019 big data cluster on other cloud platform

May i know if there are supports/Links/docs talking about the support on BDC on AWS/Google...or others.. I just see And unfortunately I also see and this mean in any kind of cloud , need to use K8S services to deploy BDC ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,004 questions
asked 2021-01-30T12:08:07.333+00:00
sakuraime 2,326 Reputation points
commented 2021-02-02T21:51:02.173+00:00
Erland Sommarskog 112.7K Reputation points MVP
1 answer One of the answers was accepted by the question author.

RD Web Client Install Failing Server 2016

Hi All, I have a RDS Environment Setup for testing and I am looking into testing the new RD Web Client for Windows Server 2016 and 2019. I have all current updates installed and ready to go. The server that I am testing has all RDS Roles…

Remote Desktop
Remote Desktop
A Microsoft app that connects remotely to computers and to virtual apps and desktops.
4,604 questions
asked 2021-02-02T21:32:30.857+00:00
Thomas Park 96 Reputation points
accepted 2021-02-02T21:48:46.97+00:00
Thomas Park 96 Reputation points
2 answers

Compare 2 Array of objects each 50k lines each

I have a script that I have been working on that takes two files (both files are each 50k+ lines). The object of this script is create a new combined file. There is a key account number that match in both files. The issue is that when I run the script,…

Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,554 questions
asked 2021-02-02T17:24:43.513+00:00
Trey Burkhalter 1 Reputation point
commented 2021-02-02T21:44:58.873+00:00
Titan 206 Reputation points
1 answer One of the answers was accepted by the question author.

How to ONLY Display Shortest Time or Shortest Distance Route in Bing Maps?

Hi there, I'm trying to display the shortest time or shortest distance route on my map and only the unique route, no other options at all. I've tried the following code, it shows me always 2 or 3 options. confused! directionsManager.setRequestOptions({ …

Azure Maps
Azure Maps
An Azure service that provides geospatial APIs to add maps, spatial analytics, and mobility solutions to apps.
736 questions
Windows Maps
Windows Maps
A Microsoft app that provides voice navigation and turn-by-turn driving, transit, and walking directions.
257 questions
asked 2021-02-01T00:11:22.31+00:00
Yongxin 21 Reputation points
accepted 2021-02-02T21:34:22.067+00:00
Yongxin 21 Reputation points
1 answer

What is the replacement for the retired MCSA SQL Database development exams in the new role-based certifications that are now being roled out.

Hi Just wanted to know what the replacement for MCSA SQL Server Database Development 70-761, 70-762 will be for the new role-based certifications and when it will be released as I am now aware that these MCSA exams have now retired. Please give me…

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,739 questions
asked 2021-02-02T21:09:14.337+00:00
Fredrick Carter 1 Reputation point
answered 2021-02-02T21:19:50.04+00:00
Anonymous
1 answer

DDOS protection for trial account is not active by default.

Hi All, Recently i have created one free trial account. As per the Azure documentation it supports basic version of DDOS protection by default. But when i verified the DDOS status of my Virtual network it is not active. It's suggesting me to…

Azure DDos Protection
Azure DDos Protection
An Azure service that provides defense against distributed denial-of-service (DDoS) attacks.
71 questions
asked 2021-02-01T13:56:33.313+00:00
nilesht 1 Reputation point
answered 2021-02-02T21:01:11.96+00:00
Marilee Turscak-MSFT 36,866 Reputation points Microsoft Employee
2 answers

.NET CORE CLI for building regular .net applications

Hi, We are using visual studio 2017 and TFS with TeamFoundationVersion Control. We are trying to automate build and deployment using TFS continuous integration and continuous deployment. As part of CI, we were using MSBuild to build ASP.net…

.NET CLI
.NET CLI
A cross-platform toolchain for developing, building, running, and publishing .NET applications.
337 questions
asked 2021-01-07T23:05:49.49+00:00
Spunny 326 Reputation points
commented 2021-02-02T20:50:26.603+00:00
Spunny 326 Reputation points
2 answers One of the answers was accepted by the question author.

SQL query for getting last login

Hi, We have ASP.net application and sql server 2016 database. When ever user login to application, new row will be added for that user to log table. Row will have userID, type (login or logout or session end etc), LoginDateTime. Each day can…

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,656 questions
asked 2021-01-12T15:42:13.673+00:00
Spunny 326 Reputation points
accepted 2021-02-02T20:49:37.78+00:00
Spunny 326 Reputation points
1 answer

View/change phone number for Microsoft certificate

This Friday I have an exam. I received an email with the text: "Make sure your mobile phone number, including country code, is updated on your Microsoft Certification profile in case Pearson VUE needs to contact you during the exam". Where…

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,739 questions
asked 2021-02-01T07:08:48.543+00:00
Vrijhoef, M (Marleen) 1 Reputation point
answered 2021-02-02T20:30:40.907+00:00
Anonymous
2 answers One of the answers was accepted by the question author.

ADFS 3.0 not accepting NameID Policy

I am in the process of configuring SAML 2.0 federation to an ADFS 3.0 (Windows Server 2012 R2) instance, and wanting to set the NameID Policy to "urn:oasis:names:tc:SAML:1.1:nameid-format:emailAddress" for the Relying Party Trust. This works…

Active Directory Federation Services
Active Directory Federation Services
An Active Directory technology that provides single-sign-on functionality by securely sharing digital identity and entitlement rights across security and enterprise boundaries.
1,264 questions
asked 2021-01-21T08:15:08.4+00:00
FS 21 Reputation points
accepted 2021-02-02T20:30:17.7+00:00
FS 21 Reputation points
2 answers One of the answers was accepted by the question author.

ConfigMgr Visio Stencil

Since MS changed the Technet Gallery to Code Sample, I am not able to download the SCCM Visio Stencil anymore. Do you know where I can get it? Used to be here. …

Visio Management
Visio Management
Visio: A family of Microsoft products used to create diagrams and vector graphics.Management: The act or process of organizing, handling, directing or controlling something.
255 questions
asked 2021-01-29T23:25:01.647+00:00
Ray Wong 21 Reputation points
accepted 2021-02-02T20:28:25.97+00:00
Ray Wong 21 Reputation points
0 answers

How to preview video being shared to meeting with HMT-1 glasses ?

Hello, We are trying out Microsoft Teams on the HMT-1 smart glasses made by RealWear. Another meeting app on the glasses allows us to "pin video" or preview on the screen of the glasses what the video feed we are sharing with the meeting…

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,315 questions
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
3,342 questions
asked 2021-01-27T18:34:59.307+00:00
Palokangas, Michael 1 Reputation point
commented 2021-02-02T20:16:19.64+00:00
Deva-MSFT 2,266 Reputation points Microsoft Employee