Viewing 15 posts - 16 through 30 (of 89 total)
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...
November 3, 2020 at 10:11 pm
google is your friend. A simple search landed this url:
October 28, 2020 at 2:23 am
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
October 24, 2020 at 8:11 pm
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/
October 7, 2020 at 11:14 pm
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...
September 27, 2020 at 7:54 pm
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...
September 22, 2020 at 2:54 am
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...
September 21, 2020 at 10:41 pm
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...
September 16, 2020 at 11:51 pm
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...
August 12, 2020 at 5:01 pm
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...
August 12, 2020 at 1:48 am
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.
August 10, 2020 at 10:32 pm
It's very similar to this blog from 9 years ago:
Based on MS doc, "Integration Services service always uses port 135. You cannot specify a different port.", it seemed...
July 16, 2020 at 12:43 am
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]%'
June 26, 2020 at 12:17 am
You may install SSMS 17.9.1 side-by-side with SSMS 18.x. I usually don't jump on the latest version since the latest <> the greatest.
June 17, 2020 at 9:49 pm
based on Microsoft doc, SQL 2016 Enterprise Edition cannot be installed on Windows 10 Enterprise(on Windows Server 2012 or newer only, no client version like Windows 10/8.1/8), but your screenshot...
June 17, 2020 at 12:01 am
Viewing 15 posts - 16 through 30 (of 89 total)