Quiz image via Shutterstock
A new semester is about to start for many students but it’s time for another pop quiz for our ITKnowledgeExchange community on Microsoft Excel! See if you can answer any (or all) of the questions below and we’ll give out 100 Knowledge Points for each approved answer. Good luck!
- How can a user download data from SAP to Excel using pivot tables?
- How can you keep symbols and numbers together in an Excel column when wrapping text?
- Is there a way to open Excel and Word files without the ‘read only’ screen?
- Can a user keep the same formatting when transferring a report from Oracle Reports 11g to Excel?
- What do you need to do when exporting data from SSIS to Excel?
- How can a user overcome the ‘Could not find installable ISAM error’ in Microsoft Excel 2007?
- How do you incorporate combo boxes into a Microsoft Excel file?
- While having two interlinked Excel workbooks, does a user have to put the same password in for each one?
- Is there way to implement conditional formatting for tracking schedules?
- How does a user copy and paste data into a cell without the previous chart disappearing?
This has been a great year for ITKnowledgeExchange as we welcomed many new bloggers. As the year draws to a close, it’s time to take a look back at the top blog posts of 2012!
- Transformer Pad/Prime Infinity release date by Nathan Simon (The Real and Virtual Adventures of Nathan the IT Guy)
- Resolving MySQL error 1146: “table doesn’t exist” when doing backup by Eric Hansen (I.T. Security and Linux Administration)
- NRPE: Could not complete SSL handshake by Eric Hansen (I.T. Security and Linux Administration)
- Oracle declares war on cloud and open source by Ron Miller (View from Above)
- Oracle the clear leader in $24 billion RDBMS market by Mark Fontecchio (Eye on Oracle)
- Buying a touchscreen for Windows 8, episode 1 by Ed Tittel (Windows Enterprise Desktop)
- Interesting fallout from Windows update KB2762895 by Ed Tittel (Windows Enterprise Desktop)
- Interesting Windows 8 issues on Lenovo X220 tablet by Ed Tittel (Windows Enterprise Desktop)
- Cisco ASA 9.x – Coming soon by Joshua Wood (TechStop)
Keyboard image via Shutterstock
It’s been a great year full of questions, answers, discussions and more here at ITKnowledgeExchange, and I want to thank you all for your contributions. We’re looking forward to much more to come in 2013, with new site features like improved code formatting and a major new project that will further integrate the community with the extensive TechTarget network and let more people see all your great contributions (more on this soon). I’m really excited about how this site will grow and change over the next several months, and I hope you are, too.
Over the next week, we’ll be sharing some of our favorite content from the year, but for now, I want to point to a few recent changes we’ve made over the past month or so. (I won’t call them “gifts,” but I can’t stop you from doing so.)
- If you’re wondering how your activity compares to other site members, you can now check this using the ‘badge rank’ link on your profile page. By checking out the Linux badge ranks, for example (https://itknowledgeexchange.techtarget.com/badges/linux/), we see that carlosdl has the top spot, with rechil not far behind at #2. You can view the rest of the topics in the menu on the left side of the page. I can already feel the competitive juices starting to flow…
- The tag alerts function should now be working properly again. When logged in, your e-mail address should be showing in the box on the right sidebar on the homepage where it says “Subscribe to Alerts”; click the Subscribe button and you’ll be able to sign up for notifications on the topics you care about (you’ll get them in a daily digest).
- We’ve updated the featured questions box that shows on the homepage. This is where we post some of the most challenging and/or most interesting items that are submitted so you don’t have to hunt for them. (We also post some tough unanswered questions in our IT quizzes, so be sure to check those out.)
- We’ve started up a series profiling our members and bloggers over on the ITKE Community Blog. We talked with all-time points leader Tom Liotta recently, and we’ll be contacting you all down the road so you can get your moment in the sun. Watch out for an email from Michael Tidmarsh, our Assistant Community Manager, who will be taking over a lot of these kinds of communications.
- We’ve also welcomed several new contributors to our blogs. Brian Gracely has been doing a great job on his new blog, From Silos to Services: Cloud Computing for the Enterprise. Longtime blogger Robin Miller is now covering tons of ways to save money (especially during the holidays!) on his new Cheap Computing blog. AS/400 expert John Anderson, who you may have seen around the forums, has started up a new blog covering, appropriately, AS/400 and IBM i Tutorials. And ITKE veteran James Bingham (aka harisheldon) is now gathering Tech Support Horror Stories. Make sure to check out all these blogs and offer your comments as you have them.
As always, if you have questions or concerns about something that’s happening in the community, or ideas for how to improve things, please don’t hesitate to contact me or Michael.
Thanks again for all that you do, and have a great holiday!
ITKnowledgeExchange recently had the opportunity to talk to this month’s ‘featured member’ Tom Liotta. He is constantly active within the ITKE community, answering questions in several topic fields.
ITKE: Tell us a little bit about yourself: What do you do? What’s your area of expertise?
TL: Right now, I’m not doing anything. I resigned my previous position at the end of July, and I intend not to look for anything for the next year. My position for the previous 12 years was as systems programmer for an IBM business Partner, producing network security, system auditing and compliance products for the AS/400 line.
I might not have an area of expertise. My initial work experience was with mainframes since that was a big part of the industry at that time. From there, my work moved to IBM midrange systems and then to PCs of various types.
After being away from IBM systems for a few years, I took some contracts for work with System/38 sites. The first basic S/38 project didn’t go well technically because of lack of understanding of the new non-Cycle structure of RPG III, the impact of externally-described files and the object-based nature of CPF (the S/38 OS). But late in that project, those three concepts suddenly took hold and I haven’t looked back since.
As the rumors about Silverlake (AS/400s) circulated, I worried that IBM mainframe division influence might result in a disappointing product. I was fortunate to be fully involved in the first customer install of an AS/400 in the Pacific Northwest in September 1988; and the experience with that system, as rough edged as it was at the time, convinced me that AS/400s would be the focus of my career from then on.
ITKE: If you weren’t working in IT, you’d be…
TL: I don’t know. College was originally attended as a psych major. Though it was easy enough, the realization came after a few years that it was mostly BS. It took a number of years to find out why, but in the meantime I’d gone back closer to home and started a more general schedule of classes just to try various things.
I took a statistical analysis class and signed up for the extra credit version that had us solving problems by coding Basic on a remote timeshare CDC system. The thought came that it was the kind of thing I could make a living at. I started a full schedule in the ‘Data Processing’ track. (Everybody remember when that’s what it was called?)
That’s been the track I’ve been on ever since.
ITKE: Who’s one person you look up to in the IT world, and why?
TL: Robert M. Wooldridge — I know he’s not likely to be known by many, or any, who read this. He’s mostly just a regular IT pro. No books authored, no industry changing inventions, none of the usual stuff that turns people into followers. But he has a characteristic, a natural talent that has kept my interest for 40 years. Simply put, he sees how business processes ought to be automated. It’s a talent because he seems to do it without effort.
Since getting on this track, I always wanted to have that talent. But the most I could do was keep it in mind as I worked for my employers. I always try to influence directions so that processes are automated “the right way”.
ITKE: How do you see the future of IT developing over the next decade?
TL: I’ll wait to see how Oracle v. Google ends before deciding. The healthy survival of Android could be crucial to how the next decade goes. Microsoft will push for its kind of phone/tablet/notebook/desktop/whatever single-standard. Apple will be doing similarly. I’d like to see that Android is where some real innovation arises and causes a change in how we interact with automated systems. And there’s no doubt that everything is going to be automated by the end of the decade.
That is, every type of electrical device that you’ll be able to buy will have an “intelligent” version. Possibly house power circuits will be integrated with a communications network (as I’ve used mine for a few years) or a Bluetooth variation will be used. Regardless, we’ll come to expect that everything can be controlled from wherever we are.
For IT, this will drive a lot of our development effort. (And we’ll have to expect to develop wherever we are.)
The pressure will come from the personal experiences of every user. We’ll have to make everything available to all users who need it wherever they are.
ITKE: What advice would you give prospective IT workers (say college students)?
TL: Quit now?
Best thing I did as a student was to learn how to locate, read and understand vendor documentation. Having forums such as ITKE is a development from my later years. They’re very handy for specific problems, but they aren’t helpful for an actual career unless the working platform can first be understood in a way that a vendor intends.
I often actually read through vendor (mostly IBM) manuals. I rarely read specifically to understand, but rather simply to see what is written. Later, as I’m coding something, the things I previously read come back as vague recognitions. I remember running across a reference, and I have a reasonably good feeling that I can look it up. When I then get back to it and read it with a real problem in mind, it almost always makes sense where it was only a series of words before.
Vendor documentation is the authority. If it doesn’t work, make the vendor fix it. If they won’t, then internet forums become much more valuable.
After vendor documentation, keeping products current is next in importance for a career. Working for employers who keep obsolete versions limping along is not valuable for an employee. You can find those employers late in your career, and then you might be one of the few who the employer can find. By then, you can name a price more to your liking. But early in a career, keep your eyes open for shops that keep up with vendor releases.
Don’t get chained to obsolescence. Your employer might not be in business long, and you’ll need current skills to find a next good job.
Linux image via Shutterstock
Are you a Linux expert but want to take your knowledge to the stage? Mark Sobell’s A Practical Guide to Linux Commands, Editors, and Shell Programming is the book for you as it covers best practices and examples for each Linux version including: Ubuntu, Red Hat, CentOS and Mac OS X. We’ve got an excerpt of the book up on our IT Bookworm blog.
Tell us what confuses you the most about Linux in the comments and you’ll be entered to win a copy of the book. Good luck!
The consumerization of IT has emerged as a growing trend within the industry, with consumer devices and applications playing an increasingly important role in the enterprise.
From using personal tablets and smartphones to accessing third-party cloud services and social media platforms, users no longer depend on guidance from their companies to get their jobs done and IT departments need to keep pace. Companies worldwide must decide how to address the security and compatibility concerns that come from this blending of personal and business technology.
Does your company have a ‘Bring Your Own Device’ policy? How are you handling ‘rogue’ users and insecure environments? The links below will help with understanding this important shift.
Here are some of the most active conversations on ITKnowledgeExchange.com on consumerization topics:
View all consumerization discussions in the community.
Several ITKE bloggers have also provided perspective on consumerization:
- ‘Consumerization’ means different things to different people by Scot Petersen (CIO Symmetry)
– Scot Petersen looks at the true meaning and impact of consumerization and determines that it really depends on who you ask (as the comments prove).
- Podcast: Coping with consumerization by Jessica Scarpati (Security Wire Weekly)
– In this podcast, several security experts discuss strategies on dealing with the increase of consumer devices in the enterprise and making sure sensitive data is protected.
- Who makes the rules? by Christina Torode (TotalCIO)
– When it comes to dealing with consumerization, the command and control’ approach continues to be common in many companies, but who controls the approach is still up for debate.
- The evolution of CoIT: Part 1 by David Scott (The Business-Technology Weave)
– IT business expert David Scott looks at the beginning of CoIT and how it started through the phenomena known as ‘Bring Your Own Device’ and the different issues, policies and practices associated with it.
- The evolution of CoIT: Part II by David Scott (The Business-Technology Weave)
– Scott discusses the realities of consumerization and the main ways of managing the challenges it presents.
Quiz image via Shutterstock
For many students, Winter break is just around the corner but the ITKnowledgeExchange team wants to test our members once again by giving a quiz on Lotus Notes! See if you can answer any (or all) of the questions below; we’ll give out 150 Knowledge Points for each approved answer. Good luck!
- How can a user calculate duration for annual leave in Lotus Notes 8.5?
- Why does the hotspot button add 4-5 lines of predefined text when you’re scheduling a new meeting?
- How can you automatically create a hotspot URL inside a Lotus Notes email?
- Why does Lotus Notes keep telling a user that there are no OLE objects even though he can see them?
- Is there a way to select multiple values in drop down fields?
- While trying to export a report to Microsoft Excel, can the header row be frozen?
- How can a user set up a pop up reminder every Friday when he exits Lotus Notes?
- After successfully creating a calendar document, why doesn’t the document show up in the calendar view?
- What do you need to do to display the weekly birthdays in a calendar view?
- Is there a way to manually activate Lotus Notes?
Webcast image via Shutterstock
Join us for a live webcast on Wednesday, December 5th at 2 p.m. ET as industry experts Greg Shields, Founding Partner at Concentrated Technology, and Frank Nydam, Director of Health Care Solutions & Business Development at VMware, will give tips and best practices for virtualizing your XenApp servers.
Following the webcast, you will have the opportunity to ask your own questions live from our panel.
Don’t miss your chance to hear from leading experts – Register today to get insight into the following:
- Virtualization strategies that reduce infrastructure complexity Allowing the servers to be included in the same management and DR pools with other virtualized servers
- Allowing common management and DR pools in mixed environments
- New approaches to reduce or eliminate planned and unplanned downtime
- And much more!
Bonus! All LIVE attendees will automatically be entered in a raffle to win a new iPad!
ITKnowledgeExchange recently had the opportunity to talk to this month’s ‘featured blogger’ Robin Miller about his new blog, Cheap Computing. His blog will be your guide to low-cost computer hardware and software for both home and business use.
ITKE: Tell us a little bit about yourself: What do you do? What’s your area of expertise?
RM: I’m a reporter and editor who covers IT, not an IT person. Think of me as a sportswriter, except I write about programmers and sysadmins instead of quarterbacks and tight ends. My area of expertise is getting behind press releases and product announcements to see who’s really doing what and why they’re doing it.
ITKE: If you weren’t covering IT/tech, you’d be…
RM: I’d be writing about crime, politics, science, and other human passions. That’s what I was doing before IT reporting became the bulk of my work.
ITKE: Who’s one person you look up to in the IT world, and why?
RM: Just one? Linus Torvalds would be an obvious answer. Richard Stallman would be another, not only because of what he’s accomplished but because he’s the only person I know personally who’s gotten a MacArthur “genius” grant. Someone a little less noticed who has done a lot of background work to help build the modern WWW is Brian Aker, who was the Director of Architecture at MySQL in pre-Sun days. And done a lot of other important things the general public — even the general IT public — has never heard about.
ITKE: Complete the following sentence: “Cheap computing is ______”.
RM: an extension of my belief that even if money *can* buy happiness, you should try to get the most possible happiness per dollar spent. I’ve been through a couple of phases in my life when I was determined to have the latest gadgets even if it cost me big-time. And it did! Not just in money but in stress, dealing with beta hardware and software that wasn’t really ready for production use. Now I look for good deals on proven — even used — devices, and I use more free and open source software than proprietary programs. I not only save money, but lead a happier and more relaxed life. The funny thing is, when you apply this same philosophy to SMB and enterprise IT, you get lower budgets, higher reliability, and happier bosses. And happier IT staff, too, because they aren’t dealing with as many emergencies.
ITKE: Why should IT pros read your blog?
RM: I’m 60 years old. I’ve watched people waste money and energy on overpriced and troublesome computers and other high-tech devices since the 1960s. I have a lot of experience — not necessarily my own — to pass on about how to save money and aggravation in your dealings with the ever-evolving whirl of gadgets and technological capabilities that keep our lives interesting as long as we don’t let ourselves get overwhelmed by the money we spend to buy those gadgets and the time and energy we spend to maintain them.
Management image via Shutterstock
Within every business and company, managing your software development team can be a difficult process. If you’re looking for new ways to manage your team and deliver software efficiently and effectively, Mickey Mantle and Ron Lichty’s new book, Managing the Unmanageable: Rules, Tools, and Insights for Managing Software People and Teams, will provide you with different tips and tricks to become a successful manager. We’ve got an excerpt of the book up on the IT Bookworm blog.
Share your favorite quote or story about a manager or management challenge you’ve had in the comments and you’ll be entered to win a copy!