We have had failures in the past due to networking issues, but those have always been caught.  I am trying to figure out how this time the inserts failed...

For unit testing, you may want to look at tsqlt - an open source unit testing framework: tsqlt

Sue

There are too many variables to guess how long it will take - number of articles and data, metadata needed for those articles, hardware, network latency would all play a...

It creates one by default. You wouldn't need to back it up just like you wouldn't need to back up a database for it to work. But if you need...

One time backup is fine. You don't need to back it up again when reports, data sources are changed or added.

Sue

One option with Powershell is to use dbatools and the cmdlet Update-DbaInstance. You can find more information on that cmdlet in this link: Update-DbaInstance

An example of how to use...

Primarily pen and paper. But I have been using Apex SQLModel for the past year or so. It's a pretty good and it's free. For now anyway.  https://www.apexsql.com/sql-tools-model.aspx

Sue

When you created the subscription, you said you "didn't choose initialize when creating the subscription". If you mean you cleared the check in the checkbox for initializing then that is...

Try using Openquery to execute the Sybase stored procedure. It may or may not work. You would want to post the exact error message and error number when you get...

Thanks for posting back - that makes sense. Another option would be to just skip the part of deleting the account from Active Directory when you do the uninstall and...

The Folder Settings on the top menu bar is for the Home settings. For a specific folder, Hover your mouse over the folder and a drop down appears on the...

Are you using SSL? Knowing that would be a good place to start. The error is for a self signed certificate and if you are using those and SSL, the...

The changes you need are already in one of your other posts on this issue - refer to:

https://www.sqlservercentral.com/forums/topic/ssis-83#post-3729844

Sue

Yes you can query it. When you enable it there are several different DMVs that are available to use with the query store. You can use it to understand query...

Disable Publishing and Distribution can be easy but you can also run into errors at times, usually if you have some type of inconsistency with the meta data. But it...