Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

Data Management

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

    Search

    XML Feeds

    Google Ads

    « What’s the deal with Excel & SSIS?Hello World »
    comments

    I decided to do a SQL Advent series of posts this year as well, this year I will focus on best practices. In case you are interested in last year's posts, all of them are listed here: SQL Advent 2011 Recap

    Here is what the 25 posts will look like, the order that the posts are listed is not the same that they will be posted, I will randomly pick and choose

    1 Data types storage differences
    2 Sargable queries
    3 Recap
    4 Triggers, what to do, what not to do
    5 Sizing Files
    6 Benefits of Indexes
    7 Foreign Keys
    8 Standardized naming conventions
    9 Don’t trust the designers
    10 Lack of constraints
    11 When to say no
    12 Features enabled that are not used
    13 Maintenance
    14 Proactive notifications
    15 Reinventing the wheel
    16 Loops and cursors
    17 Lack of database design and normalization
    18 Use the new features
    19 Stay relevant and marketable
    20 Get the tools you need to be more productive
    21 How to get help
    22 Testing a backup strategy
    23 No matter how long you are on the wrong path, go back
    24 With VLDBs it matters what you do and how you do it
    25 How to improve your tech skills

    Let me know if that list seems fine or if you would like to see something else, also let me know in which topic you have absolutely no interest in

    About the Author

    User bio imageDenis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
    Social SitingsTwitterFacebookLinkedInHomePageFlickrLTD RSS Feed
    2990 views
    InstapaperVote on HN

    4 comments

    Comment from: David Forck (thirster42) [Member]
    looks like a pretty good list.
    11/26/12 @ 08:00
    Comment from: Jes Schultz Borland (grrlgeek) [Member]
    Jes Schultz Borland (grrlgeek) Looks like a good list! Excited to read your posts.
    11/26/12 @ 12:20
    Comment from: Naomi Nosonovsky [Member]
    Naomi Nosonovsky Number #14 sounds interesting. Looking forward to it.
    11/26/12 @ 13:14
    Comment from: Koen Verbeeck [Member] Email
    Seems like a great list. Can't wait to read all those blog posts :)
    11/26/12 @ 23:46

    Leave a comment


    Your email address will not be revealed on this site.

    To mislead the spambots.

    Your URL will be displayed.
    (Line breaks become <br />)
    (Name, email & website)
    (Allow users to contact you through a message form (your email will not be revealed.)