Search results matching tags 'Administration' and 'Opinion'

Timewarp: What Is a Relational Database?

KKline — Wed, 05 Sep 2012 19:23:00 GMT

Relational?!? Move On, Geezer!

Maybe you're thinking that relational databases management systems (RDBMSs), like Microsoft SQL Server and Oracle, are going the way of punched cards and rotary phones. After all, there's been a lot of hype these days in the IT media about the rise of so-called NoSQL (Not Only SQL) databases. Many new and upcoming CS and MIS graduates who like working with data might think that relational databases are, at best, soon-to-be legacy systems and, at worst, are a career dead-end.

Wrong!!!

It's true that all the cool-cat computing services (Amazon, Facebook, Google, Pinterest, etc) are indeed making heavy use of NoSQL technology. They're also making heavy use of traditional RDBMS'es too. In fact, some of the world's biggest users of SQL databases are hand-in-hand the biggest users of NoSQL databases. The reason for that is that both types of data platforms are exceeding good at specific types of data storage and data processing. They also have their own unique weaknesses too. Meaning, each platform has a sweet spot and a weak spot, and that none are a 100% panacea for all imaginable data processing scenarios. Take a look at this article by my friend and former colleague, Guy Harrison - 10 Things You Should Know About NoSQL Databases, for a good discussion on the pros and cons of NoSQL in comparison to SQL data platforms.

Timewarp! Let's Take a Look Back at Why Relational Databases Were Needed.

These days, relational database management systems (RDBMSs) like Microsoft SQL Server and Oracle are the primary engines of information systems everywhere, particularly for enterprise computing systems and web applications. Though RDBMSs are now common enough to trip over, it wasn’t always that way. Not too long ago, you would probably trip over hierarchical database systems, or network database systems, or flat-file systems (heck, that still happens in many government IT shops who still use COBOL). A quick-and-dirty definition for a relation database might be: a system whose users view data as a collection of tables related to each other through common data values.

Perhaps you are interested in more than a quick-and-dirty definition for the term relational database? Here goes. The whole basis for the relational model follows this train of thought: data is stored in tables, which are composed of rows and columns. Tables of independent data can be linked, or related, to one another if they each have columns of data that represent the same data value, called keys. This concept is so common as to seem trivial; however, it was not so long ago that achieving and programming a system capable of sustaining the relational model was considered a longshot with limited usefulness.

Relational data theory was first proposed by E.F. Codd in his 1970 paper to the ACM entitled “A Relational Model of Data for Large Shared Data Banks”. Soon after, Codd clarified his position in the 1974 paper to the Texas Conference on Computing Systems entitled “The Relational Approach to Data Base Management: An Overview”. It was in this paper that Codd proposed the now legendary 12 Principles of Relational Databases.

If a vendor’s database product didn’t meet Codd’s 12 item litmus tests, then it was not a member of the club. Note that the rules do not apply to applications development. Instead, these rules determine whether the database engine itself can be considered truly “relational”. These rules were constructed to support a data model that would ensure the ACID properties of transactions and also eliminate a variety of data manipulation anomalies that frequently occurred on non-relation database platforms (and still do occur on non-relational database platforms). (As an aside, the transactional paradigm was conceived by my hero, Gray, Jim in 1981 while at Tandem Computer and presented in the paper "The Transaction Concept: Virtues and Limitations").

Codd’s 12 Rules for a Truly Relational Database System

Are you curious about Codd’s 12 Principles of Relational Databases? Don’t be ashamed that you don’t know them by heart; few technology professionals do, and no one on the marketing staff of technology companies do. However, the few folks who do know these principles by heart treat them like religious doctrine, and would likely be mortified by their “lightweight” treatment here. Nevertheless, I'll give them to you in my own paraphrasing:

Information is represented logically in tables.
Data must be logically accessible by table, primary key, and column.
Null values must be uniformly treated as “missing information” not as empty strings, blanks, or zeros.
Metadata (data about the database) must be stored in the database just as regular data is.
A single language must be able to define data, views, integrity constraints, authorization, transactions, and data manipulation.
Views must show the updates of their base tables and vice versa.
A single operation must be able to retrieve, insert, update, or delete data.
Batch and end-user operations are logically separate from physical storage and access methods.
Batch and end-user operations can change the database schema without having to recreate it or applications built upon it.
Integrity constraints must be available and stored in the metadata, not in an application program.
The data manipulation language of the relational system should not care where or how the physical data is distributed and should not require alteration if the physical data is centralized or distributed.
Any row-processing done in the system must obey the same integrity rules and constraints that set-processing operations do.

If you know much about SQL, then you probably recognize immediately that SQL ended up fulfilling rules #5, #7, #11 and possibly more. Others of the rule are manifest in the system tables of a relational database, such as DMVs in Microsoft SQL Server and V$ and X$ views in Oracle.

Relational Rises

There is some debate about why relational database systems won out over hierarchical and network database systems back in the late 1980's and early 1990's, but a couple of reasons seem self-evident. First, the high-level language interface (SQL) is much simpler to learn and more intuitive than that mishmash of languages supporting non-relational databases. (In fact, the lack of something like SQL is a hindrance to adoption of many NoSQL database platforms). Second, relational databases provide efficient and intuitive data structures that easily accommodate ad-hoc queries and reporting. People just intuitively understand the value of storing data in tables. From phone books to hotel registries, relational databases (of the paper sort) are second nature to most people. Third, relational databases provide powerful integrity controls such as check constraints and referential integrity - thus providing higher quality data. And high quality data is near and dear to the heart of CFOs around the world.

In fact, the strength that relational databases demonstrate with data quality, consistency, and durability are the same reasons that they'll be with us - quite possibly - forever. So were NoSQL databases excel at storing data that is moderately important and requires eventual consistency, SQL database excel at storing data that is of paramount importance and requires immediate consistency. As long as we're exchanging money, there's a need for relational database technology and ACID transactions.

And, just my opinion here, but database administration is currently, and will continue for decades to be, an excellent career choice. Why? First, although databases are widespread, good databases are not. So there's always need for those who can tune, troubleshoot, and optimize what is currently in the marketplace. Second, just because database are widespread doesn't mean that they're everywhere they need to be. Some estimates gauge that only half of the enterprises that need SQL databases actually use SQL databases. Imagine if only half of the citizenry wore shoes, and of the half that wore shoes, only half of them wore both shoes and consistently tied them. It'd be a good time to be a maker of loafers! Well, that's where we're at today with relational databases.

So what do you think? Am I off the mark on the longevity of relational database? Do you think the sun has set on them? Will they be smashed, degraded, and humiliated by NoSQL database platforms? Or will they stand shoulder-to-shoulder with a variety of data platforms in the years to come?

SQL People Interview

KKline — Thu, 28 Apr 2011 13:35:00 GMT

Many thanks to Microsoft SQL Server MVP Andy Leonard (blog | twitter) for conducting a series of interviews of prominent SQL Server types, including me. The interview found here.

~~~

Enjoy!

-Kev

Twitter at kekline

More content at http://KevinEKline.com

How Do You SKU?

KKline — Wed, 30 Mar 2011 14:49:00 GMT

I’d like your opinion here.

Follow my logic here for a moment as I walk through a couple rhetorical questions. Have you ever had a friend developed an application entirely on SQL Server Developer Edition? (Not that YOU would ever do such a thing, but maybe you know someone who has. Right?) And has your friend’s IT department actually deployed said application only to discover that they’re only licensed for Standard Edition in their production environment? And then was your friend’s IT management team is horrified to learn that they’ve either got to go through the very expensive process of extracting all of the Enterprise and/or Datacenter Edition features for the production application in order to remain in compliance, upgrade to the more expensive SKU licenses, or risk a potential future audit?

I’m not saying that this has happened to any of us. We’re too smart for that, after all. But have you ever known anyone who’s had this experience?

Having worked with a lot of customers another commercial RDBMS platforms (which I’ll euphemistically call “SEER” from Redforest City and “IB4” from Upstate City), I can tell you that auditing is a fun and exciting way for those platform vendors to make a LOT of money. This is especially true because a production application, once successfully deployed, tends to be too valuable to disable or otherwise compromise because high-end features slipped in to the development cycle even though the production environment only a “standard edition” SKU in place. Ouch! Talk about being caught between a rock and a hard place. Now, keep in mind that this is a strategy used by SEER and not by Microsoft. But Microsoft could implement the same sort of licensing audits if they wanted to. (Please leave a comment here if you have ever been audited. I’d love to hear your experiences, at least as much as NDA’s allow).

So if you use SQL Server Developer Edition (DE), of any version, would you like to see a feature that enables you to run DE not in its default “full featured mode” but at another SKU level, such as good ol’ Standard Edition? I know I would.

If you’re on the same page as I am, there are a number of suggestions logged on Connect about this very feature! Make your voice heard! Check out:

https://connect.microsoft.com/SQLServer/feedback/details/496380/enable-sql-developer-edition-to-target-specific-sql-version

Of course, the more skeptical reader might say “Hey, that’s their tough luck. Developers should know the difference in the SKU licensing options and feature sets of whatever SKU they’re developing on compared to what they’ll deploy on.” And I wouldn’t fault you for saying so.

But I would go on to point out that much of Microsoft’s success in enterprise IT settings can be traced back to their very strong relationship with developers. And anything that Microsoft can do to empower developers to save time, money, and resources during the development phase of an IT project in turn energizes that relationship between developer and Microsoft.

It also makes the life of the DBA that much easier, because they don’t need to imply that those cowboys on the development team went off half-cocked again. So what’s your opinion? Should SQL Server Developer Edition include a feature that sets the SKU-level of the database engine?

Reminder: Totally Awesome and Totally Free Training SQL Server Training

KKline — Mon, 21 Feb 2011 13:45:00 GMT

One of the things that I enjoy about working for Quest Software is that we give back copiously to the community. From activities and offerings like SQLServerPedia, to our free posters mailed anywhere in North America (and don't forget the free hi-res PDFs for the rest of the world),

Don't forget that free DVDs of our virtual conferences featuring me, along with Buck Woody (blog | twitter) and Brent Ozar (blog | twitter) will be mailed anywhere in North America free of charge, now available at this link.

Enjoy!

-Kevin

Twitter at kekline

More content at http://KevinEKline.com

Cloud Evolving, SQL Server Responding

KKline — Wed, 02 Feb 2011 14:49:00 GMT

Brent Ozar (blog | twitter) and I did an interview with TechTarget’s Brendan Cournoyer at last summer's Tech-Ed, which as turned into a podcast titled “Cloud efforts advance, SQL Server evolves.” The podcast covers all the major trends at the conference (like BI), virtualization features in Quest’s products (like Spotlight), Brent’s new book and MCM certification, and more. Here’s a link to hear it, appearing on 6/11/10: http://searchsqlserver.techtarget.com/podcast/Cloud-efforts-advance-SQL-Server-evolves.

Enjoy!

-Kev

Twitter at kekline

More content at http://KevinEKline.com

My Last "Catch-Up" Post for 2010 Content

KKline — Fri, 31 Dec 2010 20:57:00 GMT

I did a lot of writing in 2010. Unfortunately, I didn't do a good job of keeping all of that writing equally distributed throughout all of the channels where I'm active.

So here are a few more posts from my blog, put on-line during the months of November and December 2010, that I didn't get posted here on SQLBlog.com:

1. It's Time to Upgrade!

So many of my customers and many of you, dear readers, are still on SQL Server 2005. Join Kevin Kline, SQL Server MVP and SQL Server Technology Strategist for Quest Software and Brent Ozar, SQL Server Domain Expert for Quest Software as they introduce the top ten features and capabilities in SQL Server 2008 that they find to be the most exciting and valuable.

2. Dealing with the Micromanaging Boss

This is probably my favorite professional development article of the year. Micromanagers make us feel untrusted and stymied by their constant need for tediously detailed and frequent updates, constant changes to minor details of our work, and overly developed attention to administrative details that really don’t matter in our daily job. But there’s hope! Get all of my career advice on dealing with micromanaging bosses here.

3. [Video] Troubleshooting Memory Pressure on SQL Server

This is a little bit of an older video. But it's still useful info if you're working with SQL Server 2005 or 2000. Check it out here.

4. [DBTA] What the Heck is Microsoft's Database Product Trajectory?

I was once asked what I thought Microsoft's overall product trajectory for SQL Server was, in light of Oracle's rather obvious trajectory of acquiring multiple application vendors who will, in turn, deploy more and more of their applications to the Oracle database platform. You can read all about my thoughts in my monthly column at Database Trends & Application magazine - [READ MORE]

5. Eight Characteristics of Excellent Leaders [Plays Well With Others]

In this installment of my professional development column called Plays Well With Others, I talk about what distinguishes truly great leaders. There's a lively discussion on the topic and I encourage you to take part. Read it here.

6. The Shape of Database Licensing Costs to Come [DBTA]

One fall semester many years ago, I was a university freshman. Actually, I was anything but "fresh." I was dumb enough to think that 8 a.m. was a wonderful time to attend Economics 101. After staying up until the wee hours most every night, the "dismal science" took on more than one meaning as I set my clock just early enough to get to class on time. Along with 30 other very naïve classmates, I staggered into class and did my bleary-eyed best to focus on the lessons at hand. There were lots of Greek compound words and lots of graphs.

I learned, for example, that the word economics derives from the Greek "oikonomikos," which means, approximately, "death by slidedecks" and, specifically, "house" (oikos) and "management" (mikos). I barely survived the experience and never took an 8 a.m. class again. Imagine my surprise, then, when a lesson I'd learned (and promptly forgotten) all those years ago jumped back into my consciousness late last year. - [READ MORE]

7. So You're the Boss Now... [Plays Well with Others]

If you have any ambition at all, you have probably wanted (and possibly gotten) a promotion over your current colleagues. If you've been there before, you know that once friendly relationships can get, well, weird. Read my tips and tricks for how to make the most of this situation in this professional development article.

8. The NoSQL Movement - Hype or Hope?

NoSQL is no fad. And you need to be in the "know", not necessarily in the "No". Gno? Pneu? Too many phonetically similar pronunciations! Read my thoughts on the NoSQL movement on one of Database Trends & Applications magazine's most popular articles of the year. - [READ MORE]

9. Effectiveness and Efficiency at Work [Video]

In this golden oldie (yes, two years constitutes "old"), I present my thoughts on how to be both effective and efficient on the job and in life in general. And if you didn't know that these are different concepts, then you need this video most muchly.

10. What's Your Data Management and Retention Policy? [DBTA]

If managing your corporate data for the long term isn't currently on your mind, it should be, and in several different ways: cost, performance, business continuity, and compliance. [READ MORE]

Follow me on Twitter!

Originally Posted on YoutTube November 12, 2008.

2009: The Year in List Form

KKline — Tue, 05 Jan 2010 18:53:00 GMT

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:

Best of the [SQL Server] Blogs and its sister post Great Blogs from the Microsoft SQL Server Teams, also my number one spam generators. Ever spammer on the planet seems to want their comment appended here.
Microsoft Resources Too Good Not to Share, which I can't honestly remember if they were any good or not. But I bet they were.
Are We There Yet, Mom? in which I flashback to my childhood road trip experiences when considering Microsoft's overall product strategy.
Does the Down Economy Have an Impact on Your Job, cuz it sure punched mine in the mouth.
Why Do I Keep Seeing This Mistake, in which I learn that "Hello World" type applications can lead to massive misunderstandings.
Microsoft [Corporate] Marketing Throws SQL Server Under the Bus. We can't get no respect, not even from corporate HQ.
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.
Old Performance Recommendations Die Hard, and when I saw "die hard" I don't mean like Bruce Willis.
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.
Understanding SQLIOSim Output, because no one seems to fully understand this tool, including me.

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]

Be well!

-Kevin

Twitter @KEKline

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 <!--[if gte mso 10]> http://sqlblog.com/blogs/kevin_kline/archive/2007/06/28/understanding-sqliosim-output.aspx

Interview Now Appearing on CSTech.com

KKline — Sat, 02 Jan 2010 21:48:00 GMT

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

Twitter @kekline

More content at http://KevinEKline.com

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!

Sequels for SQL: Dec 17, 2009

KKline — Thu, 17 Dec 2009 17:46:00 GMT

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, of 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.)

Thanks!

-Kevin

Twitter @KEKline

More content at http://KevinEKline.com

Anniversary at Database Trends & Applications Magazine

KKline — Thu, 19 Nov 2009 00:32:00 GMT

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.

Security as an Afterthought Issue: November 2009

The Big Keep Getting Bigger Issue: October 2009

Getting Up to Speed on the SQL Server Social Media Scene Issue: September 2009

The Ebb and Flow of SQL Server Instrumentation Issue: August 2009

A Look at Upcoming Enhancements in SQL Server 2008 R2 Issue: July 2009

Is it Time for a Professional Code of Ethics for DBAs? Issue: June 2009

The Trouble with Third-Party Applications Issue: May 2009

SQL Server in the Clouds? Issue: April 2009

The Future of Coding for SQL Server, Part 2 Issue: March 2009

The Future of Coding for SQL Server Issue: February 2009

Reaching for Highly Scalable Systems with SQL Server 2008 Issue: January 2009

Long-Term Changes Resulting from Policy-Based Management Issue: December 2008

The New Master's Certification from Microsoft Issue: October 2008

What to Expect at the PASS 2008 Summit Issue: September 2008

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.

Thanks,

-Kev

Twitter @KEKline