http://www.sqlservercentral.com/Content tagged Database Design, Programming posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Should you store dynamically generated web-site graphics in a database or is the file system the better option? Dino illustrates how to make this decision in ASP.NEThttp://www.sqlservercentral.com/redirect/articles/2961/2007/04/17http://www.sqlservercentral.com/redirect/articles/2961/Most SQL Server developers and DBAs are familiar with the concept of using a database as a back end to a web site or other application. However the database can be used to store more than just the data that users will edit. An interesting approach to application design begins with some knowledge of the metadata about the underlying data structures and using this to drive the application's behavior. New author Jim Craddock has utilized just such a concept in one if his applications and he brings us a look at how this works. http://www.sqlservercentral.com/articles/Miscellaneous/datadrivenarchitecture/1733/2005/02/17http://www.sqlservercentral.com/articles/Miscellaneous/datadrivenarchitecture/1733/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/David recently worked on a project where it turned out storing the answers to a survey using bitmapping was a good approach. He was good enough to write some of it down and share. As he notes bitmapping isn't used as often as it used to be, but it can still be a useful technique to have around. http://www.sqlservercentral.com/articles/Miscellaneous/usingbitstostoredata/1251/2004/01/06http://www.sqlservercentral.com/articles/Miscellaneous/usingbitstostoredata/1251/Chris discusses some issues he had trying to use SQL dates from within Java. Interesting stuff and brings up the point that if you have dates stored in local time, having users in multiple time zones can be a large headache. http://www.sqlservercentral.com/articles/Miscellaneous/sqlandjavagoonadate/1130/2003/09/17http://www.sqlservercentral.com/articles/Miscellaneous/sqlandjavagoonadate/1130/Jon has been off in the land of C# and web apps for a while, but a recent project has him investigating OLAP and then coming up with a custom solution that met his needs. Jon helped us get this site off the ground, good to have him back for a guest appearance! http://www.sqlservercentral.com/articles/Miscellaneous/normalizingdates/1122/2003/09/05http://www.sqlservercentral.com/articles/Miscellaneous/normalizingdates/1122/David writes about the system he put together to handle addresses and the pros and cons of various techiques. Familiar with Soundex? He uses that too! Even though some of the info is specific to Great Britain, it's good reading. Addresses are one of the hardest pieces of information to handle! http://www.sqlservercentral.com/articles/Miscellaneous/dealingwithaddresses/1028/2003/07/01http://www.sqlservercentral.com/articles/Miscellaneous/dealingwithaddresses/1028/This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.http://www.sqlservercentral.com/redirect/articles/982/2003/05/06http://www.sqlservercentral.com/redirect/articles/982/Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading! http://www.sqlservercentral.com/articles/Administering/managingjobspart2/919/2003/02/14http://www.sqlservercentral.com/articles/Administering/managingjobspart2/919/How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control. http://www.sqlservercentral.com/articles/Administering/managingjobspart1/906/2003/01/31http://www.sqlservercentral.com/articles/Administering/managingjobspart1/906/Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting. http://www.sqlservercentral.com/articles/Administering/versioncontrolforstoredprocedures/681/2002/05/10http://www.sqlservercentral.com/articles/Administering/versioncontrolforstoredprocedures/681/Andy read this book recently and gave it a great review. Even though it's not a SQL book! Seriously, take a look at the review. It's a good book that is fun to read. http://www.sqlservercentral.com/articles/Miscellaneous/reviewofdebuggingthedevelopmentprocess/612/2002/02/26http://www.sqlservercentral.com/articles/Miscellaneous/reviewofdebuggingthedevelopmentprocess/612/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it! http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/2002/02/06http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/Andy says it's not the greatest book for preparing for the 70-100 exam, but the case study is worth reading for it's explanation of the Microsoft Solution Framework. Read the full review! http://www.sqlservercentral.com/articles/Miscellaneous/analyzingrequirementsanddefiningsolutionarchitectu/561/2002/01/02http://www.sqlservercentral.com/articles/Miscellaneous/analyzingrequirementsanddefiningsolutionarchitectu/561/Should you use this book to prepare for the 70-100 exam? Read the review and find out! http://www.sqlservercentral.com/articles/Miscellaneous/70100mcsdarchitecturesexamcram/562/2001/12/26http://www.sqlservercentral.com/articles/Miscellaneous/70100mcsdarchitecturesexamcram/562/Your database design should be impervious to this documented behavior of the ADO delete method. Be one of the first five members to give a compelling reason why not, and take a dollar from starving columnist Sean Burke. http://www.sqlservercentral.com/articles/Basics/noprimarykey/224/2001/05/21http://www.sqlservercentral.com/articles/Basics/noprimarykey/224/