THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » bad habits   (RSS)
Showing page 2 of 2 (20 total posts)
  • T-SQL Tuesday #20 : T-SQL Best Practices

    T-SQL Tuesday, the invention of Adam Machanic (@AdamMachanic), is what he calls a recurring, revolving blog party. Each month, a new host picks a topic, invites bloggers of all levels to join in, and then after all the submissions are in, writes a summary of all of the entries. This encourages people to participate in the community more ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 12, 2011
  • SQL Saturday #71, Boston: "T-SQL : Bad Habits to Kick"

    In Boston today I presented my ''Bad Habits to Kick'' deck to 66 people. You can download the deck and samples from the SQL Saturday web site or directly from http://bit.ly/AB-71-Slides. Like the Chicago event, folks were encouraged to submit feedback immediately after the session, by picking a random eval and giving the winner a token (in this ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 2, 2011
  • The old "do as I say, not as I do" problem

    Microsoft is often considered a leader, an innovator, a trend-setter.  The same could be said for Apple, Google, and a host of other tech companies.  And each of those has its set of critics as well, who think that the company is the opposite - or worse.  Some people think it is a good idea to model their own code, architecture or ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 14, 2010
  • Bad habits to kick : ignoring I/O

    In my last post in this series, I talked about problems associated with creating (and using) what I call the ''uber-view.''  This time, in line with tomorrow's T-SQL Tuesday hosted by Mike Walsh, I wanted to talk about some I/O issues that tend to get ignored in a lot of environments. Introduction In my experience, today's SQL Server ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 8, 2010
  • Bad habits to kick : creating the uber-view

    In my last post in this series, I talked about using ancient copies of Books Online, and why it can be important to keep your local documentation current.  This time I wanted to touch on massive and wasteful views that are re-used a little too much. The one-size-fits-all view: you've seen them, you've had to use them, you may have even ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 7, 2010
  • Bad habits to kick : inconsistent table aliasing

    In my last post in this series, I wrote about ignoring the principle of least privilege, since a lot of people fall into the trap of following the path of least resistance.  This time I wanted to touch on a topic I've touched on before: aliasing. Over the weekend, there was a twitter conversation between @unclebiguns and @jaybonk (it ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 15, 2010
  • Bad habits to kick : blind SQL Server installs

    In my last post in this series, I talked about some problems associated with relying on undocumented behaviors and commands.  This time I wanted to touch on SQL Server configuration, and some of the items I see where more thought should have been put into the process when SQL Server was initially installed, rather than just accepting the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 10, 2010
  • Bad habits to kick : relying on undocumented behavior

    In my last post in this series, I talked about the common habit of creating an IDENTITY column on every single table.  Today I want to talk about a more broad concept: relying on undocumented (and therefore probably undefined, and certainly far from guaranteed) behavior and objects.   ORDER BY in a view This is probably the most ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 8, 2010
  • Bad habits to kick : putting an IDENTITY column on every table

    Back in October, I started a series of blog posts called ''Bad Habits to Kick,'' and thought I would revive the theme. I've worked with developers that dabble in SQL, and they tend to have a few common traits.  I'm not sure where they come from, but one that I find rather distracting is the tendency to place an IDENTITY column on every ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 8, 2010
  • When you don't follow your own "bad habits" advice...

    Today I came across a self-created problem that could have been avoided if I had only followed my own advice.  It wasn't directly and explicitly mentioned in this context, but the concept is the same.  Let's start with the source of the problem: one stored procedure that called another.  The first (''inner'') procedure was ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 14, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement