if you are using SQL 2016 or later, it's very easy:

select format(getdate(), 'MM-dd-yyyy'), format(getdate(), 'MM-yy')

;

if not, it's still possible with date related functions.

is nightly replication good enough or more frequent replication is not allowed? If more frequent replication is ok, you may try transactional replication or merge replication, both were supported by...

this is almost impossible, unless 1)both successful login and failed login were logged(default to failed only); and 2)linked server to your instance uses a special user that's not used for...

google is your friend. A simple search landed this url:

https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15

Google is your friend. Please review the blogs. Andy Leonard probably did more SSIS related work than most members on this site.

(Attempting to) Upgrade the SSIS Catalog to SSIS 2016

this is very common when SSISDB was restored from another server. Please follow this article:

https://blog.pythian.com/how-to-restore-ssisdb-to-another-server-and-migrate-the-ssis-catalog/

I use SSIS heavily and I upgraded numerous SSIS packages from SQL 2008/2008R2 to SQL 2016, including ETL from multiple SQL servers to SQL server; exporting data from SQL server...

Are you sure you asked the correct question? From SQL Server 2008 and onward, I never heard of a patch for INTEL vs for AMD. There are patches for 32...

Yes, offline database data files can be deleted, I believe that's the top 1 reason why a data file was orphaned, drop an offline database will leave the data files...

the graph says it clearly, "total duration", 30 seconds per execution x 1000 times = 30,000 seconds.

you need to switch to Avg, the y-axis would display "avg duration", which should...

not sure. On my dev box with 32GB memory, with 12.2 driver, SSIS took >30GB; with 12.1 driver, it's less than 1GB. I didn't go back to ODAC 12.2 since...

I observed the same when using Oracle ODAC to set up linked server.  Plus, there was a memory leak when using the Oracle 12.2 driver,  I deinstalled and installed Oracle 12.1...

I used Oracle ODAC  from https://www.oracle.com/database/technologies/odac-downloads.html. 64bit on 64-bit sql server box is enough; to debug, you also need 32bit since VS2017 is 32bit only.

It's very similar to this blog from 9 years ago:

https://sqlorcl.wordpress.com/2011/04/26/integration-service-is-running-on-dynamic-port-can%E2%80%99t-connect-remotely/

Based on MS doc, "Integration Services service always uses port 135. You cannot specify a different port.", it seemed...

if the pattern is "PQ5|1|896^^^^57", where "896" is  three-digit(ddd), "57" is two-digit(dd), this also works:

where col like '%PQ[0-9]|[0-9]|[0-9][0-9][0-9]^^^^[0-9][0-9]%'