Forum Replies Created

Viewing 15 posts - 4,291 through 4,305 (of 6,041 total)

  • RE: Address Validation

    There are many commercial providers of address data. This would be better than attempting to make a web service call for each record in an ETL process.

    http://zipinfo.com/products/natzip4/natzip4.htm

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

  • RE: Address Validation

    Emil Bialobrzeski (12/9/2014)


    cbrammer1219 (12/9/2014)


    Ok I have a fairly straight forward question, wondering if anyone knows the answer. I have been tasked to use USPS Address tools to validate our clients...

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

  • RE: Address Validation

    I am wanting to know if this would violate the terms of use policy, ...

    Please provide some more context. You're concerned about violating the terms of use policy for what...

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

  • RE: Overcoming Proposal Objections

    Gary Varga (12/8/2014)


    eric.notheisen (12/8/2014)


    I went back into programming in 1995 to avoid office politics.

    Good luck with that...difficult to find positions that have near zero office politics but they do exist....

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

  • RE: How to restrict User to enter Phone number in words ???

    As the DBA, if you don't trust your users or your application devleopers to do the right thing, then as last line of defense you can check the data on...

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

  • RE: How to restrict User to enter Phone number in words ???

    Jeff Moden (12/5/2014)


    Ed Wagner (12/5/2014)


    Eric M Russell (12/5/2014)


    The input should be properly parsed and formatted prior to inserting the database table. Really, allowing users to enter all contact information into...

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

  • RE: Linked Server Query Logic

    You are correct that remotely joined tables are very inefficient and the source for many types of problems. If you have a SQL query that joins local tables with remote...

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

  • RE: Can I safely delete a log file?

    Just to be safe, you may want to use a file search tool to locate the database file (assuming it may still exist) related to that log file, even if...

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

  • RE: How to restrict User to enter Phone number in words ???

    gouri92 (12/5/2014)


    Hi I am designing wepage using Asp.net with Sql server as database

    I have used Multiline textbox in which user has to enter their family detail.

    Like number of brother...

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

  • RE: Overcoming Proposal Objections

    During a round table discussion a senior developer working in a small company posed the question, “How do I get my Finance manager to release funds for me to do...

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

  • RE: SQL DBA knowing user passwords

    Brandie Tarvin (12/4/2014)


    Eric M Russell (12/4/2014)


    I get the impression this is not commonly known, but a SQL Server authenticated user account, even a minimal user with nothing but default public...

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

  • RE: SQL DBA knowing user passwords

    Ideally you will be using Windows authentication across the organization and the network domain admin is a different person than the DBA. However, there are scenarios, like 3rd party applications,...

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

  • RE: Always Canary

    Steve Jones - SSC Editor (12/3/2014)


    John Hanrahan (12/3/2014)


    I believe Steve is referencing the old 'Canary in a Coal Mine'. Miners would test air quality using a bird. If...

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

  • RE: Always Canary

    Why is the article titled "Always Canary" ?

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

  • RE: Always Canary

    SQL Server will typically require a schema lock when altering tables, which can be problematic if the deployment involves altering muliple tables and the changes need to be applied in...

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

Viewing 15 posts - 4,291 through 4,305 (of 6,041 total)