Viewing 15 posts - 2,866 through 2,880 (of 6,041 total)
Gary Varga (2/15/2016)
February 15, 2016 at 6:52 am
SSIS is an ETL tool, so you would use it to copy data to and from Oracle. If what you want is to query data from Oracle, then you'll need...
February 12, 2016 at 3:19 pm
If you have to ask, then the answer is probably yes, at least to some degree.
February 12, 2016 at 2:16 pm
What we need are a clique of popular MVPs to start applying negative peer pressure.
"You're still using SQL Server 2000 and 2005??? Ew! Seriously.. dudes, that is like.....
February 12, 2016 at 11:39 am
Another issue is when a domain group (ie: MYCORP\ProductionDBA), which is a member of SYSADMIN sqlserver group, has a new domain member added. That doesn't trigger any event or meta...
February 12, 2016 at 9:36 am
I'm thinking about setting up a pre-production instance, perhaps just Express Edition, for which to smoke test deployment scripts prior to deployment on production. So the scripts go from UAT...
February 11, 2016 at 2:51 pm
It seems you're just getting started as a DBA administering SSIS and already looking for general advice on how best to approach it. So, that's good. At this point maybe...
February 11, 2016 at 2:19 pm
mjh 45389 (2/11/2016)
February 11, 2016 at 12:11 pm
Yes, back a few weeks ago, there was a similar post concerning slow initial connections for SSMS.
February 11, 2016 at 11:55 am
Is the same issue repeatable for both virtual and physical servers?
February 11, 2016 at 9:54 am
They ten years was their estimate to replace the entire system. It shouldn't take even one year just to upgrade their network and patch security holes. Typical of most government...
February 11, 2016 at 7:15 am
Orlando Colamatteo (2/10/2016)
Hugo Kornelis (2/10/2016)
True. And one might debate whether or not an interval that ends before it even starts is able to overlap with other intervals or not.
I think...
February 11, 2016 at 7:06 am
Hugo,
My script returns the duplicate listed below, but your's appears to return none.
MemNoYMDStart YMDEndYMDStart YMDEnd
417 2001-10-01...
February 10, 2016 at 1:21 pm
Install the free tool SQL Sentry Plan Explorer. Also, to further trick out your SSMS, while you've got the hood up, add your DBA scripts collection to the 'Code Snippets...
February 10, 2016 at 1:12 pm
Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Named Pipes Provider: Could not open a connection to SQL Server [2]. ".
Is your SSIS package attempting to make connection to a...
February 10, 2016 at 12:16 pm
Viewing 15 posts - 2,866 through 2,880 (of 6,041 total)