Forum Replies Created

Viewing 15 posts - 2,866 through 2,880 (of 6,041 total)

  • RE: An Age of AI?

    Gary Varga (2/15/2016)


    I used to be concerned about the possibility of a corporate AI issue (a la Skynet), however, I am now more concerned that individuals will cause regular and...

  • RE: Can SQL Server 2012 be connected with Oracle?

    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...

  • RE: Help to optimize a SP

    If you have to ask, then the answer is probably yes, at least to some degree.

  • RE: The Push to Upgrade from SQL Server 2005

    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.....

  • RE: Sysadmin role change notification

    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...

  • RE: What is the True Version of Code?

    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...

  • RE: SSIS - New Implementation

    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...

  • RE: Reasonable Timeframes

    mjh 45389 (2/11/2016)


    Some years ago the company I was working for then brought in a new support manager whose experience was in engineering manufacture but not IT. He devised a...

  • RE: Extremely slow initial connection using ssms

    Yes, back a few weeks ago, there was a similar post concerning slow initial connections for SSMS.

  • RE: Extremely slow initial connection using ssms

    Is the same issue repeatable for both virtual and physical servers?

  • RE: Reasonable Timeframes

    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...

  • RE: Check if date ranges overlap

    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...

  • RE: Check if date ranges overlap

    Hugo,

    My script returns the duplicate listed below, but your's appears to return none.

    MemNoYMDStart YMDEndYMDStart YMDEnd

    417 2001-10-01...

  • RE: Personalising SSMS

    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...

  • RE: package doesn't run when moved to production server

    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...

Viewing 15 posts - 2,866 through 2,880 (of 6,041 total)