Forum Replies Created

Viewing 15 posts - 5,746 through 5,760 (of 6,022 total)

  • RE: The Importance of My Cloud Data

    Steve Jones - SSC Editor (1/17/2011)


    The pros are cracking our systems and selling information!

    We ought to have this discussion, and the best thing that can happen is better disclosure and...

  • RE: Restore point in time

    TravisDBA (1/17/2011)


    ... I actually interviewed at a position once where the manager stated right out front that ALL of his developer staff had sysadmin rights to ALL of the production...

  • RE: Restore point in time

    TravisDBA (1/15/2011)


    When restoring a database or doing any kind of structural maintenance for that matter, the only seesion that should have access to the database is the restore or...

  • RE: Restore point in time

    When performing emergency or long running maintenance operations on a database, one method to kick out all active user sessions (and insure they stay out until the database is ready...

  • RE: Scaling Up

    A decade ago, the first large SQL Server project that I had ownership of was 300 GB with SQL Server 7.0 running on a 2 CPU server with 4 GB...

  • RE: Help an Oracle newbie out

    PaulB-TheOneAndOnly (1/13/2011)


    ...

    Do not missunderstand me, I use some GUI tools like DBArtisan - which comes handy to have SQL Server, Sybase and Oracle on a fairly standard similar format -...

  • RE: The Importance of My Cloud Data

    GSquared (1/13/2011)


    Or, more likely, it's just a legend (as originally indicated), and has a similar facility to Aesop's Fables for illustrating a point about planning for the unplannable.

    If it's a...

  • RE: The Importance of My Cloud Data

    GSquared (1/13/2011)


    ...

    Legend has it (might be true) that there was a guy who, in the 1930s in the US, became certain that war was going to break out and that...

  • RE: The Importance of My Cloud Data

    I have a Hotmail account, but I also have a hosted MS Exchange account for professional purposes. The problem with Hotmail, GMail, and other similar services is that it's dominated...

  • RE: The Importance of My Cloud Data

    I think that the new database cloud services are useful in that they provide standardized and lower costs platforms for those corporations whose operations or business model already leverage it....

  • RE: In Case of Breach

    In case of a database breach, I'd say that the Default Trace would be my first place to look. It would be a goldmine of information, assuming the DBA left...

  • RE: Help an Oracle newbie out

    Lynn Pettis (1/8/2011)


    ...

    The last 5 months have been an interesting journey. I am enjoying the opportunity to learn Oracle, but the more I work with it the more I'd...

  • RE: Dynamic Column names based on value in other table.

    If the application developers want the data pivoted in some funky way, then grant them select permission on the tables, and tell them to create the SQL dynamically. There is...

  • RE: Comapre Oracle Schema with SQL Server 2008 Schema

    What's called a database in Oracle is an instance in SQL Server.

    What's called a schema in Oracle is a database in SQL Server, and SQL Server may contain multiple databases.

    SQL...

  • RE: User, Role and Schema H*ll – Is This Even Possible?

    jkelly (1/5/2011)


    Follow-up: per articles such as this ("SQL Server Best Practices – Implementation of Database Object Schemas" http://msdn.microsoft.com/en-us/library/dd283095%28v=sql.100%29.aspx ) it does indeed seem possible, per the documentation and example, but...

Viewing 15 posts - 5,746 through 5,760 (of 6,022 total)