Browsing articles in "Blog"

What Your Database Security Design….

Jul 15, 2015   //   by Karen Lopez   //   Blog, Data Modeling, Database Design, DLBlog, Fun, Snark, WTF  //  1 Comment

…looks like to me.

Sure, you’ve got your own home-grown database security system all designed and working in development.  And then you ask me to confirm that it’s “safe”. I’ll tell ya “it’s safe as long as you don’t actually put any data in it”.

Hacking Database Design

Jul 14, 2015   //   by Karen Lopez   //   Blog, Data Modeling, Database, Database Design, DLBlog, Fun, Snark, WTF  //  3 Comments

DBDesignAdaptor

I get asked to help teams increase the performance of their database (hint: indexes, query tuning and correct datatypes, in that order)  or to help the scale it out for increasing workloads.  But when I open it up to take a look, I see something that looks more like this meme.

All those cheats, workarounds and tricks they’ve used are going to make the engine optimizers work harder, make the tuning of queries that much harder and in the end it’s going to cost so much more to make it “go faster” or “go web scale”.

Where are the nail clippers in your data models and databases?

The Discussion Groups are Closing

Frequent postersI’ve been posting about this for the last few years and I’ve finally carved out some time during my staycation to decommission our discussion group servers.  This is long overdue, I know.  But like any caring ListMistress, it’s been hard to say “it’s time”. It’s about 5 years past time, actually.

I know that some of you have expressed an interested in having me just continue to host these with no updates.  But the technology the WebBoard software runs on is too old and out of support to do so.  While there have been several physical servers over the years (starting with just mailing list software running on a PC in my basement), the vendor of the most recent software has been out of business for more than seven years.  The software was running last on Windows 2003 and SQL Server 2000.  And while I could likely install the software on an updated server, the installation process for this application requires a call home to a mothership that has long left the universe. So that’s not an option.  There are also other considerations in that the original vendor took no steps to make the software very security-mindful and that has always bothered me.

The server (and database) I’m decommissioning today was put into production in 1998.  Clinton was having a bad year, the International Space Station was just being built and InfoAdvisors had been incorporated for about a year.

Looking Back

I wish I had time to sort through some of our posts to see what the most fun, debatable or encouraging ones were.  But what I do remember is that we built a community of data professionals who worked to make sure that everyone else working in the data field had the right resources to be successful.  I will keep my database backup around and might spend some time rooting through it to find some gems.  If you have some memories you’d like to share, please do so in the comments below.

we built a community of data professionals who worked to make sure that everyone else working in the data field had the right resources to be successful.

Many of you were just lurkers, reading the content, occasionally asking for help (printing with ERwin, getting macros to work in ER/Studio, figuring out what the heck a conceptual model is, etc.)  But some of you did wonderful things by answering so many posts and providing user-to-user support to help others get stuff done (image shows some of our most frequent posters).  And some of you came for the debate. You know who you are.

Data

I thought I’d share some stats with you about our community. Not all of these were data boards, but since our non-data ones were trivial, I’m not going to bother filtering out. While we’ve archived a great deal of content over the decades. And, again, this is data active on the server right now, not over the entire life of our communities.

Registered Users:  10,175

Boards: 15

Forums: 126

Messages: 326,013

Attachments: 2,086

Boards

These also were adjusted over the years, but we hosted communities for:

Casewise Corporate Modeler

Data Modeling (various boards)

DBartisan

ER/Studio

ERwin

IT Methods

Other Data Modeling Tools (various boards)

Platinum Repository

PowerDesigner

Rational/InfoSphere Data Architect

Silverrun

Visible Analyst

Zachman Framework

Moderators

Unlike almost all other online communities, we actively moderated every post to our boards.  That means that a human being read every post to ensure it was on topic and not spam.  We could have not have done that without the help of our volunteer moderators:

Rick Davis

Rob Drysdale

Scot Fearnside

Garry Gramm

Jeremy Janzen

Carol Lehn

Ray McGlew

Fran Palmeri

Karel Vetrovsky

Many of us are still active on other boards and social media.  You should reach out to them and say thanks.  They made this all happen.

What’s Next?

I looked at web-based discussion software for my blog.  I may still install some, but they all miss the feature that I really want – Email and web-based discussions, all integrated.  The other issue is that there are now so many places on the web with data-focused discussions that I’m not sure standing up another one will add much value.

Here are some of the places you can go to get some data modeling community vibes:

http://community.embarcadero.com 

http://Erwin.com

http://scn.sap.com/community/powerdesigner

There are also the usual internet locations of LinkedIn, Facebook and Twitter.  But most of these are, let’s be candid, full of spam.  I can’t really recommend any single source there.

I’m also still the moderator of dm-discuss on Yahoo Groups.  I suggest you join that group if you are looking for vendor-independent discussions about data management and modeling.

Thank you!

I ran the infrastructure for these online communities, but you, readers and sometimes posters, delivered the content, which was the most important part. I’m hanging up my ListMistress tiara and using my Twitter to influence IT professionals to love their data now.   I encourage you to find some non-data oriented communities and start influencing them to think about data, too.  Then join some of the data ones and start helping each other, too. 

I’m still here, still loving data.  It’s just the server that is moving to a farm where it can play with other servers.  I hope to see you in one these other communities.

So Long, and Thanks for All the Data

Karen
ListMistress (ret.)

Karen’s Rules for Being Lazy

Jun 1, 2015   //   by Karen Lopez   //   Blog, Data Modeling, DLBlog, Project Management  //  No Comments

 

image

My Dataversity Heart of Data Modeling webinar this month was titled The Best Data Modeler is a Lazy Data Modeler.

In this presentation I discuss tips for automating more of the mindless tasks in data modeling (printing, publishing, complex by rote naming of objects and more).  My rules for when to automate a task:

  • Don’t spend time doing things that a computer is faster and better at
  • Automation is your friend
  • Don’t try to automate everything at once
  • Don’t try to rebuild an entire data modeling tool in a script
  • Focus modeling time on mindful things, not mindless ones
  • If you’ve automated it, you must ask vendors to make it a feature in their tool

Check out the recording when it goes live this week.  And if you have examples of automation that we didn’t cover, let me know.  I’d love to talk about them (and use them in my own data modeling activities).

Follow Live: Data Field Day 1

May 13, 2015   //   by Karen Lopez   //   Blog, Data, DLBlog, Events  //  1 Comment

Data Field Day One logo

 

This week I’m part of an exciting tour of northern California tech companies who focus on data technologies.  During these visits, you can watch via a live stream right here.  Watch for the stream to start later today at 1:30PM PDT.


For more information about the event, you can check out http://techfieldday.com/event/dfd1/

There will be 8 other delegates joining me in these meetings.  We’ll hear non-sales pitch presentations from the technical staff of these companies and get to ask questions.

Of course we have a hashtag #DFD1, so you can follow there.  Even ask some questions.

 

 

 

Canadian IT Pros: Win a 3D Movie Pack

Want to do some learning AND have a chance at winning one of 200 3D Cineplex Movie Prize Packs?

Just register and complete 2 Microsoft Virtual Academy courses about Windows 10, the cloud, and more.

image

image

So get registered, take two modules or more, and tell me what film you see with your winnings.

Lose Data Model Errors with This One Weird Trick

Apr 30, 2015   //   by Karen Lopez   //   Blog  //  No Comments

image

What could that datatype possible mean?

Read my blog post on an ER/Studio secret over on Embarcadero’s Community site and find out.

Pages:1234567...45»

Blog Categories

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


Categories

Archive

UA-52726617-1