99,748 questions

Sort by: Updated
Updated Created Answers
2 answers One of the answers was accepted by the question author.

Unexpected truncation error when inserting from UTF8 to non-UTF8 collation

I believe I am hitting a bug with moving data from a UTF8 to a non-UTF8 collations in SQL Server 2022 CU13 (running under Linux but assuming for now this issue is not related). The issue is that MSSQL appears to be determining the width of a string for…

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,078 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,579 questions
asked 2024-06-11T00:42:42.9533333+00:00
Ben 25 Reputation points
commented 2024-06-17T14:31:28.0233333+00:00
Ben 25 Reputation points
2 answers One of the answers was accepted by the question author.

Issues with update 22H2

I had an issue with my laptop's HDD showing 100% usage. I thought it might be a virus, so I decided to format my computer. Now everything is fine with a clean Windows installation and some of the programs already installed, the disk usage doesn't go…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
10,949 questions
Windows
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.
4,939 questions
asked 2024-06-14T20:18:25.1433333+00:00
Roberto C 100 Reputation points
accepted 2024-06-17T14:27:58.62+00:00
Roberto C 100 Reputation points
1 answer One of the answers was accepted by the question author.

Looking in message tracking logs does not show message which is received

Goodday, We have a hybrid environment. The mail flow is as described: 1/ Incoming message passes the first antispam server 2/ then it is sent to the on-prem Exchange Server 3/ on-prem we see that the message has been sent via the…

Microsoft Exchange Hybrid Management
Microsoft Exchange Hybrid Management
Microsoft Exchange: Microsoft messaging and collaboration software.Hybrid Management: Organizing, handling, directing or controlling hybrid deployments.
1,954 questions
asked 2024-06-11T08:18:06.0466667+00:00
Kurt Stichelmans 561 Reputation points
accepted 2024-06-17T14:23:04.9+00:00
Kurt Stichelmans 561 Reputation points
4 answers One of the answers was accepted by the question author.

Query on SQL Server HA and DR

Hi All, we have configured sql server always on failover cluster (two nodes) and both DB nodes are hosted on same DC. Application is using Listener IP to connect DB. HA: Avoid service impact during planned or unplanned events DR: Business continuity As…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,538 questions
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,078 questions
asked 2024-06-06T14:04:31.94+00:00
PraveenKumar 236 Reputation points
accepted 2024-06-17T14:10:15.4933333+00:00
PraveenKumar 236 Reputation points
4 answers One of the answers was accepted by the question author.

SQL Server Backup and Restore

Hi All, Currently we are taking two backups for the same DB - one from sql agent (custom script without copy_only option) and another one from third party backup tool (without copy_only). The backup strategy is same for both. .. Full backup: every day…

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,078 questions
Windows Server Backup
Windows Server Backup
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Backup: A duplicate copy of a program, a disk, or data, made either for archiving purposes or for safeguarding valuable files from loss should the active copy be damaged or destroyed.
459 questions
asked 2024-06-06T13:51:20.86+00:00
PraveenKumar 236 Reputation points
accepted 2024-06-17T14:09:43.4866667+00:00
PraveenKumar 236 Reputation points
1 answer One of the answers was accepted by the question author.

Azure Synapse fails to load Lake Databases (500 error)

When loading a Synapse workspace, it sits at "loading resources" for awhile and eventually errors with a 500 for lake databases. The error is not particularly helpful. Any ideas on how I could potentially determine if it's a single data lake…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,554 questions
asked 2024-06-11T20:11:33.8566667+00:00
Timothy Dufrane 20 Reputation points
accepted 2024-06-17T13:58:15.3433333+00:00
Timothy Dufrane 20 Reputation points
2 answers One of the answers was accepted by the question author.

Add-SPO error on custom theme

Hi, I'm trying to add a custom color theme to a corporate SharePoint Online environment. Following a couple of YouTube videos led me to the code below. However, when I run using PowerShell IDE or SharePoint Online Management Shell I get the following…

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,022 questions
asked 2021-03-11T01:47:02.367+00:00
DB Shottie907 21 Reputation points
commented 2024-06-17T13:54:55.2966667+00:00
Daniel Moura 0 Reputation points
2 answers One of the answers was accepted by the question author.

HTTPs Listener

Hi All, We have an HTTPs server application written in C# with .Net Framework 4.7. The application uses HTTPs Listener class to listen to incoming HTTPs requests. In order to make HTTPs server work, we bind the certificate 'Thumbprint' in a batch file…

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.
10,484 questions
asked 2024-01-19T10:31:42.5666667+00:00
S Abijith 346 Reputation points
commented 2024-06-17T13:52:25.4333333+00:00
Pinaki Ghatak 2,480 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

Get Global Primary details from All the replicas in Distributed AlwaysOn

In Distributed AlwaysOn, I could not find any DMVs in SQL Server which could provide the details about Global Primary from replicas in Forwarder side (both Primary Forwarder and its local replicas). Is there a way to at-least pull the Global Primary…

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,078 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,579 questions
asked 2024-06-10T14:06:34.08+00:00
Sajal Bagchi 25 Reputation points
accepted 2024-06-17T13:39:37.6566667+00:00
Sajal Bagchi 25 Reputation points
1 answer One of the answers was accepted by the question author.

Unable to reschedule Microsoft Fabric exam

While I'm trying to attempt Microsoft Fabric exam the Pearson vue didn't allow me for test due to some connectivity issue. Proctor told he will initiate the reschedule option. But I didn't get the option in my account for reschedule. Please help me out…

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,010 questions
asked 2024-06-17T07:14:13.63+00:00
Vengadeshwari K 0 Reputation points
accepted 2024-06-17T13:37:38.89+00:00
Vengadeshwari K 0 Reputation points
1 answer One of the answers was accepted by the question author.

How can I change (and lock?) the default Authentication Method for users to Authenticator app?

Hey all We currently have the Authenticator App and the SMS messages methods available for Authentication Methods. I'm hoping that I could make the default method the Authenticator App and ideally lock it to be the Authenticator app but perhaps leave the…

Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
5,838 questions
asked 2024-06-13T18:59:24.72+00:00
Nick Marchese 20 Reputation points
accepted 2024-06-17T13:35:25.9833333+00:00
Nick Marchese 20 Reputation points
1 answer One of the answers was accepted by the question author.

Cannot abandon Azure B2C Organization after deleting the service

Hello, Some tome ago, I created an Azure B2C instance. I added my Azure user as administrator. I think I made a mistake, and somehow deleted the Azure B2C instance but the tenant keep existing and my user is still linked to that tenant's…

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,109 questions
asked 2024-05-30T08:34:29.3833333+00:00
Rodrigo Liberoff Vázquez 71 Reputation points MVP
accepted 2024-06-17T13:30:12.7+00:00
Rodrigo Liberoff Vázquez 71 Reputation points MVP
1 answer One of the answers was accepted by the question author.

Windows times out after 3 minutes of inactivity despite GPOs

I have rolled out one Computer policy that does the following: Specify the unattended sleep timeout (on battery) Enabled Unattended Sleep Timeout (seconds): 1800 Specify the unattended sleep timeout (plugged in) Enabled Unattended Sleep Timeout…

Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,625 questions
asked 2024-06-14T12:03:51.1133333+00:00
MicrosoftSufferer 0 Reputation points
accepted 2024-06-17T13:15:08.9733333+00:00
MicrosoftSufferer 0 Reputation points
2 answers One of the answers was accepted by the question author.

Licensing windows server - user CAL

Dear community, Please help me with the licensing question. We have in our pipeline a number of digitalization projects that will include a DMS component that is run on a Windows Server. The DMS is in .NET and it will use the IIS on that windows server.…

Windows
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.
4,939 questions
asked 2024-06-14T12:12:48.07+00:00
stelea alexandru 0 Reputation points
accepted 2024-06-17T13:11:58.4533333+00:00
stelea alexandru 0 Reputation points
1 answer One of the answers was accepted by the question author.

Is it possible to route all vnet traffic back down a VPN tunnel when peered in hub and spoke

I have one Virtual Network Gateway in an hub network and two spoke vnets connected to it. Is it possible to route all vnet traffic down the VPN tunnel (override the gateway routes) to on-premises firewall or would it require an additional VPN to separate…

Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,227 questions
asked 2024-06-12T11:15:20.8933333+00:00
Simon Windeler 20 Reputation points
accepted 2024-06-17T13:06:20.9366667+00:00
Simon Windeler 20 Reputation points
1 answer One of the answers was accepted by the question author.

How to deploy azure landing zones

Detail network and hub spoke

Azure Network Watcher
Azure Network Watcher
An Azure service that is used to monitor, diagnose, and gain insights into network performance and health.
160 questions
asked 2024-06-15T13:36:36.53+00:00
Luciano Jose Marchetto 20 Reputation points
accepted 2024-06-17T13:05:33.6833333+00:00
Luciano Jose Marchetto 20 Reputation points
1 answer One of the answers was accepted by the question author.

Migrating Sentinel DNS event connector from legacy agent to AMA

Hi I am in the process of migrating the Sentinel Windows security and DNS data connectors from the legacy agent to AMA. We use the DNS audit log 519 events to resolve device names from ip addresses where the device name is not returned in a lookup query.…

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,020 questions
asked 2024-06-05T10:08:43.27+00:00
Louise Atyeo 0 Reputation points
accepted 2024-06-17T13:04:29.7+00:00
Louise Atyeo 0 Reputation points
1 answer One of the answers was accepted by the question author.

Azure Data Factory - mark source rows as "processed"

I wan't to read unprocessed data from asource table and write it to a target table. Normally, in other ETL Tools, I would add a "processed" flag column to sourceTable update it after successfully insert into targetTable with…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,898 questions
asked 2024-06-14T10:41:55.6066667+00:00
Jörg Lang 80 Reputation points
commented 2024-06-17T13:03:05.0166667+00:00
Sina Salam 5,551 Reputation points
2 answers One of the answers was accepted by the question author.

What is stored procedure vs sql loader

I'm reviewing some system setup on SQL server and for inbound data we use a stored procedure and outbound we are using the something called SQL Loader. Like a definition of both and tools that could be used. I'm the business analyst and lot of…

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,078 questions
asked 2024-06-14T18:48:46.0466667+00:00
Jonathan Brotto 160 Reputation points
accepted 2024-06-17T12:58:04.2166667+00:00
Jonathan Brotto 160 Reputation points
1 answer One of the answers was accepted by the question author.

Accessing Azure Synapse Dedicated SQL Pool Using PySpark Without Exposing Passwords

I want to create a notebook for processing data in a table from the database using PySpark, to be used later in a Databricks pipeline. I'm unsure how to read data from the existing database in the notebook without including my password. Here is my…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,554 questions
asked 2024-06-14T08:38:35.8933333+00:00
Vandrangi Charaz Kumar 20 Reputation points
accepted 2024-06-17T12:51:17.3066667+00:00
Vandrangi Charaz Kumar 20 Reputation points