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

---

Eric M Russell (12/15/2014)

---

Most backup utilities are database centric. If the server must be restored, or one wants to spin up a UAT envrironment that...

Most backup utilities are database centric. If the server must be restored, or one wants to spin up a UAT envrironment that closely mimics production, then restoring the databases is...

In the past 246 days, students have made 2,261,601 apps and pictures by writing their own computer programs. Click on the pictures and screenshots to see each program in action....

gregg_dn (12/11/2014)

---

If developers gave users what they needed, most people would never attempt to write code. I've used many different RDBMS over the years and can tell you that...

I'm not sure that a general purpose programing tool geared toward the general public would be useful. However, the general public can extend the functionality of common applications using things...

Yeah, it's kind of...

lshanahan (11/26/2014)

---

Markus (11/25/2014)

---

You guys must live in a perfect world of applications... However, the bulk of the SQL Server based apps are small companies and don't have the resources or...

However, one limitation of most commercially and publicly available address databases is that they don't include exact house number, but instead a range of valid numbers, so would have to...

ZZartin (12/9/2014)

---

Eric M Russell (12/9/2014)

---

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

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