Legality is not the question, love for your fellow humans, their health, and the health of their loved ones is the issue. There is no question I desperately want...

Both SQL Audit and Extended Events (which Audit builds on) will do this for you. Here's an XE session I created to capture all queries executed against a specific database...

frederico_fonseca is correct, you should be using parameterized queries. Your current method is prone to SQL injection problems and you need to always account for those. Simply escaping strings (replacing...

What problem are you attempting to solve here?

What you're observing is normal SQL Server memory behavior. SQL Server will, if it deems necessary, use all the memory it's configured to...

• This reply was modified 4 years, 9 months ago by  alevyinroc.

• Do you need new features in 2019? You say you don't, so I would say...probably not.
• Are you migrating the databases on your 2017 instance to a new instance?...

I've seen a few occasions where Intellisense caused a bit of a slowdown because it was trying to scan through the schema to get table & field names (for example).

If...

Were you asked to change just the name of the service account, or to change the account the service runs under entirely (perhaps to use a domain account)?

To satisfy the first need, you can use Get-DbaServerRoleMember to fetch all members of the sysadmin role.

$ListOfInstances = @("Instance1","Server2\Instance2");
$Sysadmins = Get-DbaServerRoleMember -SqlInstance $ListOfInstances -ServerRole sysadmin |...

• This reply was modified 5 years, 1 month ago by  alevyinroc.

dbatools has functions to copy pretty much everything. For your particular scenario, you'll be interested in Copy-DbaDatabase (allows you to copy via backup/restore, detach/attach, or by restoring the last...