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

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...

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

Gary Varga (12/8/2014)

---

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

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...

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...

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...

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...

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...

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...

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...

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,...

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...

Why is the article titled "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...