Forum Replies Created

Viewing 15 posts - 4,861 through 4,875 (of 6,041 total)

  • RE: Reporting on Data

    phonetictalk (7/9/2013)


    I'm surprised (or I'd be surprised) that there isn't a way to automatically audit Excel sheets for these sorts of mistakes. I know Excel will highlight if a formula...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Reporting on Data

    In addition to formulas not being replicated properly, another problem is when a cell that appears to contain a numeric value is treated as text by Excel, because it contains...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Your Frame of Reference

    Somewhat related... Oracle has a feature called "Flashback" that leverages the transaction log to query the state of data for any table at a point in time using the "AS...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Better Technical Interviews

    Where I work, we don't hire entry level developers straight out of university, or at least not on the database side. Every interview I've participated in has been with candidates...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Better Technical Interviews

    Ed Wagner (6/27/2013)


    I like the idea of having interviewers conduct interviews of some existing employees. We have to be able to separate a strong candidate who interviews poorly from...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: More Data Security Issues

    djackson 22568 (6/26/2013)


    Eric M Russell (6/26/2013)


    I don't think that Microsoft can be faulted for insecure data. The database, network, and operating system framework that Microsoft has provided us is solid...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: More Data Security Issues

    I don't think that Microsoft can be faulted for insecure data. The database, network, and operating system framework that Microsoft has provided us is solid when it comes to security....

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Linked Primary Keys after INSERT within the same table

    TBIG (6/23/2013)


    I need to do an INSERT for a subset of records in a table to the same table. What is the best way to determine the primary key of...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: To merge several tables into one

    tania 56573 (6/5/2013)


    Hi there,

    My company has several instances of the same app. One app/database per client. Now maintenance has become a nightmare. I want to combine all into one. The...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Deleting Large Volumes of records

    If this is something like an audit log that's accumulates GB of data and is only occasionally queried, then you want to consider inserting these records into an external file,...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: More Data Security Issues

    djackson 22568 (6/25/2013)


    I agree that developers need to get better at using proper techniques.

    That said, companies are the real root cause of poor software. The opposition to allowing time...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: More Data Security Issues

    Gary Varga (6/25/2013)


    Eric M Russell (6/25/2013)


    By and large, employees are granted more access to data than they really need to perform their job functions. I'm surprised when people talk about...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: More Data Security Issues

    By and large, employees are granted more access to data than they really need to perform their job functions. I'm surprised when people talk about a database with dozens or...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: SQL Server Should Work for Us

    However why do we need to go to the maintenance plan's log? SQL Server includes the job history. It includes maintenance plans. Why doesn't the job understand there is a...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: No R2

    TravisDBA (6/12/2013)


    Clouds eventually move on, like a lot of fads tend to do.:-D

    Cloud services are to SQL Server what web services are (or were) to application development. It's an interesting...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 4,861 through 4,875 (of 6,041 total)