Wow - did not expect to see my account in that list.

It would really help if you would at least try testing a solution

$queryResults = Invoke-Sqlcmd -ServerInstance servername `
         ...

• This reply was modified 3 years, 9 months ago by Jeffrey Williams.

I am not going to respond to the licensing aspects - but I would recommend upgrading the OS to Windows Server 2022 for the SQL Server system.  The only reason...

I'm not opposed to xp_cmdshell, and was wanting the csv files to be pipe(|) delimited. These 3 files will be used in a P/S import process to SQL as...

BTW - don't use this:

 $parameter = $sqlCommand.Parameters.AddWithValue("@param1",$param1Value);

.AddWithValue defaults to nvarchar data type and will cause all sorts of performance issues.

Instead of reinventing the wheel - why not download dbatools from https://dbatools.io/ and use them instead?  Not sure why you are only backing up the database if the size is...

Can't answer that question - have you tested it and does it work as expected?  All I can do is provide suggestions - you need to implement a solution that...

That is also one of the problems with creating a 'sample' query that isn't the same as the actual query being executed.  If you had posted the original query as-is...

I think you will have much better luck in a forum for C# or Powershell.  There is nothing built into SSIS or SQL Server that does this type of work.

I...

There is a difference between transaction log backups and differential backups.  If your databases are in full recovery model - you must take transaction log backups and I recommend those...

In synchronous mode - data needs to be hardened on the secondary before it can be committed on the primary.  That could have a significant impact on the performance -...

Not sure if that will work or not - you need to test and validate.  I personally wouldn't setup code to execute SQL queries - I would use the built-in...

The practice is closing on May 1 due to my wife's retirement.  The EHR and SQL will have to hang around for collections and patient records, but I doubt...

This is a EHR software package.  It has 1360 tables and I assume everything has date tags, but access to folks that actually understand the structure is not a...

Use either extended events or profiler to monitor the session from the DMZ.  If everything works from the LAN with no issues - but you see issues like this from...