Forum Replies Created

Viewing 15 posts - 3,511 through 3,525 (of 6,041 total)

  • RE: The Road to Success

    Matt Miller (#4) (8/24/2015)


    Eric M Russell (8/24/2015)


    When I write unit tests, it gets run in both development and QA. Each unit test is a script that maps to a specific...

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

  • RE: The Road to Success

    When I write unit tests, it gets run in both development and QA. Each unit test is a script that maps to a specific functional requirement. A test plan lists...

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

  • RE: Require Suggestion on third party tools both PAID & FREE

    All of the functionality you just mentioned (logging record counts, event handling, scheduling, email alerts, etc.) are basic functionality of SSIS and SQL Server Agent.

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

  • RE: Mission Critical Deployments

    Jeff Moden (8/24/2015)


    Eric M Russell (8/24/2015)


    It seems to me that, even in the event of a catastrophic computer system failure, an airplane should still be functional enough to make an...

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

  • RE: Mission Critical Deployments

    It seems to me that, even in the event of a catastrophic computer system failure, an airplane should still be functional enough to make an emergency landing under manual control.

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

  • RE: Usage Query

    maxlezious (8/24/2015)


    Eric M Russell (8/24/2015)


    maxlezious (8/24/2015)


    Thanks for your reply!

    I currently have a job setup which runs the stored procedure every week and inserts the usage figures in a table. All...

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

  • RE: Usage Query

    maxlezious (8/24/2015)


    Thanks for your reply!

    I currently have a job setup which runs the stored procedure every week and inserts the usage figures in a table. All i am looking for...

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

  • RE: Converting a column of type nvarchar to datetime

    Hopefully you are converting all your "CharDate" columns to Date and never looking back. However, if there will still be some tables or databases containing formatted date values in Char...

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

  • RE: Transition from SQL server 2000 to SQL server 2014

    Grant Fritchey (7/30/2015)


    You might be facing a bit of an issue here. I'm assuming you're planning to do log shipping after a restore to get the 2000 database to 2014?...

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

  • RE: Annual Security Compliance Training

    You can find plenty of articles on SQLServerCentral or YouTube videos explaining how to write secure code. It would be easy for an organization to provide their developers with relevent...

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

  • RE: Annual Security Compliance Training

    The training is probably more about legal procedure, having each employee acknowledge that they've been informed of specific security policies. For example, there is no reason for someone to plead...

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

  • RE: Nope to NoOps, No way to NoDBA

    I can understand GenY application developers right out of university wanting to bypass the grumpy DBA middleman and code directly against an object database that they control themselves. The presenters...

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

  • RE: What are your five most common T-SQL commands

    You'd think that folks would know better, but having dealt with a large number of development, UAT, and production servers; this script actually returns some surprises on occasion. It may...

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

  • RE: What are your five most common T-SQL commands

    Here is a script I use to grant (or request for myself) "power user" permissions without the need for full sysadmin membership.

    -- server level permissions:

    use master

    -- grant user permission to...

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

  • RE: Annual Security Compliance Training

    djackson 22568 (8/21/2015)


    ZZartin (8/21/2015)


    /shrug it's a compliance issues, it's not supposed to be useful and the vast majority of it can be summarized as use common sense.

    We have to go...

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

Viewing 15 posts - 3,511 through 3,525 (of 6,041 total)