SQL Server has supported VLDBs (very large databases) for some time now. Back in the SQL Server 2000 days, I recall hearing multi-terabyte databases were unusual but doable. Now, they are commonplace, while databases in the hundreds of terabytes inhabit the part of the map that says “there be dragons.” While VLDBs are quite common on SQL Server today, highly scalable systems that can be flexibly extended in the same fashion as Oracle/RAC are less so. So, how do you design a highly available architecture for SQL Server if it’s not like Oracle/RAC. [READ MORE]
I enjoy working at Quest Software partly because we do a lot to give back to the community. Here’s one example, a free poster describing all of the SQL Server 2005 and 2008 dynamic management views. Get it here. It’s the perfect compliment to the free system map poster available from Microsoft here.
Professional Development for the SQL Server Technologist
This series of posts is dedicated to enhancing your soft skills. For many technologists, the day-to-day grind of work tends to keep us focused on the SQL Server part of work and causes us to overlook the Professional. While we, as technologists, spend the majority of our time honing hard, technology skills, but it’s important to remember that we are first and foremost employed to add value to the business processes of the organizations we work for. In this series I will cover a wide variety of topics, including soft skills like management, teamwork, communications, time management, and negotiations, as well as semi-soft skills like budgeting, project planning, project estimation, and so forth. And let’s face it, people who are good at the soft skills while also having strong technical skills often see better career growth and more opportunities than those of us who are purely technical.
To begin, I provide some homespun wisdom about effectiveness and efficiency in our jobs. These words are, of course, loaded with meaning and have produced multitudes of academic papers and big-name, New York Time best selling books. Everyone wants to be more effective and more efficient in their job. While I might bring up some of the more imaginative ideas and innovative concepts at other times in the series, I want to be direct with you today. Just as the simplest concept for financial well-being (“Spend less money than you earn!”) is sometimes the hardest to implement, so too the simplest concept for effectiveness and efficiency can be hard to make a workplace rule.
The first and most elementary rule of efficiency is to spend the majority of your time working on projects that are your forte. Management studies have shown that people aren’t just 50% or 80% more productive when working on what they’re best at, they’re actually 300%+ productive compared to activities where their skill is merely “satisfactory”. Here’s an example, if you’re really good at crunching code, do not spend lots of time attending and running meetings. Delegate that to another member of your time or find someone on your team who does enjoy that sort of thing. If you’re exceptionally good at performance tuning or designing databases into relational integrity works of art, do not spend all of your time writing requirements. You’re simply ruining your sweet spot for productivity.
Of course, many of us are on the prowl for a promotion or better job, which often require us to spend more time working on activities that are outside of our forte. I’ll address how to get back to your strong points when your job asks more of you in a future post.
Now, there’s a similar easy and elementary rule for achieving high degrees of effectiveness. The primary point to remember in being effective in your job is to focus your activities, at any given time, to only two or three things on which your performance will be judged. This might sounds simple and easy, but I’m constantly surprised how many people find it almost impossible to say “No” when more work comes their way (and this also applies to their personal life at the PTA, with the kids’ activities, with the church or volunteer organization, and so forth).
It’s very simple. If you cannot focus on successfully closing out a small set of activities, you’ll fail once you reach the point of being overwhelmed. Think of a juggler who seems quite competent juggling three balls. But when they try to juggle five balls, they’re lucky that they can keep one of them from falling to the ground. Plus, anyone watching is thinking “That person can’t juggle at all!” because they never saw the juggler successfully keeping three balls in the air. So, learn how much you can handle and then, when asked to do more, respond with “I’d love to take on this new project, but what of my existing projects has to be put on hold?” Taking on too many projects has the additional very detrimental effect of upsetting your work/life balance too, because most of us try to complete more projects by spending less time recuperating or with the family.
As with efficiency, we’ll come back in the future to specific techniques you can use to stay on task and limit the number of active projects you’re responsible for, even when management is asking you to take on more than you should.
In the meanwhile, think of other soft skill questions you might have and I’ll address them in future posts.
Each month, for six months, Arnie Rowland will be giving away a package of software, books, training, and development tools, valued at over $15,000, to an unemployed or underemployed developer that takes on a software project of his/her choice with a non-profit.
“The idea is to provide the recipient access to all of the tools needed to improve his/her skills, an opportunity to gain practical experience, the potential to earn a recommendation and/or referral –and to positively contribute to society as a form of ‘give-back’. No free lunch, just sweat equity –the kind that makes us all feel good for the effort.”
If you or someone you know is interested, the specifics are here.
Watch a full interview with Kevin Kline, president of PASS and technical strategy manager, SQL Server, Quest Software as he discusses the evolution of SQL Server.
It doesn’t seem like it was that long ago that my company’s IT department was bracing for a major new line of work. Back in the mid 1990s, we were going full steam into client-server technology. At the same time, we were significantly expanding our workforce. The IT department that had spent years as an old-style mainframe shop, was suddenly inundated with requests for new workstations, network user IDs, new network domains, permission requests, and requests for application access privileges. Our lone mainframe permissions person quickly felt overwhelmed and a little baffled by all of these new privileges and provisioning needs. Within a year or two of our first client-server application, we went from one to three staffers working full-time granting access to the various applications and network resources within our environment. [READ MORE]
My Vlog- Heather Eichman interviews Kevin Kline, the former President of PASS and systems specialist for the SQL Server Business Unit at Quest Software.
In July, Microsoft announced its new advanced training and certification program known as the Master’s Certification. (Read more about it at http://www.microsoft.com/learning/mcp/master/default.mspx). I’m really excited about this new certification because it fully lives up to the standard of “the appropriate certification for the appropriate audience.” For one thing, if you’ve ever gone to a martial arts school, you may find many talented martial artists and even several black belts there, but you’ll rarely find more than one “master.” Expect this new SQL Server certification to be equally rare and, hence, very meaningful regarding the certificate holders’ capabilities. [READ MORE]
O’Reilly Media on Facebook is a place for for anyone who is a fan of O’Reilly, whether you’ve been following their books, conferences, webcasts, and more since the very beginning or you recently jumped onto the bandwagon.
I really enjoy the newsletters and blogs from O’Reilly’s various channels, especially Tim O’Reilly’s commentary.
SQL in a Nutshell, now in it's 3rd Edition
And, of course, there’s my book – SQL in a Nutshell – published by O’Reilly for your consideration. This book provides a complete reference of the latest release of the ANSI SQL standard, as well as full coverage of support for the ANSI standard from the biggest database vendors – Oracle, Microsoft SQL Server, MySQL, and PostgreSQL.
Why companies should upgrade their databases to SQL Server 2005.
Please forgive posting this old video. Many of the tips are still worth paying attention to since SQL Server 2005 features and technologies are the foundation of subsequent releases.