385,400 questions

Sort by: Updated
Updated Created Answers
3 answers

Export table data to JSON from SQL Server

Hi Everyone, I need to export millions of records from SQL Server to UI so that the user can download either in CSV or excel. Can we do it using Stored Proc in SQL Server? Please suggest.

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,651 questions
asked 2020-11-21T13:57:02.42+00:00
simmigang 41 Reputation points
commented 2020-11-24T01:55:59.273+00:00
MelissaMa-MSFT 24,201 Reputation points
1 answer

Windows Server 2016 - Assigning Policies in DHCP for Smartphones

OS - Windows Server 2016 Environment: Server/Client (DC & Backup DC); Wired LAN and WLAN; Clients: Smartphones, Laptops, Desktops, Printers, Deskphones PRESENT SCENARIO I've got two DHCP Scopes, One for the desk-phones and the other for all…

Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,521 questions
Windows DHCP
Windows DHCP
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.DHCP: Dynamic Host Configuration Protocol (DHCP). A communications protocol that lets network administrators manage centrally and automate the assignment of Internet Protocol (IP) addresses in an organization's network.
1,039 questions
asked 2020-11-19T12:16:50.327+00:00
TCLSG IT Support 21 Reputation points
commented 2020-11-24T01:52:05.313+00:00
Candy Luo 12,711 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

SCCM +SQL Migration

Hello, I need to migrate SCCM and I don't know what is the best order on how to do exactly... 1 primary site SCCM 1910 on SRV1 + ADK 1903 1 SQL 2012SP4 + repport on SRV2 20 DP 2012R2 I need to migrate : SRV1 2012 r2 -> 2019 SQL 2012…

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,610 questions
asked 2020-11-19T11:10:57.21+00:00
matteu31 467 Reputation points
commented 2020-11-24T01:48:27.317+00:00
Fiona Yan-MSFT 2,311 Reputation points
4 answers

mrd doesn't run with macos big sur

I tried to use Microsoft Remote Desktop with macOS big sur through a secure connection form the website of my work (that include a vpn access point (SSL VPN Agent), but despite the vpn agent show me a message that informs me "microsoft remote…

Remote Desktop
Remote Desktop
A Microsoft app that connects remotely to computers and to virtual apps and desktops.
4,596 questions
asked 2020-11-22T08:36:24.667+00:00
paolo 1 Reputation point
answered 2020-11-24T01:47:56.053+00:00
Jenny Yan-MSFT 9,336 Reputation points
1 answer

cisco anyconnect no adapters available windows 10

Hello am facing an issue with cisco Anyconnect 4.7 in some Pcs that working with windows 10, the issue is Anyconnect Nam shows "No adapters available" I have to delete the Nam "network access manager" and install it again to fix…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,695 questions
Windows 10 Network
Windows 10 Network
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Network: A group of devices that communicate either wirelessly or via a physical connection.
2,362 questions
Windows 10 Compatibility
Windows 10 Compatibility
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Compatibility: The extent to which hardware or software adheres to an accepted standard.
480 questions
asked 2020-11-23T12:37:16.763+00:00
Fahme Elhakeem 26 Reputation points
answered 2020-11-24T01:47:42.58+00:00
Candy Luo 12,711 Reputation points Microsoft Vendor
2 answers

Dynamics hanging when deleting workflows

Our Dynamics implementation is very slow. Trying to delete workflows almost freezes the system. We cannot bulk delete process sessions. workflowlogbase and processsessionbase tables are over a million records and the known clean-up script doesn't…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,954 questions
asked 2020-11-20T21:39:42.96+00:00
Rickert, Sandi 1 Reputation point
answered 2020-11-24T01:46:02.563+00:00
m 4,271 Reputation points
4 answers One of the answers was accepted by the question author.

Powerpivot Equivalent for Excel SUMIFS Where Lookup Field Contains Partial Text from Another Field

I am relatively new to DAX and have scoured the forums but not found anything that quite works in Powerpivot/Dax yet. I am trying to sum each record where the Member No is contained within the Hierarchy string e.g. the first Member No occurs in rows…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,725 questions
asked 2020-11-20T13:11:05.103+00:00
Paul Cumming 96 Reputation points
commented 2020-11-24T01:39:02.513+00:00
Erin Ding-MSFT 4,461 Reputation points
1 answer

sharing webcam within multiple applications

Hi, I am on Windows 10 20H2, just tested that my laptop's camera cannot be shared at the same time with multiple applications (Zoom and Chrome e.g.) but only one at a time. On my mac, instead, I can. While searching on the web I jumped to an old,…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,695 questions
asked 2020-11-22T18:03:23.697+00:00
Elaci0 1 Reputation point
commented 2020-11-24T01:33:31.533+00:00
Jenny Yan-MSFT 9,336 Reputation points
9 answers

Removing Exchange 2010 before decommissioning SBS 2011 lost access to Active Directory on both servers.

I'm trying to decommission an SBS 2011 server and promote my Server 2019 to take over all roles. The 2019 server is a domain controller but does not yet hold any FSMO roles. The email has long been moved and I'm just trying to remove Exchange 2010,…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,787 questions
Windows Small Business Server
Windows Small Business Server
A family of Microsoft server products with messaging and collaboration, security-enhanced internet access, protected data storage, reliable printing, faxing, and the ability to run line-of-business applications. Replaced by Windows Server Essentials.
40 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,205 questions
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
6,624 questions
asked 2020-11-21T18:26:01.393+00:00
Bill Fewell 1 Reputation point
commented 2020-11-24T01:33:08.353+00:00
Anonymous
1 answer

Can not integrate Forms in Powerpoint

Hi, Our organization can not use Forms as an add-in in Powerpoint. Our administrators do not allow third-party add-ins (although Mentimeter is somehow added) and apparantly that is why we don't have permission. Forms is however pre-installed as…

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,610 questions
asked 2020-11-23T14:05:02.977+00:00
Milan 1 Reputation point
commented 2020-11-24T01:24:21.76+00:00
Daniel Zhang-MSFT 9,626 Reputation points
9 answers

How to replace a special character or punctuation in a string in SQL Server

I am prepping our data to make it a URL. But I've been into a lot of obstacle. If it's just a punctuation or some special characters, I can do nested REPLACE Functions and that is not a problem. What I'm dealing with right now is how to fully make it…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,954 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,651 questions
asked 2020-11-17T21:22:47.787+00:00
Louie E 1 Reputation point
commented 2020-11-24T01:20:43.347+00:00
EchoLiu-MSFT 14,581 Reputation points
0 answers

Azure Sentinel (Log) Analytics (Workspace)

Dear Sir/Madam, Use Case: Deploying a fast solution for the Mitre Att&ck Framework analysis: https://github.com/BlueTeamLabs/sentinel-attack/wiki Solution we seek: Mass Enable Categories of the Analytics Templates (ask for select, or…

Microsoft Sentinel
Microsoft Sentinel
A scalable, cloud-native solution for security information event management and security orchestration automated response. Previously known as Azure Sentinel.
1,151 questions
asked 2020-11-19T12:33:12.783+00:00
nwsentinel4 201 Reputation points
commented 2020-11-24T00:48:57.763+00:00
Marilee Turscak-MSFT 36,861 Reputation points Microsoft Employee
1 answer

SQL Hybrid benefit not able to change for SQL on Azure VM with 1 year or 3 year reservation

My question is regarding the azure pricing site (https://azure.microsoft.com/en-us/pricing/calculator/) , for the option of SQL Pricing on Azure VM. i am not able to change the SQL Hybrid benefit option ( to sql hybrid) for SQL on Azure VM with 1…

SQL Server on Azure Virtual Machines
asked 2020-11-23T11:25:30.78+00:00
MS Techie 2,701 Reputation points
answered 2020-11-24T00:46:59.653+00:00
whoward-msft 2,766 Reputation points
0 answers

CDS web hook associate event doesn't trigger

Hi, I followed these instructions to create a webhook for the associate/disassociate even in CDS: https://crmtipoftheday.com/1362/trigger-power-automate-on-associate-disassociate/ I checked with the pipedream tool to see if it triggers at all.…

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,191 questions
asked 2020-11-17T10:33:23.52+00:00
Frank Voortman 1 Reputation point
commented 2020-11-24T00:43:04.507+00:00
Mike Urnun 9,816 Reputation points Microsoft Employee
5 answers One of the answers was accepted by the question author.

Export from SQL Server to Excel, all text fields have a leading single quote

Using SQL Server 2019 I'm exporting data from a table to Excel, however, ALL cells with data have a leading single quote. The corrupts all the data. How can this be avoided? Thank you.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,954 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,651 questions
asked 2020-11-19T22:26:18.863+00:00
moondaddy 911 Reputation points
commented 2020-11-24T00:20:54.813+00:00
moondaddy 911 Reputation points
0 answers

Unable to connect the DR region Azure SQL DB from Primary region jump host using SSMS

Under SQL PAAS - firewall and virtual network option in DR region we can see only DR region vnets but not primary region vnets due to that we are unable to connect primary region SSMS to DR Region Azure SQL PAAS DB. Any idea ?

Azure SQL Database
asked 2020-11-19T02:22:14.053+00:00
Subramanya Jayaram 1 Reputation point
commented 2020-11-24T00:19:37.343+00:00
Navtej Singh Saini 4,226 Reputation points Microsoft Employee
0 answers

Azure AD can't seem to find my app

I'm developing a MATLAB application that uses the MSAL4J for authentication. When I call the function a browser tab is opened however when it attempts to sign it just gives me an error code. The client id and the authority seem to match the ones in Azure…

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,056 questions
asked 2020-11-16T18:49:02.037+00:00
Murats 6 Reputation points
commented 2020-11-24T00:13:58.947+00:00
JamesTran-MSFT 36,631 Reputation points Microsoft Employee
3 answers One of the answers was accepted by the question author.

Dynamic SQL in UDF - Work around

Hello everyone I have a 16 period fields in a schema, for example PreviousMonth where each date in the previous month has a value of 1 I trying to write a function that returns the Max date key dependant on the Field I pass in PreviousMonth,…

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,651 questions
asked 2020-11-23T13:54:22.89+00:00
ron barlow 411 Reputation points
answered 2020-11-24T00:07:52.107+00:00
Joe Celko 16 Reputation points
1 answer One of the answers was accepted by the question author.

error APT1000: Attribute "imageAspectRatioAdjust" already defined with incompatible format.

the following error comes out after changing the target platform from Android 8 to Android 9, 10 or 11. + updating dependencies + migration to AndroidX: \ obj \ Debug \ 110 \ lp \ 64 \ jl \ res \ values ​​\ values.xml (4): error APT1000: Found tag id…

Xamarin
Xamarin
A Microsoft open-source app platform for building Android and iOS apps with .NET and C#.
5,364 questions
asked 2020-11-23T12:18:53.837+00:00
Александр Р 116 Reputation points
accepted 2020-11-23T23:58:16.113+00:00
Александр Р 116 Reputation points
5 answers One of the answers was accepted by the question author.

Powershell and Published Data Orchestrator 2016

I am using Orchestrator 2016 with the reg change to make it use powershell 5. In Powershell ISE, I run this simple query for a remote box to check the status of Windows updates via WMI: $CCMUpdate = get-wmiobject -query "SELECT * FROM…

System Center Orchestrator
System Center Orchestrator
A family of System Center products that provide an automation platform for orchestrating and integrating both Microsoft and non-Microsoft IT tools.
230 questions
asked 2020-11-23T17:41:35.763+00:00
ben 21 Reputation points
commented 2020-11-23T23:36:37.053+00:00
Andreas Baumgarten 110.9K Reputation points MVP