Forum Replies Created

Viewing 15 posts - 2,506 through 2,520 (of 6,041 total)

  • RE: Email or Username

    Using a 3rd party to manage user identities make sense for many reasons, and the most compelling reason is that you own your identity and it can be reused...

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

  • RE: What is this WHERE clause

    As a side note, in Oracle a NULL and an empty string '' are equal, which means that:

    '' IS NULL, the expression '' = '' would always evaluate False,...

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

  • RE: Democratic Data Science

    Rod at work (6/29/2016)


    Eric M Russell (6/28/2016)


    While we're on the topic of organizations who leverage technology to automate "grunt work", this is a funny read.

    How to Snare Millions of...

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

  • RE: SSIS packages dont work all of a sudden through SQL agent Jobs

    Phil Parkin (6/28/2016)


    Eric M Russell (6/28/2016)


    Based on the error messages provided above, it doesn't appear to be related authentication or permissions. It sounds related to the status of the source...

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

  • RE: SQL Agent Job History Retention

    Check your maintenance plan. Often times it will contain truncate job and backup history.

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

  • RE: Data populating with Audit table

    There is a function called object_definition() that accepts object_id and then returns the T-SQL of object like stored procedures, UDF, or views. When combined with sp_msforeachdb, you can leverage it...

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

  • RE: Democratic Data Science

    While we're on the topic of organizations who leverage technology to automate "grunt work", this is a funny read.

    How to Snare Millions of Men with Web Bots

    http://gizmodo.com/ashley-madison-code-shows-more-women-and-more-bots-1727613924

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

  • RE: SSIS packages dont work all of a sudden through SQL agent Jobs

    Based on the error messages provided above, it doesn't appear to be related authentication or permissions. It sounds related to the status of the source database server.

    - First confirm...

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

  • RE: Have You Designed a Database from Scratch?

    Many IT organizations (OK, probably more like most), even some of the largest organizations, just don't "get" database design. Oh, they know all about networking, SAN storage, hardware, and virtualization......

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

  • RE: Have You Designed a Database from Scratch?

    roger.plowman (6/24/2016)


    Eric M Russell (6/24/2016)


    roger.plowman (6/24/2016)


    The ERD is supposed to create the DDL for you. That's what it's *for*... 😀

    Umm... no. :unsure:

    Ah, clearly you are unfamiliar with the miracle...

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

  • RE: Have You Designed a Database from Scratch?

    roger.plowman (6/24/2016)


    The ERD is supposed to create the DDL for you. That's what it's *for*... 😀

    Umm... no. :unsure:

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

  • RE: Have You Designed a Database from Scratch?

    Rod at work (6/24/2016)


    Wait, what's this about a Guidebook app?

    Maybe we can startup a SCRUM team using folks from here at SQLServerCentral.

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

  • RE: What's the reason?

    If the interviewer knows what he's talking about, and the whole point is to spark a conversation about how the candidate approaches DDL deployment, then it's a good question. If...

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

  • RE: Have You Designed a Database from Scratch?

    In many organizations (OK probably most) the application developers create the database; both the logical and physical model. The DBA discovers that this new database will soon exist in production...

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

  • RE: What's the reason?

    Charmer (6/23/2016)


    Hi Friends,

    I had a question during my interview, as saying that What could be the reason when I am trying to drop all these tables , views, functions, SP's...

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

Viewing 15 posts - 2,506 through 2,520 (of 6,041 total)