4,707 questions
4 answers
One of the answers was accepted by the question author.
To identify the performance of sqlserver between 1 month of different years.
Hi, How can I identify the performance load of SQL Server between 2 period of different years, Any script to calculate the I/O load and performance of SQL Server. I s there any tools to identify the performance and I/O load on SQL Server between 2…
Developer technologies | Transact-SQL
SQL Server | Other
14,508 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 25%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
VS 2022 - Unable to load SDK-style sqlproj in "SQL Server Object Explorer"
Hello, I'm migrating a sqlproj from the "classical" structure to the new SDK-style because I need to execute the "dotnet build my.sqlproj" command in an Azure DevOps pipeline Linux agent and the classical sqlproj would work only on…
Developer technologies | Visual Studio | Extensions
308 questions
asked Jul 23, 2025, 4:33 PM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 90%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGV%3C/text%3E%3C/svg%3E)
Giulio Vito De Musso
0
Reputation points
accepted Jul 24, 2025, 9:34 AM
Giulio Vito De Musso
0
Reputation points
2 answers
One of the answers was accepted by the question author.
The .NET runtime 9.0.5 or newer could not be found in the remote host under '/usr/local/share/dotnet/dotnet'.
I get this error in Visual Studio Version 17.14.8 when I want to start debugging my iOS project on my iPad: The .NET runtime 9.0.5 or newer could not be found in the remote host under '/usr/local/share/dotnet/dotnet'. Please install it or try setting a…
Developer technologies | .NET | .NET MAUI
4,036 questions
asked Jul 11, 2025, 9:32 AM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 32%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kim Strasser
1,346
Reputation points
answered Jul 23, 2025, 10:26 PM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 44%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
Odaronil
0
Reputation points
3 answers
One of the answers was accepted by the question author.
How can I drag and Drop and email from Outlook into a web form, and parse out the email details
I have a drag and drop form working, but I cannot get the email details from the 'dropped' file. Tried using the Microsoft.Office.Interop.Outlook package (had success in a winformapp), but I can't figure it out. Here is a js snippet I am using to trap…
Developer technologies | ASP.NET | ASP.NET API
448 questions
asked Mar 21, 2025, 7:50 PM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 3%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIH%3C/text%3E%3C/svg%3E)
Ian Hockaday
20
Reputation points
accepted Jul 23, 2025, 8:48 PM
Ian Hockaday
20
Reputation points
1 answer
One of the answers was accepted by the question author.
can VS Code highlight TIE syntax?
Can VS Code recognize and highlight TIE syntax? Is it and extension? Where do I get it, how do I install it? If not yet available, how do I create one?
Developer technologies | Visual Studio | Extensions
308 questions
asked Jun 24, 2025, 12:45 AM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 17%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Laszlo Borbely-Bartis
0
Reputation points
accepted Jul 23, 2025, 6:41 PM
Laszlo Borbely-Bartis
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Crash on mouse over of Cesium map when using asp.net scriptmanager
I have an [asp.net] project using web forms. The aspx page has a Cesium map and crashes when you mouse over it but only if the page also contains the asp:ScriptManager element. If the ScriptManager element is removed, the page does not crash on mouse…
Developer technologies | ASP.NET | Other
3,603 questions
asked Jul 21, 2025, 5:44 PM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 13%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CantThinkOfAName
20
Reputation points
commented Jul 23, 2025, 6:13 PM
CantThinkOfAName
20
Reputation points
1 answer
One of the answers was accepted by the question author.
why abc4j can not parse the file?
I am using .net android and add the package : abc4j to parse music file. but there is error and I can not parse it. this is the music file: p.txt
Developer technologies | .NET | .NET MAUI
4,036 questions
asked Jul 18, 2025, 9:04 AM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 2%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
mc
5,611
Reputation points
commented Jul 23, 2025, 4:53 PM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 9%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Roll the Six
0
Reputation points
2 answers
One of the answers was accepted by the question author.
How is a Blazor Server app deployed in Linux?
I have a Blazor Server app, developed in VS Code on a Mac. At this point in development, it runs correctly on localhost, as well as on a Windows Server instance in AWS Lightsail, using IIS. For final deployment, I would like to install the app on a Linux…
Developer technologies | ASP.NET | ASP.NET Core
4,830 questions
asked Jul 22, 2025, 3:47 AM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 91%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
David Stowell
20
Reputation points
commented Jul 23, 2025, 4:37 PM
David Stowell
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Enable Location Service in .NET MAUI after upgrading from Xamarin Forms
I am currently upgrading my Xamarin Forms application to .NET MAUI. In my Xamarin Forms app, I used DependencyService to enable a location pop-up asking the user for location service permission. I'm struggling to find a way to achieve the same result in…
Developer technologies | .NET | .NET MAUI
4,036 questions
asked Mar 8, 2024, 11:39 AM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 45%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
Etien Ducka
30
Reputation points
edited a comment Jul 23, 2025, 9:38 AM
Etien Ducka
30
Reputation points
1 answer
One of the answers was accepted by the question author.
How do I add an existing directory tree to a project in Visual Studio
I was trying to use this solution, but realize that Visual Studio 2022 does not have the option "Include in Project.". What feature replaces this, for getting a directory tree into my project? Thanks.
Developer technologies | C++
3,981 questions
asked Dec 13, 2023, 1:54 PM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 4%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC8%3C/text%3E%3C/svg%3E)
CDev-8220
405
Reputation points
commented Jul 22, 2025, 12:52 PM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 26%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Lindsay, Carol C
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Is it still the case that a Blazor WebAssembly cannot reference a Blazor Server-Side project?
I'm working on rewriting an old ASP.NET WebForms app. I've created an ASP.NET Core Blazor app using .NET 9, with both a server-side project and a WebAssembly (Client) project. The server-side project has the Home page and allows the user to change the…
Developer technologies | ASP.NET | ASP.NET Core
4,830 questions
asked Jul 17, 2025, 8:24 PM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 35%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFR%3C/text%3E%3C/svg%3E)
Falanga, Rod, DOH
290
Reputation points
commented Jul 22, 2025, 9:07 AM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 49%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Danny Nguyen (WICLOUD CORPORATION)
410
Reputation points Microsoft External Staff
12 answers
One of the answers was accepted by the question author.
Can you recommend a sql formatter?
Dear colleagues, Which SQL formatter would you recommend? In our organization, we have coding standards. My problem is, there are to many of them. As I am responsible for the repositories containing SQL, I want to enforce a single standard by…
Developer technologies | Transact-SQL
4,707 questions
SQL Server | Other
14,508 questions
asked Nov 17, 2020, 2:17 PM
Chris Sijtsma
106
Reputation points
answered Jul 22, 2025, 4:39 AM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 28.999999999999996%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Anil Peter
0
Reputation points
8 answers
One of the answers was accepted by the question author.
Pull values to the Left of a dash
I am trying to pull from a field called "Location" that includes a number of varying lengths after a dash. I only want to pull the value of the field before the dash. My expression below worked with the LTRIM to pull values after the dash but…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,068 questions
Microsoft 365 and Office | Excel | For business | Windows
18,996 questions
Developer technologies | Transact-SQL
4,707 questions
asked May 25, 2021, 2:32 AM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 64%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Evan Stroum
21
Reputation points
answered Jul 22, 2025, 4:16 AM
Ashish Mathur
160
Reputation points
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
Requiring Authorization Causes Long Url
Hello everyone and thanks for the help in advance. I am developing an Asp.net 9 Core MVC application. I want to all controllers to require authorization rather than having to decorate each action with [Authorize]. I tried…
Developer technologies | ASP.NET | ASP.NET Core
4,830 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 34%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Windows application specific's registry key
I need a place to put configuration for my Win32 application inside the registry. Where it is should be? Are there multiple places to store application-specific registry?
Windows development | Windows API - Win32
2,802 questions
Windows for business | Windows Client for IT Pros | User experience | Other
Developer technologies | C++
3,981 questions
asked Oct 4, 2022, 4:30 AM
thebluetropics
1,046
Reputation points
commented Jul 21, 2025, 11:00 PM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
78,571
Reputation points
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
Visual Studio 2013 license not working after move to new machine
Purchased Visual Studio Professional 2013 back in 2013 or 2014. Installed on a laptop. Never installed on any other device. Ancient laptop is close to death, so I started moving to a new Windows 11 laptop. I installed VS 2013 from the original DVDs a…
Developer technologies | Visual Studio | Setup
1,215 questions
asked Jul 18, 2025, 5:05 PM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 28.999999999999996%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Clark Coleman
20
Reputation points
answered Jul 21, 2025, 9:23 PM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 63%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHG%3C/text%3E%3C/svg%3E)
HARDCORE GAMES™
175
Reputation points
1 answer
One of the answers was accepted by the question author.
Can ClosedXML be used in a Visual Studio developed .Net9 Blazor Webassembly app?
I have read conflicting statements about whether ClosedXML can be used in a Blazor Webassembly app. A Google seacrh of "can Closedxml be used in a Blazor WASM app c#" produces an AI response of "yes" though with caveats about…
Developer technologies | Visual Studio | Other
5,466 questions
asked Jul 19, 2025, 2:23 PM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 55.00000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Steve Rehling
165
Reputation points
accepted Jul 21, 2025, 9:11 PM
Steve Rehling
165
Reputation points
1 answer
One of the answers was accepted by the question author.
How can sales and commissions be calculated based on multiple conditions?
I want to extract commission from sales using multiple conditions using LINQ query. Here different types of commission are assigned on different sales values. I need this in my report sheet. If any experienced person could help me, I would be benefited.…
Developer technologies | ASP.NET | ASP.NET Core
4,830 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 44%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
How to create visual studio 2022 layout without downloading arm64 binaries?
Refer to the document https://learn.microsoft.com/en-us/visualstudio/install/use-command-line-parameters-to-install-visual-studio?view=vs-2022 it tells if the optional parameter "--arch" is not set, the layout should only includes x64 product…
Developer technologies | Visual Studio | Setup
1,215 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 39%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
visual studio installer cannot continue to download for visual studio community 2022 and no access to aka.ms
i am muhammad naveed faruq from pakistan i am an old user of visual studio to download visual studio 2022 community, when after downloading first file by browser and after clicking on it a small page opens to download installer,(contains two progress…
Developer technologies | Visual Studio | Setup
1,215 questions
asked Jun 9, 2025, 10:27 AM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 45%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENF%3C/text%3E%3C/svg%3E)
naveed faruq
30
Reputation points
edited a comment Jul 21, 2025, 8:19 AM
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 3%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
sarah javed
0
Reputation points