Tomorrow night – Stat 5001, “Quantitative Methods for Business” – class #1. All weekend, per my program director’s instructions, I’ve been installing software on my machine:
- Office 2016 – check
- JMP – check
- SAS – check
- Pearson Electronic content – check
Thing is – installing software doesn’t mean knowing how to use it.
Ever since acceptance into this program was a certainty, I’ve been wavering between”Holy crap, what have I done?” to “Breathe…just breathe”.
Are you recognized as a leader in your field? If not, are you ready to be? That is the tag line for the announcement that applications are being accepted for the third installation of the ODTUG Leadership Program. Are you considering applying? If not, you should be!…You won’t find a more encouraging group than the ODTUG leaders. They are some amazing people who are there to help you grow and shine, and offer support and guidance along the way. I am extremely grateful to have been through the program and hope we see more and more people come through.
I wrote those words over a year ago as part of the pitch, when ODTUG announced the opening of the application period for the 2015-2016 Leadership Program, and they ring true just as much now as they did then.
I discovered ODTUG three years ago, in April of 2013, when I stumbled upon some content during a Google search, to help answer a technical question I was researching. On July 16, 2013 I became a full, paying member in order to gain access to past webinars and conference presentations, and doing so has become one of the best decisions I have made. Not only have my technical skills benefited from the knowledge I’ve gained from their content, my life has become enhanced by the amazing group of people associated with this user group. Not only have I made great professional contacts through ODTUG, even better – I’ve made some wonderful friends, who I am so grateful for and who enhance my life on a daily basis.
In the three years since joining, I have contributed to the organization by serving as a content review committee member for Kscopes 15 and 16, being an active member of the Database Community, and in the 2014-2015 year, I applied and was accepted into the Leadership Program. The Leadership Program consisted of virtually attending monthly webinars, that were always engaging, enlightening, and inspiring, and whose lessons have definitely contributed to the person I am today.
This year, I can add Kscope16 presenter to my list of contributions, as well as having the honor of being the leader for the 2016-2017 incoming Leadership program class!
Applications are now being accepted and the deadline to apply is 8/14/16. Apply here: ODTUG 2016-2017 Leadership Program Application
Tomorrow morning I’ll be on the way to one of the best tech conferences I have ever attended – ODTUG’s Kscope.
I virtually knew many folks in the Oracle Developer and EPM communities before attending my first Kscope conference last summer, from our communications on social media. So it was great to meet so many IRL after having texted, emailed, Tweeted and Facebook-liked each other’s posts for many many months.
This year, thanks to the encouragement of Chet Justice, (@oraclenerd ) who has become one of my closest friends and mentors, I’ll be presenting for the first time at Kscope, and for only the second time, ever. Chet graciously offered to be by my side as my co-presenter and “PL/SQL Outtakes” can be seen Tuesday at 3:30.
I’m looking forward to seeing friends, learning from some of the best Oracle folks on the planet, and enjoying Chicago!
I have been a software developer for the past 20 years. I have so many friends in the BI/BA side of the house that my curiosity got the best of me- and as of 8/29 I’ll be pursuing an MS in Business Analytics. There is a dual program option – where with the addition of five more classes, I could get the MBA as well as MS degree.
Time will tell if I am cutout for this. I have already been networking with my fellow Fox School of Business classmates, faculty and staff. Here is a glimpse of last night’s soirée at Indepenece Beer Garden:
And I’ll be attending the ODTUG pre-Kscope16 Meetup with the Philly EPM community folks next week.
A friend asked me why I’m seeking out this second master’s degree. I said it’s because I want to learn about business analytics . She said “You can read about business analytics on the web if you want to learn about it. You don’t have to get a Master’s degree in it!”. True enough – but with my free tuition benefit as an employee of Temple University – why NOT go for the gold? Plus I’m no way disciplined enough to take the time to learn something on my own. I get too easily distracted.
Here I go!
Being busy and involved is something I thrive on. But there are times, when I want to keep my head under the covers when the alarm rings, and “do nothing” all day. Then there are days when I feel like I can tackle the whole world, and shout, “BRING IT!“.
I imagine this tidal pattern of energy and enthusiasm cannot be unique just to me. It MUST happen to all busy people. Leaders are constantly under the gun to perform, to always be on their game. Some days I am 110% up to the challenge. Others – meh. Not so much.
Finding a balance is key. I haven’t quite worked this out yet. I teeter-totter between “Go team!” and “Leave me alone”. I’d really like to hear from anyone who feels they have mastered the balance, are good at keeping the energy flow going, at replenishing.
I’m already eating well, working in more exercise to the daily routine- which definitely helps. However, I find when I try to do down-time, I end up drowning in it. Recently I spent an entire week’s worth of evenings, on the couch in front of the TV – which horrifies me. I just could not get motivated to DO anything.
Thoughts? How do YOU stay motivated? Where’s YOUR balance?
I am constantly trying to improve upon my organizational skills, keep track of how I spend my time, and battle the inner procrastinator. I have tried many online tools and apps to assist in the quest for time-keeping perfection and the most useful tool I have found is toggl.
It’s free. It’s easy to use. It’s web based. Oh and it’s FREE.
At my job, I have to submit my time sheet electronically, and my biggest problem there has always been: I’m great at tracking Mondays, and by Wednesdays I’d fall off the wagon, causing me to think, “Now what was it I worked on this week?” by Friday when I had to submit my time.
With toggl, I just keep the website up, hit the “Start” button on the timer as I begin a new task, name the task, hit “Stop” when I’m done and the cycle continues all day long.
The nicest part of all, toggl emails me a pretty report at the end of the week, with all my work details. Here’s a small sample of last week’s report:
Check out toggl at https://toggl.com/
Yesterday while reflecting on a recent visit to a butterfly farm in St. Martin, I came to the realization of how I’ve been cocooning myself lately. And I was at an all-day WordPress camp yesterday and thought it’s time to shake the dust off here.
Maybe it was the winter doldrums that kept me away: Grey skies = grey moods. In any case, I feel the promise of spring approaching and an awakening.
In other words..I’m back.
Just 17 days ago, I found myself in front of a mostly-filled room, talking about PL/SQL and Ellucian Banner “stuff”.
It was my first time presenting to a tech crowd, and I was so grateful to have my very cool, calm, collected, and knowledgeable colleague, Sue as a co-presenter.
Here are a few take-aways from the experience. My all-things-tech-and sometimes-life-guru and friend, Chet Justice (@oraclenerd) suggested, “Write down what you learned now – or you’ll forget it for the next time”.
So here are my top 5 lessons learned as a first-time presenter at a tech conference:
No. 1 – Fake it ’til you feel it. The nerves were there. I tried not to allow them to rattle me, nor make me appear incompetent. I thought of some of the Kscope15 presenters I saw last June, those folks who seem like it is second nature to them to be in front of a crowd, and tried to channel some of their chutzpah. Like Jeff Smith (@thatjeffsmith) , Bryn Llewellyn (@BrynLite), Steve Feuerstein (@sfonplsql), and Heli Helskyaho (@HeliFromFinland) to name a few.
No. 2 – It’s not about “You”. I once went to a public speaking seminar – and the single most valuable bit of information the speaker gave to us was this: It’s not about YOU. It’s about the information you’re giving to your audience. It’s about THEM. Once you don’t make it about YOU, the nerves will subside. Thus, my mantra for the day, that looped constantly through my head the days leading up to, and day of show time was: It’s not about me. It’s about them.
No. 3 – Leave the props at home. I was under-prepared. I did not commit to memory what I wanted to tell the audience. I had note cards in one hand, the laser pointer in another, and it was most likely distracting to the crowd as I flipped through my cards and tried to juggle the pointer and cards.
No. 4 – Practice, practice, practice. Even if Carnegie Hall is not in my future, next time I’ll be more prepared. Which is what Bobby Curtis (@dbasolved) told me to do, but I just ran out of time. You can never be over-prepared. I plan to record myself practicing next time – and watch – and remove any cringe-worthy moments by running through it all over and over and over…until I could spit out the information in my sleep.
No. 5 – Have more than one version of the slide deck. The room I presented in was very large, and the projector made the slides appear so small, that there is no way that anyone in the back of the room could have seen what I was pointing out. To accommodate room size and projection-related issues next time, I’ll have a larger-print version of the deck, as well as a regular version. And maybe even print out some handouts. Maybe.
I have been working with Oracle technology since 2010, and know my way around a database well enough, and do an okay job supporting our E.R.P. system at my job. However, I’m no PL/SQL nor SQL expert. Far from it. And some days I just don’t have the time nor the inclination to “Ask Tom”, so I resort to the tools I am familiar with, no matter how elementary/rudimentary they may be, to get me through the day.
For example: I recently was in a situation where I had to copy three of our prod tables down to a non-prod schema, renaming the tables and each column in the table, for training purposes for a new staff member, so he could follow along with the way the tables were structured in a training manual. I work at Temple University (Go Owls!) which is an Ellucian Banner school, and Banner’s table-naming standards are such that the column headings each have the table name in them. For example, on the SPRIDEN table, every column is named SPRIDEN_[something], as in SPRIDEN_ID, SPRIDEN_FIRST_NAME … you get the picture. But the training manuals referred to tables in a training schema I no longer had access to, the SWRIDEN table, and all column names SWRIDEN_[something]”. Some of these tables have hundreds of columns and I was not inclined to type hundreds of ALTER TABLE” statements into my SQL Developer editor window. Maybe I’m just lazy.
So after creating the new tables by copying the prod versions, via SQL Developer, I could not find a way to globally rename the column headings for the newly copied/renamed tables. If there is such a way to do this, and anyone who may be reading this article knows how, I’d greatly appreciate a comment telling me how to do so. In other words, is there a command where I can say: rename all columns on a table from __ to __?
Instead, I handled this with the tools at hand that I’m familiar with. My Methodology may make you cringe. But remember- this is “quick and dirty” hack # 1.
First thing: I set my SQL Developer Database preferences for Drag and Drop to format select statements for me, so that I would not have to type out each field name on these very large tables.
Next, I selected all of the columns and copied them: (Ctrl+C) …
… then pasted them onto a new Excel worksheet, in the second column, B (Ctrl+v)
Since each column name is followed by a comma, I globally removed them on the worksheet by selecting the column, and doing a “find & select” then going to the “replace” tab. I just replaced the commas with a space (Literally a hit of the space bar).
Next, I copied that column, with its removed commas, on to another column, skipping one in between. So I went from column “B” to “D”, making sure I pasted as “values”:
Now I had identical data in columns “B” and “D”, and needed to replace the old column names with the new. So just like I used “find & select” to replace the commas in column “B” with spaces, I did the same thing in column “D”, replacing the old table name with the new, or in my case, replace SPRIDEN with SWRIDEN:
So far I had:
I was then ready to build the “ALTER TABLE” statements.
In column A1 of the spreadsheet, I entered my alter statement: Alter table SWRIDEN rename column. In C1 put to and in E1, the semicolon to end the SQL statements I’m creating:
To copy the alter statements down to the last row in A that is adjacent to B, don’t click and drag! The easiest way to fill a column in Excel is by hovering over the bottom right corner of the cell you want to copy down, until the small square black box appears in that corner, then double click on the small black box:
Fill columns C “to” and in E the semicolon
The alter statements have now been built. Then I simply copied and pasted them right into SQL Developer and executed:
I hope this little hack will be useful to others out there who may be new to SQL, and just need a fast way to get something done, with older, more familiar tools. Look for more quick and dirty hacks to come. I’d love to hear some of yours as well!
One day in the Twitterverse, a young colleague, Justin Biard, posted a quote regarding professional’s abhorrence to “messes”. That really resonated with me. As one who has frequently had to “put out fires” and had to clean up bad data caused by others’ (and sometimes her own) erroneous code, nothing instills more fear and frustration than those four little words: “We have a problem”. I fear job aborts, Oracle ORA- errors, endless loops… the list goes on and on. Just writing the words gives me a pit in my stomach.
I asked Justin what the source of the quote was from and he told me about a book he was reading called The Clean Coder. We chatted a bit more about the gist of the book, and if he thought it was a good read, and then inquired as to whether he’d consider posting a review of the book here, as a guest blogger. He happily agreed! So without further ado, I give you Justin Biard:
Reading The Clean Coder
Do you have forty-plus years of experience in technology or programming and consider yourself to be a professional? Do you have a pretty good sense of what it means to be a professional programmer? Do you actively mentor and share that knowledge with others around you? Yes, or no, I’m humbled that you would take the time to stop by and read these words. Thank you.
What are we doing here and why is Helen letting this guy ramble on her blog?
As someone who loves learning how technology works, I *could* be called a nerd, a geek, a techy, or maybe just… a slightly introverted person with Internet access and a penchant for computers. Whatever you call it, I love what I do. I also hang out with other people who love what they do. And because everything sounds better with an “Ugh” at the end, we form a group and call it ODTUG (pronounced Oh Dee Tug). This is not a shameless plug for the user group, this is how Helen and I were introduced, through a fellow “nerd”. (We are looking at you Chet @oraclenerd)
” …you will drive the system into a swamp from which it may never escape. Professionals fear messes far more than they fear blind alleys.”
This got Helen and I talking about the book and mentorship. Helen asked if I’d be willing to share my thoughts on the book. So here we are.
Note: On the topic of mentorship, Helen started a great series here on her blog. (Stop reading this post, read her posts if you haven’t yet, and then come back here to finish up!)
Is this book about programmers with good personal hygiene?
No (well… maybe?) This book is about professional hygiene. Its about the mindset, the habits and attitudes that a programmer should pursue to achieve professionalism. It is also full of what seem to be pragmatic opinions, grounded in truth.
If you are a professional programmer or mentor of programmers already then you should expect to read this book for enjoyment, rather than education.
Is this book a technical reference with lots of code samples and recipes for solutions?
No, this book is definitely not a technical reference. It does not contain many, if any, code samples. However, it is an insightful look into the history and thought process of someone with over four decades of experience making mistakes as a developer and learning from them.
I work in (or with) IT, maybe even manage a team of developers, but my career is not focused on full-time programming, will I get any value from reading this book?
It depends. To tell you the value of reading a book without first understanding your own needs could be like trying to give fish to a fisherman or it could be like giving delicious bread to the famished. Are you the fisherman (professional programmer or mentor) or the famished (early career developer) possibly starving for mentorship?
Assuming we care about your opinion……. What did you think about this book?
Of my own opinion… Personally, I really enjoyed the book. It is well written. Martin uses plain English and tells plenty of interesting stories. For me, it was a lot like watching an old friend or mentor teach a class of up and coming developers and getting to take notes on technique and style.
On mentorship, I would use this book as a conversation starter to help define professionalism as a programmer and to understand the development philosophy of a team. Martin touches on a wide range of topics including things like:
* When to say “No” and how to say “Yes”
* Various levels of testing
* Time management
I am not a full-time “programmer” (in the traditional sense) and I don’t need to agree with all of Martin’s choices or tool selections, but even then, the spirit of his advice was still relevant. The breadth of topics he covers is a thoughtful roadmap to professionalism as a programmer. Don’t buy this book because I thought it was good. Research it for yourself. Read some reviews on Amazon (or wherever you buy books). Ask around and get other opinions.
Whether or not anyone else reads the book, I hope you all aspire to be (or to continue being) professionals and that you love what you do.
Thank you Helen, for the opportunity to share my thoughts with your readers.
Follow Justin on Twitter @icodealot