SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,866 questions
1 answer
One of the answers was accepted by the question author.
Replace a Cursor to For Each loop for SSIS package
Hi all, I'm new to SSIS, currently I facing issue when create a SSIS Package by using Cursor. Here with the Cursor I written use TestDB DECLARE @storedprocedure_name varchar(100) DECLARE @cmd VARCHAR(4000) …
asked 2020-12-04T05:38:28.353+00:00
![](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(307.2, 22%, 39%)' 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)
Eng Soon Cheah
81
Reputation points
accepted 2020-12-05T14:42:53.557+00:00
Eng Soon Cheah
81
Reputation points
1 answer
One of the answers was accepted by the question author.
volume bar in windows 10
Hi, I wanted to hide the volume pop-up(volume bar) on windows 10. ![43738-image.png][1] Is there any way we can hide it using registry or using group policy setting? Thanks, [1]: /api/attachments/43738-image.png?platform=QnA
asked 2020-11-30T15:28:44.2+00:00
![](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, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
accepted 2020-12-05T14:32:33.2+00:00
Anonymous
1 answer
One of the answers was accepted by the question author.
Move block of data SQL
I have a problem finding a good way of moving data in a table without using a while loop. I need to move the data in the table one step ahead. See my SQL code. Looping trough the data with a while loop is too slow a process. My question is, is it…
asked 2020-12-04T11:34:58.69+00:00
![](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, 73%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Leif Nyström
21
Reputation points
accepted 2020-12-05T14:18:02.887+00:00
Leif Nyström
21
Reputation points
1 answer
Scheduled exam not showing up in portal
i have scheduled AZ-900 - Microsoft Azure Fundamentals exam on Sunday, December 6, 2020 but its not showing in exam appointment section and also i have received an email confirmation with the following details. I did contact pearson vue they confirmed…
asked 2020-12-05T09:59:38.823+00:00
![](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, 32%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Aswini Thamatam
1
Reputation point
answered 2020-12-05T13:39:47.567+00:00
Anonymous
5 answers
MS Threat Modeling Tool Stencils
Is there a template containing stencils for Azure and for desktop applications, or can 2 stencils be loaded or combined? I have a medical device application with an on-premise and cloud component hosted in Azure. It seems when I load the Azure template,…
asked 2020-07-06T16:49:53.79+00:00
![](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(16, 22%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELG%3C/text%3E%3C/svg%3E)
Larry Greenspan
1
Reputation point
answered 2020-12-05T12:03:33.583+00:00
![](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(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Bob_Lazar
1
Reputation point
0 answers
Problems with the windows explorer windows 10
When copying pictures from a smartphone to a new computer (Windows 10) using the Explorer, not all pictures are transferred (only about 300 of 500). The copying process starts properly and seems to end properly. no error message appears. the error is…
asked 2020-12-05T11:48:01.45+00:00
![](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(278.4, 59%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Gerhard Pollach
1
Reputation point
asked 2020-12-05T11:48:01.45+00:00
Gerhard Pollach
1
Reputation point
1 answer
WPF rendering a Viewport3D to RenterTargetBitmap changes RGB values
I'm trying to render a Viewport3D with textured triangles to a RenderTargerBitmap. But the colors in the bitmap are different than in the viewport: Right side: an actual in-app Viewport3D. Left side: the RenderTargetBitmap shown in a…
![](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(112.00000000000001, 55.00000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Schedule powershell script to delete old ACR image
Hi Guys, I have the below script which is working fine from local PowerShell to delete older ACR images. Now I want to schedule it so that it can run periodically maybe through run book, pipeline, or any other suitable way if you guys can suggest? I am a…
asked 2020-12-04T15:17:35.247+00:00
![](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(57.599999999999994, 42%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mishra, Rajiv
51
Reputation points
commented 2020-12-05T11:19:30.393+00:00
Mishra, Rajiv
51
Reputation points
3 answers
One of the answers was accepted by the question author.
Barracuda disabling TLS1.0, 1.1 and SSLv2/SSLv3
Hi, The below article explains that Barracuda Cloud are going to disabling support for TLS 1.0 and 1.1 and SSLv2/v3. https://campus.barracuda.com/product/essentials/doc/91981918/tls-with-insecure-ciphers-and-sslv2-sslv3-no-longer-supported/ I 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(80, 2%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Windows Autopilot - How to customize Windows 10
Hi I have done a Windows AutoPilot to a PC but its very from scratch , only a clean install How I do a changes for a example join to domain and install applications and other things ? Please help , grateful for answer Sokoban --- xxx ---
1 answer
Winforms High DPI support
Several controls MenuStrip, ToolStrip, StatusStrip and ToolStripComboBox all behave badly on 4K monitors with 250% scaling. The ComboBox when DropDownStyle is set to ComboBoxStyle.Simple shows a 1 line list below the box with the selected item shown.…
asked 2020-12-05T04:08:36.697+00:00
![](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(259.20000000000005, 92%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PaulMCohen
1
Reputation point
answered 2020-12-05T09:31:05.307+00:00
Castorix31
85,541
Reputation points
3 answers
SSRS Reports do not show any data
I am working with SQL Server Data Tools 2017. I have earlier also used SSRS reports. But it is strange that I am finding. The dataset keeps on refreshing | hanging. While creating a dataset Added a dataset with simple query …
asked 2020-11-02T13:19:57.137+00:00
![](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(195.2, 63%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Munish Arora
1
Reputation point
answered 2020-12-05T08:09:43.79+00:00
Munish Arora
1
Reputation point
3 answers
One of the answers was accepted by the question author.
How to get default column values during upload using pnp shell?
Hello, I have a document library. In that library I have root folders and sub folders. Is that possible to get folders values (root/sub folder) into two columns when user will upload from inside of the sub-folder using PnP shell? I know I could achieve…
![](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(204.8, 75%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Use db not working on azure
I'm using SQLCMD in bash script and it works well. But when I do target Azure SQL Server I got an error for using statement. Here is my command: sqlcmd.exe -S DBserverName -U username -P p@ssword -i "C:\query.sql"
asked 2020-12-05T05:40:54.263+00:00
![](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(140.8, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
Tes Gam
81
Reputation points
commented 2020-12-05T05:48:04.563+00:00
![](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(112.00000000000001, 74%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
YASER SHADMEHR
781
Reputation points
1 answer
One of the answers was accepted by the question author.
jar deploy problem
I want to deploy in web app as jar. So I deleted start html file and uploaded my jar file. Then restart my server. But when I enter my server url I just see start html page. Also when I enter l7check page I get 404 error. I uploaded my jar file…
asked 2020-12-04T08:04:26.437+00:00
![](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(19.2, 85%, 11%)' 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)
saltycheeez
21
Reputation points
accepted 2020-12-05T05:02:45.24+00:00
saltycheeez
21
Reputation points
0 answers
ADFS DRS Service won't start
Our Device Registration Service is unable to start and is impacting our WAP setup The error in the event log is below. Any ideas? The description for Event ID 0 from source Device Registration Service cannot be found. Either the component that raises…
asked 2020-11-29T18:03:24.86+00:00
![](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(252.8, 3%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Paul Rimmer
1
Reputation point
commented 2020-12-05T04:00:07.857+00:00
Pierre Audonnet - MSFT
10,186
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure synapse: What's the transaction log size limit of the database
What's the transaction log size limit of the database ? and also how to monitor the transaction log usage? from Azure monitor metric? And also how to monitor the database size of the DW ?
![](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(137.6, 40%, 23%)' 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)
3 answers
One of the answers was accepted by the question author.
best practice to configure baseaddress URI in MVC Core
Hi I have created an MVC and Web Api project. When consuming web Api endpoints I am using the complete Uri as showing below. string apiUrl = "http://localhost:57025/api/Mypage; ON every single data class I am keep adding the full uri…
![](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(265.6, 23%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Configuration Manager Client Upgrade Package
Hello, Under \Monitoring\Overview\Distribution Status\Content Status\ I see multiple Configuration Manager Client Upgrade Packages ... UCP00003 & UCP0035F... I . Why? Which one(s) is(are) used? I did not see them under…
asked 2020-12-04T15:28:05.127+00:00
![](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, 92%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Dominique DUCHEMIN
831
Reputation points
accepted 2020-12-05T02:44:11.053+00:00
Dominique DUCHEMIN
831
Reputation points
1 answer
Error validating ARM template. Max retries exceeded with url
I want to validate my ARM template with changing the "location", "customData" parameters but I can not do so as i got error below: [2020-12-03T02:54:47.208Z] + az deployment sub validate --location southeastasia --template-file…
asked 2020-12-03T04:49:55.443+00:00
![](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, 13%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Alif Alimi
1
Reputation point
answered 2020-12-05T02:24:49.427+00:00
![](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(118.4, 98%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KarishmaTiwari-MSFT
20,052
Reputation points Microsoft Employee