SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,244 questions
1 answer
One of the answers was accepted by the question author.
Virtual Disk to install SQL 2016 on premise for Sharepoint 2019 On Premise
Hi All, My customer has 2 host servers both running HyperV and formatted as NTFS 4K cluster size. They have existing Exchange & file server running on virtual disk also formatted as NTFS 4K cluster. They want to installed Sharepoint 2019 on…
asked 2021-02-12T11:28:53.93+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(297.6, 49%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES1%3C/text%3E%3C/svg%3E)
Sebring-1261
61
Reputation points
commented 2021-02-15T07:48:16.803+00:00
JoyZ
18,046
Reputation points
1 answer
is it necessary for somebody to pass the Exam 70-764: Administering a SQL Database Infrastructure again?
Dear Pearson vue Team, is it necessary for somebody to pass the Exam 70-764: Administering a SQL Database Infrastructure again? I saw that it has been retired since 31st of December of 2021.
asked 2021-02-12T10:03:59.657+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(304, 11%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMY%3C/text%3E%3C/svg%3E)
Mawabo Yvonne
1
Reputation point
commented 2021-02-15T07:16:07.713+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
SQL server cluster error
I Have two SQL server (one of the server on live subnet ) and another SQL server in DR subnet ) When try to add the listener IP address it gives me the error number: 19456
asked 2021-02-14T10:06:16.89+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(185.6, 15%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHB%3C/text%3E%3C/svg%3E)
Hussain Bazzar
21
Reputation points
accepted 2021-02-15T06:55:04.777+00:00
Hussain Bazzar
21
Reputation points
1 answer
Flow control gates threshold value: 8192
Flow control gates threshold value: 8192 in availability groups. I found this value in Microsoft Learn during troubleshooting an AG secondary sync issue. can someone help me to understand what is 8192 messages and what will be the size of each message?
asked 2021-02-11T21:35:31.727+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(22.400000000000002, 99%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYG%3C/text%3E%3C/svg%3E)
yogi gollapudi
1
Reputation point
commented 2021-02-15T01:51:41.25+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Filegroups
The DB was using a primary file group with a data file. As the disk of the primary file group has got to full capacity, we have created secondary file group with 2 datafiles n set as default filegroup. However, data is being added to the primary file…
asked 2021-02-14T06:58:13.357+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(0, 83%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
abhishek ghosh
26
Reputation points
commented 2021-02-14T17:48:40.803+00:00
abhishek ghosh
26
Reputation points
3 answers
Mirror sync between two servers
Hi to everyone, We are going to deploy a mirror sync between two servers with Microsoft SQL Server 2019. Before this, we want to know whether the entire database is synchronised in the mirror or whether we have the option to choose individually which…
asked 2021-02-09T16:02:28.033+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(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' %3EO%3C/text%3E%3C/svg%3E)
OptimalPyme
1
Reputation point
answered 2021-02-14T11:30:22.883+00:00
Alex Bykovskyi
1,831
Reputation points
5 answers
One of the answers was accepted by the question author.
Seeing 833 event ids related to IO
Hi SQLTeam, We are seeing a lot of 833 events in windows Application log . This is one of the sub-prod SQL Server environments. When does an 833 event is logged? How can we mitigate such issues? Is there a dirty test we can do to simulate…
![](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(217.60000000000002, 34%, 31%)' 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)
4 answers
One of the answers was accepted by the question author.
Working with SQL Service Broker
Hi, Running SQL Server 2017. I have a requirement to send an email based on certain row conditions in a given table. The email is dynamic, and based on values contained in the row itself. My initial thought was to use an after update trigger,…
![](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, 2%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV7%3C/text%3E%3C/svg%3E)
4 answers
One of the answers was accepted by the question author.
Log growth in simple recovery model
My database is in simple recovery mode and log is growing very fast and space in disk is very less. There are 2 transaction is running in My database and the first transaction is running 20 mins earlier than second transaction. Both transaction still…
![](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(198.4, 42%, 29%)' 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)
1 answer
KQL query that can pull software license version of software installed on a server
Hello, I'm attempting to find/construct a KQL query that can pull software license version of software installed on a server. So far (3 hours of searching) my efforts have been for naught. If somebody could at least point me in the right direction I…
asked 2021-02-09T05:01:05.383+00:00
St John Jordaan
6
Reputation points
answered 2021-02-13T04:34:32.01+00:00
Stephen Correia
6
Reputation points
4 answers
One of the answers was accepted by the question author.
Can we create Database snapshot on secondary replica in AG
Dear Folks, is it possible to create database snapshot on secondary read replica in AG with resource governor limiting queries from application.?
asked 2021-02-05T16:08:14.287+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(70.4, 79%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYV%3C/text%3E%3C/svg%3E)
Yashwant Vishwakarma
116
Reputation points
accepted 2021-02-13T04:07:19.267+00:00
Yashwant Vishwakarma
116
Reputation points
5 answers
One of the answers was accepted by the question author.
SSMS error - Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server
Hi Cathy, I have a very similar problem as LouisDG_1517 : Machine A: Define linked server connection to machine/cluster C Machine B: Log on to the SQL server that's on machine A (via SSMS) Option 1. If user is logged in on machine A…
asked 2021-02-04T17:40:53.803+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, 88%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
shashi das
21
Reputation points
commented 2021-02-12T22:20:53.19+00:00
Erland Sommarskog
102.2K
Reputation points
5 answers
SQLserver Express connection error
I my VB2019 app and tried to run it in debug before I started editing it. However, I got this error message when the app opened a form with text boxed to be prepopulated with data from a SQLserver Express database: The attempt to attach to the database…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,872 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,603 questions
Visual Studio Debugging
Visual Studio Debugging
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Debugging: The act or process of detecting, locating, and correcting logical or syntactical errors in a program or malfunctions in hardware. In hardware contexts, the term troubleshoot is the term more frequently used, especially if the problem is major.
948 questions
asked 2021-02-09T21:12:14.953+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(6.4, 68%, 10%)' 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)
Duggan, Daniel
96
Reputation points
commented 2021-02-12T22:07:22.76+00:00
Erland Sommarskog
102.2K
Reputation points
1 answer
SQL21/19 on VMWare
DW Upgrade (VMWare with SSD or Physical box)? Good day, I am designing architecture for new DW that can handle paralism 3 tiers (Data storage, persentation, vizualizer) External company has done an assessment on the environment, the feedback is…
asked 2021-02-09T13:17:16.527+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(281.6, 39%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIC%3C/text%3E%3C/svg%3E)
Ismail Cassiem
226
Reputation points
answered 2021-02-12T20:07:19.123+00:00
Ismail Cassiem
226
Reputation points
2 answers
Process to move sccm DB?
So we have installed sccm and it's DB onto a single VM. But now we would like to move it's DB onto our dedicated clustered sql server. Is it as simple as just re-running the MS Endpoint config manager setup wizard and pointing it to our dedicated sql…
![](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(3.2, 15%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC4%3C/text%3E%3C/svg%3E)
6 answers
Exception calling "Fill" with "1" argument(s): "A network-related or instance-specific error occurred while establishing a connection to SQL Server.
Here's the main part of the PowerShell script. $databases = @("devDB.serverName.com/devTest") foreach($database in $databases) { #Query to find any failed login attempts yesterday $query = "SELECT * FROM error_log WHERE Text…
asked 2021-02-05T18:56:14.937+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(275.2, 3%, 36%)' 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)
CharlieLor
551
Reputation points
answered 2021-02-12T18:38:03.783+00:00
CharlieLor
551
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL Server licensing where SQL Server services are disabled
I've used the Microsoft MAP Toolkit to discover the SQL Server installations and SQL licensable components across the estate. The toolkit has reported on a number of servers where the SQL related services are no longer running and disabled. Are…
![](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(217.60000000000002, 33%, 31%)' 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)
1 answer
One of the answers was accepted by the question author.
JSON - multiple aggregations extremely slow
Select col1 ,sum(json_value(json_field,’$.col2’)) ,sum(json_value(json_field,’$.col3’)) ,sum(json_value(json_field,’$.col4’)) ,sum(json_value(json_field,’$.col5’)) ,avg(json_value(json_field,’$.col6’)) ,max(json_value(json_field,’$.col7’)) …
![](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, 8%, 12%)' 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)
2 answers
One of the answers was accepted by the question author.
SQL grouping
Hi all I'm trying to create a query that lists a group of records only when the last record of the group doesn't have a specific field value (trans<>'delete') key access trans date (mm/dd/yyyy) 1 adt add …
![](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(179.20000000000002, 22%, 27%)' 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)
2 answers
One of the answers was accepted by the question author.
Unable to run SSIS Package from a job using SQL Server Agent Service Account
I have a package that is set up on Server A, that is to go to Server B and copy a file from one folder to another. When I execute the package as myself under SSIS, the package runs fine, no problems, moves the file. When I set up a job to do the…
asked 2021-02-11T18:40:31.057+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, 89%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Julie Cherry
96
Reputation points
accepted 2021-02-12T15:14:12.993+00:00
Julie Cherry
96
Reputation points