;) |
| In this Issue | |
| >> |
From the editor:
Fabian Pascal live! |
| >> |
Featured Topic:
The dangerous illusion |
| >> |
Expert Technical Advice:
* Expert Advice on Database Design
* Who's the memory hog: Oracle or SQL Server?
* Tip of the Week: Delete duplicate records |
| >> |
Site Highlights:
* Fabian Pascal: Live Expert Q&A
* Win an Xbox TODAY
* Optimal Storage Infrastructure for DB2 UDB Databases |
| From the Editor: | |
by Tim DiChiara, Site Editor
Our focus on database fundamentals and the relational model a few weeks ago struck a chord with a lot of you. Now here's your chance to interact with one of the most knowledgeable and opinionated relational model evangelists: Fabian Pascal. He's been a searchDatabase.com columnist for a year now, and he never fails to educate, entertain, and annoy. (Those of you who have dared disagree with him know the pain of his cutting ripostes!) Fabian will be focusing on normalization this time and will dissect the common practice of denormalizing to increase database performance. He maintains that normalization is a logical concept and performance is a physical one -- and never the twain shall meet! Denormalization also imposes an often ignored, but very serious, integrity control burden. This should be a lively and thought-provoking presentation, so be sure to pre-register for the event, which will be held on Tuesday, December 11 at 1 pm EST (18:00 GMT). I'll be moderating, so I hope to "see" you there! Thanks for your time, Tim |
| Featured Topic: | |
The dangerous illusion
by Tim DiChiara, Site Editor
Relational model evangelist Fabian Pascal dissects the "dangerous illusion" -- denormalize for performance -- in a live appearance Dec. 11 on searchDatabase. Don't miss this lively introduction to normalization as a logical concept and how it relates to database performance at the physical level. Click on "Read more about this topic" for more database design resources.
Read more about this topic
|
| Expert Technical Advice: | |
Featured Expert: Pat Phelan, Data modeler
Category: Database Design
Pat has an eclectic background that dates back to when the field was still called Data Processing and used punched cards. He has worked on systems ranging from IBM mainframes, through mini-computers (DEC, HP, PR1ME, etc), to microcomputers, to process control machines. He currently works as a data modeler for a large US business services company that focuses on entrepreneur-run businesses.
Post your question TODAY for Pat's expert advice |
| This Week: In the forums |
| >> |
Who's the memory hog: Oracle or SQL Server?
There's been a lively debate going on in our "DBA Water Cooler" forum: Member "HSM" found that his SQL Server was taking 10 times the memory that Oracle used! What do you think? Is SQL Server really at fault, or does it depend on the application design? |
| >> |
ColdFusion and MVC
Member "jayanthis" asks: "How do I implement a project in ColdFusion based on MVC architecture?" Can anybody offer any advice in our "Database-Web Connectivity" forum? |
| Tip of the Week: |
| Here is a short but sweet Oracle script that deletes duplicate records from a table based on the unique columns selected. |
| >> |
Delete duplicate records |
| Site Highlights | |
|
|
| Get a Free Xbox |
| Tell your peers about searchDatabase and you can win the hottest video game system of this holiday season. |
| Game on |
|
| FREE Storage Report |
| Update your member profile to get the Storage Innovators weekly report for insight into the latest storage innovations including SAN deployment, ROI leadership and more. |
| Innovate |
|
| Win a BlackBerry! |
| Qualify to attend our Storage Management conference and win a free BlackBerry! We'll select a lucky winner in the next 5 days from accepted applicants. |
| Apply now! |
|
|
|
