My client wanted a list of all of the tables and their respective columns in a given SQL server database. My first instinct was to get Visio to create an ER diagram by reverse engineering the database. However, with dozens of tables in this database, the diagram that Visio spit out looked like spaghetti and [...]
I can’t believe this blog has been up for 5 months, and I haven’t posted anything about GIS – since I come from a GIS programming background. It is even more telling that this post is about how to get around using GIS software by using ASP.Net, SQL Server, and the Google API to geocode [...]
This artcile is a comprehensive resource covering exception handling in SQL Server stored procedures.