Audrey Hammonds
Audrey Hammonds is working as a Database Developer for ista North America 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 is one of the co-founders of the The Cloverleaf School of Atlanta, which educates elementary aged children with ADHD, High Functioning Autism and other learning differences. She remains “very simple woman with warm fuzzy secret heart.”
Contact URL: http://www.linkedin.com/in/juliesmith0503
Twitter: @JulieChix
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.
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.
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
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
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
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.
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