About Us–Audrey Hammonds and Julie Smith

Audrey Hammonds

Audrey Hammonds is working as a consultant for Innovative Architects in Atlanta. (With my fellow Datachix!) Fourteen years ago, she volunteered for DBA training to escape COBOL, and never looked back. A firm believer that good fundamentals and solid design can save a database professional’s sanity, she has devoted much of her career to designing (hopefully) elegant databases and straightening up others’ not-so-elegant databases. Audrey has run the gamut from Database Developer to Production DBA to Architect.

Contact URL: http://www.linkedin.com/in/audreyhammonds

Twitter:  @DataAudrey

Julie Smith

Julie Smith has spent the last 12 years moving data using varied tools such as MS Access, MySQL, and SQL Server 2000-2012. She is an MCTS in SQL Server 2008 BI.   She is a Business Intelligence Consultant at Innovative Architects.  Prior to Innovative Architects,  she worked as a database developer at Key2 Consulting and  the Network Inc.     She remains “very simple woman with warm fuzzy secret heart.”

Contact URLhttp://www.linkedin.com/in/juliesmith0503

Twitter:  @JulieChix

Both Audrey and Julie are Microsoft MVPs


13 thoughts on “About Us–Audrey Hammonds and Julie Smith

  1. I really enjoyed your presentation, which I didn’t think was “frantic” at all.

    Back when I did data modeling instead of database administration, I always felt that a well-designed database was a thing of beauty. And I also spent time staring at my ER diagrams on my wall, which people sometimes thought was a bit odd. So, it was nice to see that someone else feels the same way and has the same habit. (Part of what makes an ER diagram elegant is not only the design but also the layout. I think that a good modeler should be a bit obsessive about aranging the entities so that the lines aren’t a jumbled mess.)

    “You get even with Kent. It’s a moral imperative.” -Chris Knight in Real Genius

    • Eh, so maybe I just felt frantic. I’m so glad you enjoyed the presentation! And I was THIS close to including that Real Genius quote on a slide. 🙂 Finding non-offensive 80’s movie quotes was no easy task.

      I’m with you on the “picture” of an E-R Diagram. “Don’t Cross the Lines!” I can’t even tell you how many hours I’ve spent over the years arranging and rearranging a diagram so that no lines crossed. I’ll reluctantly admit that maybe, just maybe, I’ve reworked a data model so that the layout would look better. But. I’ll argue that if a data model is so complicated that you can’t make it look pretty, then maybe there’s something wrong with it to begin with.

  2. I attended your session on Saturday. I thought I knew the topic well and wasn’t my first choice but glad I did it.
    You presented it in such a beautiful way that I can only imagine how amazingly you design your databases. Does it come naturally as to be a datachix? 
    Looking forward to get your presentation here. Meanwhile, I enjoyed reading your blog, especially lessons learned which I can relate.

  3. Can you post an example of putting data from multiple rows into a single column?

    For example you have this:
    Cat | meow
    Cat | eat
    Dog | bark
    Dog | fetch

    And you want to display it as this:
    Cat | meow, eat
    Dog | bark, fetch

    It’s hard to find a good example of this online.

    Thanks, Ben

  4. Hi

    I have a little problem, I want to encrypt a SSIS variable that I created within a Package
    I want that it will be encrypted.I’m using EncryptSensitiveWithPassword as ProtectionLevel

    Thank you

  5. great talk last night and the SQL user group meeting in Atlanta … I came in late and was hoping to find an answer to only one question … how can I pass a column from a table into a table variable function … and you answered it immediately with the CROSS APPLY … great timing! Thanks.

  6. Audrey
    This is Alfred McDonald – the guy you meet from Gwinnett Tech @ SQLSaturday (GSU campus) smoking! lol – Hey just wanted to say thank you so very much for informing me about the great things SQLSaturday and PASS has to offer – please tell me more about the meetings (Perimeter area), free resources, and other meetings I should be involved in. Again Thank you and I look forward in you teaching me the SQL life! (LOL) – and tell Julie I need her help as well! lol

Leave a Reply