Browsing articles tagged with " Bacon"

Join us at #SQLBits: Designing for Performance Training, with Video and Snark

Jan 6, 2015   //   by Karen Lopez   //   Blog, Database, Database Design, DLBlog, SQL Server  //  No Comments
At SQLBits

I’m excited to announce that Thomas LaRock (@sqlrockstar | blog) and I will be presenting a full-day Training Day (PreCon) at SQLBIts XIV in London, UK.

Our session, Designing For Performance: Myths and Misunderstandings, is going to feature hands-on labs, exercises and lots of challenges to help you master your own SQL Server superpowers. It will be held on Thursday, 5 March 2015. Registration is open NOW.

 


 

image

 

Everyone agrees that great database performance starts with great database design. So why do so many poorly designed databases exist in the world? Attend this session to understand why bad designs will always exist, what you can do to avoid them, and how best to work with them when needed.
Discussion topics will include:

  • Server/Infrastructure design
    • VM/Server configuration
    • Physical file layouts
    • HA/DR options
    • Archiving
  • Database/Table design
    • Table design
    • PK/FK choices
    • Index strategies
  • Benchmarking
    • Monitoring for performance
    • Control reports

Attendees will leave this session with an understanding of the following:

  • Why common issues are so common
  • How to better anticipate issues before they happen 
  • How to deploy and implement design choices that benefit everyone
  • Proper performance benchmarking and control reports

 


SQLBits Superheroes

 

This will be my 3rd SQLBits conference,  They are a lot of fun and jam-packed full of learning and networking.  As you can see from the video above, Tom and I will also ensure that you aren’t just sitting through 8 hours of bullet points and sparse slides with funny pictures.  We’ll be talking about what design approaches work in what situations and all the myths and misunderstandings out there about database design and configurations.

Register now and engage your own superpowers. Or just stand there looking pretty.  It’s up to you.

7 Mistakes You *CAN* Afford to Make

Jan 2, 2012   //   by Karen Lopez   //   Blog, Data, Data Modeling, Fun, Snark  //  No Comments

I just saw that my article on Enterprise Data Modeling: 7 Mistakes You Can’t Afford to Make at Information Management magazine was on their list of the Top 10 Stories of 2011.    In fact, it made it to the top five stories. My friend Corey Smith ( blog | @heycorey ) then took it upon himself to ask

I’d like to know the 7 mistakes I *can* afford to make, so I can stop worrying about them?

Tweet by Corey

He wasn’t specific about whether he meant in enterprise data management or not, so I’m responding in general. These are all mistakes, but one can afford to make them, in moderation.

  1. Peanut butter: I’m not a fan of it, especially when it’s hidden in other stuff like pretzels and vodka
  2. Rounding Up:  Mathy people say that you should round up sometimes and round down other times.  And sometimes you don’t.  I say, make everyone happy and round up, right?
  3. Non-Alcoholic Beer:  I have to say that this stuff is usually quite bad, which is why it is a mistake.  But sometimes you need to have a beer and this is all they will let you drink. Like at lunch in the US or between real beers in the rest of the world.
  4. Twitter Grammar: 140 chars is some*s 2 short 2 say something 1derful.
  5. Running: What can I say?  I do it, and I want to do it more. It always feels like a mistake when I start doing it.  But I can afford to do more.
  6. Bacon: I prefer the veggie kind.  Others don’t.  We both feel as if the other is making a mistake.  That’s okay.
  7. February: It’s post holiday season, it’s not really spring and hardly anyone can pronounce it correctly.  But everyone has to do it.

So there you go, Corey,  your list.

Everyone else, go check out my article as well as all the other Top Stories in from Information Management.

Subscribe via E-mail

Use the link below to receive posts via e-mail. Unsubscribe at any time. Subscribe to www.datamodel.com by Email


Recent Comments

Categories

Archive

UA-52726617-1