Doesn't look like you deleted the user since abc@gmail.com still exists in the table. The error is what the message is telling you - abc@gmail.com already exists in...

Those are from virtual accounts for SQL Server. You can find more information on the virtual accounts in the documentation on service accounts:

Configure Windows Service Accounts and Permissions

Sue

It would depend on what type of user you are creating - contained? Mapped to a login? There are different options. You  can find examples of the different types in...

Automatic tuning was added in SQL Server 2017 and is available in Azure.  Azure has the automatic index tuning. You can find more information on these in the following documentation:

It was introduced in 2016 for data feeds. Usually it's referred to as data feeds or atom feeds. You generate data feeds from reports using the Atom extension. You click...

Disk reads, writes and percentages of reads, writes in and of themselves don't necessarily hurt performance or mean that much. It's latency with your reads, writes that impact performance. It...

Those GUIDs you see for the full backups were taken by some other backup software, usually using VSS. You can see those with some server backups where they include doing...

Next time or on the source databases, you may also want to check the number of VLFs in the log file as an excessive number can also slow the recovery...

As indicated in the documentation, CONCAT_WS is only available with SQL Server 2017 and higher:

CONCAT_WS (Transact-SQL)

Sue

At my workplace, we have our backups running on a server with failover to 2 other servers.  So unless all 3 servers are offline, our backups continue to...

Looks to be fixed - Just tried it again and it worked fine on Firefox.

Sue

I just tried on Firefox 78.0.2 and had the same results...just Please Wait on the button on nothing else happens. An old version of IE or Edge works. Looks like...

Hi All,

I tried to create a login and give Server Role Public and Database role db_datareader but user can see all databases, not accessible but still see the other...

It's safe to create them, it's just several small objects. It will create a system table in the database called sysdiagrams and several stored procedures, function that support the diagrams....

A linked server to be used as part of a job wouldn't have anything to do with xp_prop_oledb_provider. As I said, that extended stored procedure would be needed to browse...