The Datachix Blog











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

mvp



Chris Lanzi says:

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.



Yulia Shteyman says:

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.



Yulia,

You’ve made my day. Thank you for the comment. As for being a datachix… It’s all a state of mind, sweetie. We’re all datachix as far as I’m concerned. ;)



Ben says:

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



datachix says:

Hey Ben,

I would suggest using Audrey’s example from Itzek http://datachix.com/2010/10/28/getting-schooled-on-dynamic-pivot-or-pivot-part-2/ The only change you would need to do would be to concatenate the second and third columns. Meaning, in your temp table, you would wind up with cat | Meow | eat on one row and to get the data the way you want it you’d have to use select column1, column2 + column3 in your sql instead of select *. Hope that helps!

Julie @datachix1



moss says:

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



Hi,
Could you email me with more details? I don’t have enough to go on to help. bumpagab@gmail.com

Thanks for reading,
Julie



Tom Stone says:

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.



Alfred McDonald says:

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



[…] to Bob Duffy (Blog), Davide Mauri (Blog), Robert Pearl (Twitter | Blog), Audrey Hammonds (Twitter | Blog), Karen Lopez (Twitter | Blog), Thomas Ivarsson (Twitter | Blog), Chistian Cote (Twitter | Blog), […]



[…] Davide Mauri (Blog), Robert Pearl (Twitter | Blog), Audrey Hammonds (Twitter | Blog), Karen Lopez (Twitter | Blog), Thomas Ivarsson (Twitter | Blog), Chistian Cote […]



[…] to Bob Duffy (Blog), Davide Mauri (Blog), Robert Pearl (Twitter | Blog), Audrey Hammonds (Twitter | Blog), Karen Lopez (Twitter | Blog), Thomas Ivarsson (Twitter | Blog), Chistian Cote (Twitter | Blog), […]



Leave a Reply

et cetera
%d bloggers like this: