Moore’s Law tells us that CPU’s get a LOT faster over time. Unfortunately for the database professional, all of the secondary elements of our databases DO NOT get a lot faster over time. Overall, the main methods of storing data since the 1960′s, magnetic tape and hard disks, have improved only in the single percentiles year over year. Even those of us who were never good at math can tell that the CPU is outpacing the other system components.
An Osborne Executive portable computer, from 1982, and an iPhone, released 2007. The Executive weighs 100 times as much, has nearly 500 times the volume, cost 10 times as much, and has a 100th the processing power of the iPhone.
Two recent developments are helping to change that equation. First, solid state drives (SSDs) are having a dramatic impact many IT scenarios. My friends, Brent Ozar and Paul Randall, have each written about SSDs here and here, respectively.
Second, database vendors are supporting relational database systems that run entirely in system RAM. If you’d like to learn more about in-memory databases (IMDB), read more in my new article in Data Management Magazine. As we look to the future, I expect to see a lot more of both technologies in the data center.
Just wanted to let you know that a TechNet Radio episode and interview I did about cloud computing is now live on TechNet Edge. It was the featured spot on Thursday, June 3rd and is also featured on the TechNet homepage.
I’ve been trying to wear more of an analyst’s hat these days, so this webcast has a lot of my “deep thinking” on issues related to cloud computing – hopefully at a higher level of quality that Jack Handy.
A salient point that I think many analysts are overlooking is the changing nature of data as it exists in the cloud. For decades, data has primarily been about people (and their activities) for consumption by other people. The cloud is enabling a major shift in data generation and consumption where data is produced by machines for consumption by other machines. We’ll soon be looking at situations, now rather rare, in which sensors are extremely commonplace. These sensors, whether they be in traffic signals or high-end medical devices, will create enormous amounts of data far more frequently than ever before, loading that data directly into cloud databases. The cloud databases will consume and process the data and, when automated analysis (made all the easier through features like StreamInsight in SQL Server 2008 R2) will flag important findings for review by a real-live human being. Check out the interview for several real-world examples being played out even as we speak.
Perhaps I can persuade you to blog, tweet, or place a link to it in your Facebook or team newsletter? Maybe with a few deep thoughts? Please? Pretty please?
And I welcome your deep thoughts and responses here.
Notice the bluetooth ear piece fashion faux pas? Yes, she's truly a geek.
I’m happy to report that Barbie is now a cognizeti, a digerati, … yes even an IT Professional! This year’s new Barbie is Computer Engineer Barbie.
Several months back, I encouraged all my friends and followers on Twitter to vote for the IT job for Barbie in Mattel’s recent public job selection for the eponymous doll. That encouragement was founded in an experience I’d had years earlier – becoming a dad to a very beautiful baby girl. When I was growing up as a kid, I clearly recall how odd it was for a woman to have a career outside of a handful of “traditional feminine jobs” like teacher, nurse, telephone operator or secretary. It wasn’t until years later, as a new dad, that I realized how asinine this preconceived notion really was (and, in fact, still is in many cultures around the world). I even wrote about this a few years ago in my personal blog, where I mentioned how I’d love to see my daughters grow up and take on an IT career.
Sadly, many IT professional societies report dramatic imbalances in gender demographics. For example, the IEEE Computer Society reports that their membership is only 7% female. Similarly, universities in the USA shows about a 10% representation of female faculty and 14% of their students in computer-related majors.
One of the things I’d always found to be rather amazing about PASS was it’s strong emphasis on Women in Technology (WIT). In fact, as far as database professional societies go, PASS was the first to work hard to make WIT prominent within its culture (although I believe that the International Sybase User Group had a WIT group before PASS). I’d like to also give credit to the women within PASS who made this happen. I can’t even begin to list them all here, but without them, WIT at PASS would not have been possible. A few women who immediately come to mind include Rebecca Laszlo, , Kalen Delaney, Denise McInerny, Kathi Kellenberger, Stefanie Higgins, Lynda Rabb, Kimberly Tripp, and many many more.
All of these outstanding women deserve accolades for making PASS a welcoming place for women. Don’t think that it’s a big deal? You should attend an IT conference without a strong WIT community – you’ll see the difference in 30 seconds flat. (I’m not going to name any names here. But attend the top conferences for certain IT companies headquartered in Redwood City, California or Armonk, NY and you’ll see what I mean).
So, thank you ladies, for making PASS in particular and the overall Microsoft SQL Server community much better for everyone by making it better for women. I hope to see this trend continue and for your contributions to continue to improve our community.
David Straithairn as the great Edward R. Murrow in the 2005 film "Good Night and Good Luck"
Journalists are important. In my opinion, they’re very important. The best journalists, like Old Testament prophets, speak truth to power and reveal the ugly dirt behind the pretty and public veneer of society. Their very presence foils corruption or, at least, helps reveal it, punish it, and make it dive for deeper waters else go extinct. It was for this reason that Thomas Jefferson famously wrote:
“The basis of our governments being the opinion of the people, the very first object should be to keep that right; and were it left to me to decide whether we should have a government without newspapers or newspapers without a government, I should not hesitate a moment to prefer the latter. But I should mean that every man should receive those papers and be capable of reading them.” –Thomas Jefferson to Edward Carrington, 1787. ME 6:57
(I’m red-green color blind, so forgive me if that quote is purple or some weird color like that. I just meant for it to be navy blue. But I digress…)
Sadly, the last couple decades have seen the blurring of journalism and entertainment. So much so that shock jocks now get byline billing as journalists and real journalists, in the search for better ratings and higher SEO rank, debase themselves and their content by injecting shock appeal. (This trend isn’t a new thing, btw. Historically, journalism has had other nadirs in the past, the most prominent being the era of yellow journalism spanning the 1880′s to the early 1900′s.) Of course, we see this every day on our television and hear it all the time on the radio – have any radio stations on your car tuner that you always skip? But I’d hardly expect this sort of thing to insinuate itself into an industry news niche like IT journalism. I mean, c’mon! IT is about information after all, and any distortion should surely become apparent in due time.
(Full disclosure: I’ve never been a journalist, but I do write a couple magazine columns – one, a technical column, for SQL Server Magazine and one, an opinion column, for Database Trends & Applications.)
The News Team the Revealed the Evils of McCarthyism in the 2005 film "Good Night and Good Luck"
So I can only begin to explain how jolted I was by this news story released by ZDNet.
The team at ZDNet has done some crackerjack investigative reporting to reveal that an often quoted “Windows Performance Expert” and CTO of a performance management and monitoring products company, Craig Barth, is in fact a fabrication by a well-known reporter and blogger, Randall Kennedy. Both personalities frequently disparaged Microsoft (not that Microsoft isn’t an easy target, they made BOB after all) and, in some cases, evidently created their own aggregate data, which was then used to identify individuals and broach privacy standards. Kennedy goes on to say that he did this with full endorsement of the companies he wrote for, and I quote “They didn’t want to lose 2+ million page views per year, which is what the shock jock persona they developed for me delivered.”
Journalists, and the managers of journalists, should take this as a wake up call. When you’re a trusted person, that trust is often your most valuable asset. I know that the entire media industry is under assault and its revenues are shrinking. But I hope that this has the positive side-effect of reminding everyone involved that quality and credibility are invaluable. Said another way, it’s impossible to place a real dollar value on strong ethics, credibility and trustworthiness, except to know that it’s worth a lot. (Someone remind Toyota and the Wall Street bankers of that too, while we’re at it.)
I’ve always been intrigued by our process for allowing creative content, such as songs or movies, to become public domain. A common usage for public domain might be to create a short family video and, seeking a peppy and familiar piece of background music, you settle on “The Entertainer”, by Scott Joplin. (If you’ve never heard of it, listen here. You’ll recognize it.) Since the music is past the 75 year limit of copyright protection, it is now public domain – meaning that you don’t have to pay or seek permission to use it for your family home video.
Now, it seems that many old media companies are deliberately destroying great old celluloid video footage rather than allow it to become public domain. Of course, there’s plenty of old TV programming that don’t have a single living fan, but we’re talkin’ about classics here like Jack Benny and the BBC’s Dr Who. Read this news story and this one for an example.
So, what do you think? Is this a misuse of private ownership of aging IP? Is this just another example of old media putting their finger in the dike of digital entertainment for the sake of a dying business model?
I find this to be particularly ironic since old media companies are the first to exploit public domain material for their own uses. Case in point, what’s the last Disney animated film you’ve seen (no, not Pixar – Disney) that wasn’t adapted from an age old story?
Before I jump onto the Goals and Themeword meme started by my buddy, Thomas LaRock (blog | twitter), I decided I’d spend a few minutes looking back on both the year 2009. (From a personal standpoint, the 00′s were my most difficult decade yet. Major problems of every stripe beset me on all sides and with alarming frequency throughout the decade. I was all “Good Riddance” and “Don’t let the door hit y’ass on the way out, 2009!” as the ball dropped in Times Square.)
Rather than spend a lot of time cooking up my own top 10 lists, I reckoned (that’s Southern for “thought”, btw) I’d recap a few others top X lists that are in the ballpark of my own personal opinion. I couldn’t resist putting together my own list at the end, which I’d love to hear your thoughts on. In addition, I want to hear about your Top 10 (or 5 or 3) for 2009!
Their Lists
Time Magazine’s list of Top 10 of Everything 2009 was a pretty good recap for the year on big ol’ cultural touch points like movies and music. I found at least one thing to agree with in each of their pop culture lists: movies – The Hurt Locker – check; TV shows – my personal favorite for its brilliant cohesive multiyear storyline and excellent character studies, Lost – check; album – I and Love and You by the Avett Brothers – check; books (sigh – if only I had more time) included the wonderful The Age of Wonders by Richard Holmes.
Lifehacker’s Top 5 Hive Topics of 2009 is a very interesting list covering lots of topics and pointing out a lot of interesting tools that I hadn’t encountered before. My personal favorite among them was the Top 5 Alternative File Copiers, since the Windows Explorer copy feature reminds me of hungrily awaiting my food in the microwave and just as the counter gets to the T-10 countdown, it goes back up to 30, then down to 8, then back up to 42, then down to 14.
I’m not sure if they meant to be funny but Digg’s Top 10 Most Popular Stories of 2009 is hilarious, much in the same way that Brent Ozar (blog | twitter) and I were when we put on an unintentionally hilarious performance at the PASS 2009 Summit Quiz bowl. Go ahead – ask Colin Stasiuk (blog | twitter) what he thought of our performance…
Impressed by Our Quiz Bowl Performance?
Speaking of unintentionally funny, have you seen Yahoo’s Top 10 Searches of 2009? Evidently, the median Internet user (at least from their metrics) is hormone-laden, teenage redneck with a thing for fast cars (Nascar), Hollywood hotties (Megan Fox), and an unassailable but secret love for Mormon-influenced Vampires (Twilight).
My List
I usually try to blog at least once per week and, when I can, even more. I still have this deep down urge to post lots of small blog posts of just a couple paragraphs. But for some reason, I always seem to come out with these big ol’ epistles. Despite my verbosity, y’all still read what I write and for that I’m very thankful. Over the last year, these were my top ten blog posts according to your interest:
Looking for Good DMV Database Admin Queries, where you can find just about every good DMV query ever written except those other really good ones that are posted here in the comments.
Things You Know Now, a semi-successful meme I started where I asked participants to tells us about stuff they’d do differently if they knew it way back in the day.
I excluded a few posts that were numerically in the top ten because, well, they’re my blog posts and I didn’t want them in the top ten. So there! But those that I excluded were things like reposting an interview done by another blogger or maybe a product or book that I plugged for some reason or an other.
I hope you’ve enjoyed my blogging and found it valuable. Tomorrow, I’m jumping on the themeword and goals meme. In fact, I’m crashin’ the party because none of my peeps called on me. [pout]
I was honored to be recently interviewed by the crew at Consortio Services. You can find my portion of this particular webcast at http://www.cstechcast.com/podcasts/cs-techcast/episode99/ beginning at 17:24. In the interview, I discuss a number of thoughts and opinions about the future of cloud computing, where our profession is headed, and more.
When I first became aware of the website, they were audio podcasts only. Since then, they’ve changed up their format a bit, and now have a video portion along with the audio. They now included a visual “slide” with your headshot and title (not a pretty sight, in my case). Also, they some scrolling shots of other things I’m involved with such as Quest Software, my blog here, my Tool Time column on SQL Server Magazine, and the SQL Server MVP Deep Dives book, and my personal website.
I encourage you to add this podcasting site to your list of favorites. There’s lots of great information waiting for you there.
Enjoy!
-Kevin
P.S. I just got the word that I have been re-granted MVP status for the upcoming year. Thanks to Microsoft and all my fellow MVP colleagues for making the MVP program such an awesome credential!
In the Sequels for SQL series, I point you to sites where you can go beyond the nose-to-the-grindstone resources that we see every day as SQL Server professionals. (My favorite resource for pan-SQL Server pointers is Steve Jone’s Database Weekly email newsletter.) These are the story that comes after and outside (the sequels) of our daily working lives (the other SQL). Let’s broaden our horizons together. If you hit on an interesting but overlooked topic, I’d like to hear from you.
SQL Server: We live it. We love it.
When Jimmy May talks, I listen. Not just because he’s a personal friend, but also because he knows what’s what, if you’ll pardon the expression. So when Jimmy says “I believe xPerf will fundamentally change the way I do my job”, then I want to know what the heck this free xPerf management tool is and how I can best leverage it. Check out Jimmy’s blog entry on xPerf here.
Devices & Gadgets: Usually making our lives better, sometimes not so much.
Ever wonder what’s inside one of those tiny USB hard drives? No? Not even a little bit?!? When I started in IT, hard drives where as big as washing machines and cost $60,000 running at speeds in the 100′s of RPMs. My how times have changed. Here’s a fun hack of a USB hard drive – http://www.dansworkshop.com/electricity-and-electronics/usb-hard-drive-hack.htm.
Futurewatch: Important issues just over the horizon.
There are a lot of standard elements of society being rebranded as the “2.0″ version of itself. The 2.0 moniker was first put forward by visionary Tim O’Reilly (blog | twitter), of the eponymous media company. Whenever you see the 2.0 moniker added to the end of something, most famously Web 2.0, then you know that it will include the characteristics of collaboration, interoperability, and user-centered designs. So, whereas the first go at the web in the mid- to late-1990′s was about enabling information retrieval such as transforming printed catalogs into on-line catalogs, Web 2.0 enables all of its participants to comment on, review, rate, and otherwise participating with each other in the use of such a catalog. In the last FutureWatch blurb, I pointed out work on Grid 2.0, centered on efforts to update the USA’s electricity grid. I’m going to do a much more detailed post in the near future about emerging 2.0 efforts, but one to point out now is Gov 2.0. Under this broad set of initiatives, governments from the lowest to highest levels of responsibility are opening up their public databases for consumption by the public. An example of Gov 2.0 in action comes with the President’s SAVE Award, in which the public is invited to vote on their pick for the best money saving tip put forward by federal government workers. Read all about this year’s SAVE Award here.
Humor: I haz da funny.
Weird products in Japan have their own name – chindogu. Most of these are crackpot inventions that everyone knows will never see the light of day, such as these these featured here. However, some of these products DO get marketed and, more amazingly, purchased. Check out the product reviews of this totally bizarro chindogu here at Overstock.com.
Professional Development: Because there are two words in “database professional”.
There are mountains of great websites with tips on how to be a better speaker. Some day, I’ll write a long blog post about my favorite sites for learning how to improve your oration. But if you’re in a hurry, and who isn’t these days, then this blog post at TechRepublic succinctly sums up the advice you’ll find from many other web sites, articles, and blogs.
Society: Important issues to discuss with your friends and family.
One of the most remarkable things about the USA, as a rather biased citizen, is our ability to suck up our pride, admit a mistake, and try to prevent it from happening again. One way that the USA tries to prevent future occurrences is to convene a commission of some kind. I found this analysis by David Leinweber, a Haas Fellow in Finance and Founding Director of the Center for Innovative Financial Technology at UC Berkeley, on the commission studying banking market reform in the USA to be quite intriguing and, frankly, upsetting.
WorldView: If James Bond knows that the world is not enough, then so should I.
I’m always on the lookout for issues related to safe and clean water. If you think people can be grumpy when oil is in short supply, imagine what it’s like when there’s not enough drinking water for everyone. See how India is dealing with enormous water issues in this revealing article from the Economist. And I’d be interested to hear what our Indian blogger friends thoughts are on this topic, folks like Rushabh Mehta, Jacob Sebastian, and Pinal Dave. (Water issues have remained one of my passions ever since my years working for NASA developing the water recycling systems for the International Space Station, in which we made water of the H20 that passes through the human body re-drinkable. And it tastes good. Incidentally, all of the technology we developed for this project, as with all non-classified government projects, became public domain. ECLSS technology is now used in hundreds of commercial products ranging from household detergents to commercial solvents to filtration systems.)
I’m starting a new series called Sequels for SQL Server. In this series, I point you to sites where you can go beyond the nose-to-the-grindstone resources that we see every day as SQL Server professionals. These are the story that comes after and outside (the sequels) of our daily working lives (the other SQL). Let’s broaden our horizons together. If you hit on an interesting but overlooked topic, I’d like to hear from you.
Professional Development: Because there are two words in “database professional”.
Peter Drucker, one of the greats in management thought-leadership, would’ve turned 100 last week were he alive today. Check out these top 20 quotes from the man who revolutionized management theory.
Society: Important issues to discuss with your friends and family.
Quoting the Motley Fool, “We spent the latter half of 2008 feeling the wrath of “too big to fail.” Today, banks are bigger than ever. We need to end that. Now.” It’s Time to End “Too Big to Fail”. Read this thought-provoking article soon.
WorldView: If James Bond knows that the world is not enough, then so should I.
The smartest analyst on international issues out there, Fareed Zakari, discusses US and Indian relations in this insightful article from Newsweek.
I was happy to hear that the magazine Database Trends and Applications had recently relaunched their website. While I’d been a columnist there for a quite a while, I’d never been able to easily find my own articles nor check to see if they’d generated any interest. DBTA has changed all of that with their relaunch. I was also surprised, upon closer examination, that I’d been writing there for more than a year. Check to see if any of these articles are of interest to you. I’d love to hear your thoughts.
The November article just went live this week. The site traffic is 79% North America, with India and the UK as the next largets readership markets. It was heartening to see a relatively high level of interest in the “Code of Ethics for DBA’s” among other topics.
If you are perceiving a trend or overarching issue in the SQL Server world, I’d love to hear your input. Drop me a note here or use one of the methods available on http://KevinEKline.com/Contact/ to get in touch with me directly.
