30th September - 2nd October 2010

University of York

Gold sponsors
Silver sponsors
Bronze sponsors

Small Problem - Simple Solution: Lookup Tables

Statistics say “25 – 30 % of all tables for an application are lookup tables”. Whether you are working on a “small” or “big” application it is worth analysing this problem and try to generalise the solution. Saving developer’s time is saving money, less code means less bugs, code once and reuse the code through the application(s). I’ll show you my thinking about this problem and give you some examples you can use in your applications. You can, of course change the code, improve it and modify the solution in any way.

Speaker focus

Predrag Bosnic and Marko Markovic

Predrag Bosnic started his IT journey in 1979 using UNIVAC 1100, Fortran and Mapper. For the next 20 years he visited the world of PC, dBase, Clipper and Fox. During the last 10 years he has been working with SQL Server, BI and .Net maintaining his passion for databases and software development. He is a Software Development Manager, Developer, conference speaker and author of a dozen technical articles.



Downloads

File Type Ext ContentName
Zip File .zip Lookup Tables Explorer Source Code
<< 1 >> 

Other sessions from this conference

A Testing Time...
A walk down memory lane
Advanced T-SQL (2005 and 2008)
Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite
Data Vizualisation - Make your reports useful to business - No more "Speed Dials"
Does your cube support your users reporting needs?
Don't try this at work !
End to End Report Creation and Management using Microsoft SQL Server 2008
Getting more value from your data through data mining.
Head in the Cloud...
How to approach zero downtime database upgrades
Indexes Basically
Microsoft's integrated end-to-end BI offering.
Performance Monitoring Using SQL Server Management Studio - power of Management Data Warehouse
SQL Server – Under New Management
SQL Server 2008 for Developers
Understanding Query Cache and Query Plans
Useful Sql'y stuff that I've picked up over the years
Where’s my data? An introduction to Spatial Queries in SQL Server 2008