Tuesday, August 30, 2005

SQL Server Adviser: Normalization rules to live by

SearchSQLServer.com: SQL Server Adviser
August 30, 2005
___________________________________

ISSUE SPONSORED BY: SearchSQLServer.com White Paper Library

.....................................................................
IN THIS ISSUE

-- SQL Server normalization rules you must follow
-- Ten merge replication tips and tricks
-- Automatic data type conversion in SQL Server 7 vs. 2000
-- Book Excerpts: Optional features turned off in SQL Server 2005
-- Database design fundamentals

HEADLINES
---------------------------------------------------------------------
SQL SERVER NORMALIZATION RULES YOU MUST FOLLOW | SearchSQLServer.com

What does normalization have to do with SQL Server? Edgewood
Solutions' Greg Robidoux says it has nothing to do with it -- your
RDBMS couldn't care less what normal forms you use for your data
model. However, using normalization to establish a clean data model
has its benefits.
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1120129,00.html?track=NL-464&ad=524318HOUSE

MORE INFO:
Learn how to design effective database systems
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1083254,00.html?track=NL-464&ad=524318HOUSE&ad=524317

Research database modeling and design topics
http://searchsqlserver.techtarget.com/topics/0,295493,sid87_tax301329,00.html?track=NL-464&ad=524318HOUSE

::::::::::::::::::::::::::::: SPONSOR :::::::::::::::::::::::::::::::

SearchSQLServer.com White Paper Library

Visit the SearchSQLServer.com White Paper Library and access a
powerful resource for IT professionals looking for the latest in
enterprise SQL Server technologies. Search and browse through a vast
database of white papers, webcasts, analyst reports, case studies,
and more to help you expand your knowledge on SQL Server in the
enterprise.
Take advantage of all the white paper library has to offer today!
http://searchSQLServer.com/r/0,,40220,00.htm?track=NL-464&ad=524318HOUSE

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

TEN MERGE REPLICATION TIPS AND TRICKS | SearchSQLServer.com

From schema and parameter changes to wrapping and limiting merge
agents, SQL Server MVP Hilary Cotter offers various tricks to help
you get the best performance from your merge replication efforts.
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1119737,00.html?track=NL-464&ad=524318HOUSE

ALSO ON SEARCHSQLSERVER.COM
---------------------------------------------------------------------
AUTOMATIC DATA TYPE CONVERSION IN SQL SERVER 7 VS. 2000
SQL Server 7 and SQL Server 2000 evaluate expressions in entirely
different ways, making it difficult to construct SQL statements on
the fly. Find out how to automatically convert data types in each
version.
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1108687,00.html?track=NL-464&ad=524318HOUSE&ad=522785HOUSE

BOOK EXCERPTS: OPTIONAL FEATURES TURNED OFF IN SQL SERVER 2005
In SQL Server 2005, Microsoft has taken care to reduce the attack
surface area by turning off optional features by default. Find out
which features are off in this excerpt from Chapter 6, 'Security,' of
Bob Beauchemin, Niels Berglund and Dan Sullivan's book "A First Look
at Microsoft SQL Server 2005 for Developers."
http://searchsqlserver.techtarget.com/originalContent/0,289142,sid87_gci1102097,00.html?track=NL-464&ad=524318HOUSE

DATABASE DESIGN FUNDAMENTALS
If you haven't been schooled in the principles of database design,
Monitoring and Administration expert Kevin Kline gives you resources
you need in this expert response.
http://searchsqlserver.techtarget.com/ateQuestionNResponse/0,289625,sid87_cid960248_tax301621,00.html?track=NL-464&ad=524318HOUSE

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
CONTACT US:

Sales
For sales inquiries, please contact us at:
mailto:mkelly@techtarget.com

Editorial
For feedback about any of our articles or to send us your article
ideas, please contact us at:
mailto:rlorusso@techtarget.com

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
ABOUT THIS E-NEWSLETTER

This e-newsletter is published by SearchSQLServer.com, a targeted Web
site from TechTarget, the most targeted IT media and events company.
TechTarget offers magazines, Web sites, e-newsletters, Webcasts and
conferences for enterprise IT professionals.
Copyright 2005 TechTarget. All rights reserved.

____________________________________________________________________

To unsubscribe from "SQL Server Adviser":

Go to unsubscribe: http://SearchSQLServer.techtarget.com/u?em=pet.computter%40gmail.com&uid=3058509&cid=526975&track=NL-464

Please note, unsubscribe requests may take up to 24 hours to process;
you may receive additional mailings during that time. A confirmation
e-mail will be sent when your request has been successfully
processed.

Contact us:
SearchSQLServer
Member Services
117 Kendrick Street, Suite 800
Needham, MA 02494