Tag Archive: blogging

My Weekly Bookmarks for September 17th

Posting this one a little early since I’ll be doing presentations all day tomorrow for a Quest Day with the Experts in Boston, MA.  You can watch online too.

SQL Server & Tech Links

The Junk Drawer

  • Blur Tripod – iPhone tripod adapter and an app that has a built-in delay after you click to take a photo – that way the phone stops moving and the photo will be crisp.
  • Professional Development: Internet Image – When someone tells you that you should have a nice, clean, sanitized blog that’s free of any personal details, send them this blog by Jason Massie. I’m right there with him – I would rather see someone’s personality. People are likable – Books Online is not.
  • Trackin’ Away – Ping.fm now lets you track statistics on your broadcasted links. Yet another reason to use the PingPressFM plugin for WordPress.
  • Training Benefits – When you stop training, your career comes to a grinding halt.
  • Your Own Personal Development Plan – End-of-year reviews are coming up – time to start working on your Personal Development Plan.
  • Recording a webcast for Quest Connect 2009 – Colin Stasiuk talks about the upcoming free QuestConnect webcast.
  • Your company? There’s an app for that. – Many companies are going to be competing with dirt-cheap iPhone applications sooner or later.

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

My Weekly Bookmarks for September 4th

Here’s my bookmarked links for September 1st through September 4th:

Tech Links

The Junk Drawer

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

My Weekly Bookmarks for August 28th

Here’s my bookmarked links for August 23rd through August 28th.  I’m using an automatic plugin to build this list, and I can see that this probably isn’t going to work – I just found way too many things interesting in one week, and it doesn’t break stuff out into categories.  Blogger fail.  Here it is anyway as an example of What Not To Do during my Better Blog Week:

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Blog Better Week: Strunk & White’s Elements of Style

This week I’m focusing on how you can improve your blog. So far I’ve talked about why you should schedule blog posts, how to write a product review, how to spice up your blog with pictures, and how to get people to find you online, and today I’m wrapping things up with a book recommendation.  My next series in a couple of weeks will focus on social networking basics.

Everything I know about style, I learned from two dead white guys.

Watching Project Runway is Not Enough

Watching Project Runway is Not Enough

Strunk and White’s classic book The Elements of Style crams a lot into less than 100 pages, and it’s less than $15.  It covers basic rules of grammar, explains frequently misused words, and inspires readers to become better writers.

My first reaction upon reading the Approach to Style section was a revolt.  I don’t want my blog to read like a faceless newspaper article or an encyclopedia entry.  However, the more I dug into the book, the more I realized that it encouraged the reader to follow some simple guidelines in their efforts to build their own unique voice.  When the book’s authors put similar passageways from Faulkner and Hemingway side-by-side to show how two writers convey the same concept, it just plain works.

It’s chock full of examples from famous books I know I should have read a long time ago.  Reading each snippet reinforces the notion that writing really is an art, and that every time we publish a blog entry, Strunk and White each turn another revolution in their graves.

The hilarious presenter and blogger Jimmy May (BlogTwitter) first prompted me to buy this book, and I owe him a debt of gratitude.  I’d also like to thank Mrs. Weathersby, my senior year English teacher, and point out that I learned a valuable lesson in her class.  Although she was horrified to discover that I’d written John Szegda’s term paper for him, I did indeed learn that writing pays off.

I highly recommend The Elements of Style to any blogger who wants to improve their craft, and you can buy it from Amazon.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

W3 Total Cache Plugin Review

Databases are slow.

I shouldn’t say that, because I’m a DBA, but it’s the sad truth – databases are often the bottleneck for web apps.  WordPress is just another web app – it builds pages by querying a MySQL database.  If we want WordPress to scale, we need to minimize the number of times it has to hit the database.  Reducing the number of plugins helps, but sometimes it’s still not enough.

I used to use the excellent WP-Super-Cache plugin to cache my blog pages.  It’s a filesystem-based cache that saves generated versions of your pages.  It works great, but you have to be very careful that all of your other plugins work well with it.  For example, I tried using a Google AdSense plugin that checked where you were coming from, and if you’d stumbled in via Google, it showed Google ads related to your search query.  Unfortunately, once that page got into cache, EVERYBODY saw the ads – whether they’d come from Google or not.  Bad.  I had to check every plugin I used and determine whether it was impacting my caching, and I ended up pulling a lot of good plugins out just so I could scale to more viewers.

W3 Total Cache has a whole different bag of tricks.  It uses memcached, a memory-based cache, and as a result it appears to be much faster than WP-Super-Cache.  The downside is that memcached isn’t available on most shared hosting providers.  It’s not even usually installed on dedicated virtual servers, so you’ll need to follow a few instructions to get memcached up and running first.  MediaTemple users can follow their memcached setup instructions.  (This is yet another reason why I love MediaTemple – their documentation is stellar.)  Other hosting company users still get an excellent checklist in the W3 Total Cache Installation page built into the plugin.

Since it’s a memory-based cache, memcached also requires more memory than WP-Super-Cache.  MediaTemple recently rolled out free memory upgrades to their hosting customers (did I mention that I love MediaTemple?) so I had more than enough available memory to handle it.

Beyond Caching: Options for Content Delivery Networks

When your site hits the front page of Digg or Slashdot, you might want even more scalability.  Content Delivery Networks, or CDNs, host your static files (images, css, js) on their servers, thereby reducing yet more load on your web server.  CDN companies replicate content across their worldwide servers, thereby making your pages render faster for users on other continents.

This option is probably overkill for 99.9% of the blogs out there, but when you need it, you have no time to set it up.  If you’re writing the kinds of content that you hope will end up on Digg’s home page, then you need to set up a CDN (and caching, for that matter) long before you need it.  My web site got knocked offline in May when Sherri Shepherd, one of the hosts on The View, linked to it, and I had to scramble to set up better caching and a CDN.  My site only really gets hammered once or twice a month, and using a CDN helps me survive those without getting an expensive dedicated server just for my blog.

W3 Total Cache has some support for CDNs that are accessible via FTP.  It will automatically upload your static files to your CDN, and update your web page code to the CDN without you having to lift a finger.  Unfortunately, Amazon S3 and Amazon CloudFront aren’t directly accessible via FTP, so if I chose to go that route, I’d need to switch CDN’s.  For now, I’m using the TanTan Amazon S3 plugin which uploads my post images to S3 and hosts ‘em there.  It doesn’t utilize Amazon CloudFront, so it’s not as fast as a real CDN, and it also doesn’t handle any of the CSS/JS/include files that W3 Total Cache will.  I’d really love to see W3 Total Cache implement CloudFront capability.

W3 Total Cache Also Shrinks Your Pages

W3 Total Cache can use HTTP compression (like GZIP) to shrink your pages, but it goes beyond that.  It will minify your JavaScript and CSS code, stripping out comments, spaces, and other things that don’t affect how the code works.  These things reduce the time it takes to download your web pages.  Here’s what one of my bigger pages looked like before W3 Total Cache minified it:

Before Minify

Before Minify

After W3 Total Cache:

After Minify

After Minify

Hubba hubba – almost a 30% drop in size without affecting content.  (Yes, I know it’s hilariously ironic to illustrate smaller web pages by using big screenshots.  I like images on my blog.  Get over it.)

Minifying Your CSS and JS Files

Minifying Your CSS and JS Files

It’s not point-and-click setup, though – you have to tell W3 Total Cache where each of your CSS and JS files are located.  In the screenshot here, I’ve entered in the exact locations of all of my CSS and JS files.  To find them, I could have tracked them down via view-source, but the easier way is to use a site like the Web Page Analyzer.  It points out all of the CSS and JS files that aren’t compressed and gives you the exact location.  You can copy/paste those into W3 Total Cache’s configuration, and it automagically handles ‘em.  It appears to be transparent to your plugins.

The downside of this manual setup is that you have to revisit it every time you change your theme or add a plugin.  W3 Total Cache doesn’t recognize that you’ve added CSS or JS files to your site.  I’ll have to set myself a reminder to use a web page analyzer once a month and make sure everything’s still working as designed.

Initially, you have to double-check your particular blog.  My CSS and JS files minified okay, but tag cloud broke when my HTML was minified:

W3 Total Cache Minify Bug

W3 Total Cache Minify Bug

It ripped out the spaces between tags, thereby rendering my cloud as long lines.  That one was easy to troubleshoot, but to fix it, I had to disable minification on my HTML, which cost me a little performance.  Other issues are not as easy to troubleshoot – I pity the fool who tries to view-source a minified web page, because it’s crammed together on a single line.  Well, not quite one line.

W3 Total Cache Adds a Footnote To Your Source Code

The plugin credits itself one of two ways.  By default, it tacks on a link at the end of your blog page.  If you uncheck that option in the Preferences page, W3 Total Cache instead adds a footnote inside your source code for anyone to see if they view your source.  Even when you choose to minify your pages, W3 Total Cache won’t minimize its own absurdly long footnote:

“This site’s performance optimized by W3 Total Cache:

W3 Total Cache improves the user experience of your blog by caching
frequent operations, reducing the weight of various files and providing
transparent content delivery network integration. The goal is to improve the
user experience for the readers of your blog without having to change
WordPress, your theme, your plugins or how you produce your content. When fully
utilized, your blog will be able to sustain extremely high traffic spikes
without requiring hardware upgrades or removing features or functionality from
your theme.

Features and benefits include:

– Improved progressive render (non-blocking CSS and JS embedding)
- Reduced HTTP Transactions, DNS lookups, reduced document load time
- Transparent content delivery network (CDN) support with automated media
library import
- Bandwidth savings via Minify and HTTP compression (gzip / deflate) for HTML, CSS
and JS
- Minification (concatenation, white space removal) of inline, external or 3rd
party JS and CSS with scheduled updates
- Optional embedding of JS just above </body>
- Support for caching pages, posts, feeds, database objects, CSS, JS in memory
with APC or memcached or both
- Caching of RSS/Atom Feeds (comments, page and site), URIs with query string
variables (like search result pages), Database queries, Pages, Posts, CSS and JS
- Complete header management including Etags
- Increased web server concurrency and reduced resource consumption, increased scale

Learn more about our WordPress Plugins: http://www.w3-edge.com/wordpress-plugins/

That content is tacked onto every single page, thereby adding more length to your site. Ugh – that’s the opposite of what I wanted.  I would have no problem with adding 2-3 lines summing up the benefits, but this is absurdly overboard.

There’s no option to switch it off in the preferences, either, but I figured out a sneaky trick.  In the preferences, you have the option to add their link either to the footer of your web site or to your blogroll.  Since I don’t use WordPress’s built-in blogroll feature, I used that, and voila – W3 Total Cache stopped adding that ridiculous footer.  Note to the author: either accept donations, or compromise on a fair length of credits in the source code.

W3 Total Cache Preferences

W3 Total Cache Preferences

But, ah, those preferences…

The Good News: Lots of Options. The Bad News: Lots of Options.

Bug Example: Missing Comments

Bug Example: Missing Comments

This plugin’s options and documentation set a high bar for other plugins.  I’ve never seen so much tweaking potential in a WordPress plugin.  It approaches the level of usability in the very tweakable Atuahualpa theme that I use here on my blog.  If a particular feature doesn’t work, like the HTML minify problems I had, you don’t have to throw the baby out with the bathwater – just uncheck that particular part of one feature.

All these preferences and dependencies, though, is an indicator of the targeted audience.  If you’re just getting started with caching, you can’t go wrong with WP Super Cache.  It’s easy to install, easy to configure, and hard to screw up.  If you’re willing to put more time and effort into installing, configuring and testing your caching solution, then W3 Total Cache gives you more choices and flexibility.

W3 Total Cache is still in its infancy, but already it shows great potential.  I’ve run across bugs – sometimes comments don’t show up right away, even though the correct number of comments shows in the post description.  For example, the post will say “3 comments”, but only 2 will display.  I’m going to keep checking it out as new revisions come out, and I hope they implement S3/CloudFront CDN caching in the near future.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Blog Better Week: How to Write a Product Review

This week I’m focusing on how you can improve your blog.  So far I’ve discussed how to build your momentum by scheduling posts ahead of time, the basics of search engine optimization, and how to spice things up with pictures.  Tomorrow’s post will finish up the series with a book recommendation for bloggers of all skill levels.

Bloggers – product reviews are timeless content that will attract more readers, especially readers you’ve never had before. People search the web for product reviews, and if they like the quality of your review, they might stick around and read more articles.

Reviews for enterprise-quality products, like SQL Server tools, are really hard to find.  Some magazines task their writers with banging out quick reviews, but the writers may not have your level of IT experience.  They might look at features, get all excited, and not understand how the features would work in real life.

Two Burned Thumbs Up!

Two Burned Thumbs Up!

Here’s a few tips on how to write a useful review:

Spend at least a month with the product, using it on a daily basis. If you find that the product solves a need, and that you get excited to use the product instead of doing things “the old way”, mention that in your review.  On the other hand, if you have to remind yourself that this product is installed, and if you find yourself cringing when you open it, then that needs to be reflected in your review.

Talk to somebody who’s used it for longer than a month. Ask the vendor for a few contact names of customers.  Granted, these customers have been hand-picked by the vendor because they love the product, but you can still get useful information from them.  Ask the user why they picked the product, how much they paid for it, and whether they’d buy it again.  Ask for at least one thing they don’t like about the product or the company.

Call for support. Even if you’re not having a problem, make one up.  My personal favorite: “Hi, I’m trying to run this on <insert really new or really old OS here>, and whenever I double-click on the desktop icon, nothing happens.”  See how the support experience goes.  If you’re connected directly with the person who wrote the code, that’s a good thing and a bad thing – it means they probably don’t have any customers.  If you’re connected directly with someone who doesn’t even understand the product, that’s just a bad thing.

Make a list of the product’s competitors and ask why they’re different. Don’t just ask the vendor whose product you’re reviewing, either, because those bozos all say the same thing: “Nobody competes with us!  We’re unique!”  Yeah, and so are snowflakes, but there’s a bunch of those too.  Tell your friends about the product, and odds are they’ll know a competitor.  Call or email the competing vendor and ask, “Hey, I’m evaluating Product X – why should I choose your product instead of Product X?”  They’ll be more than happy to tell you all the ways Product X bites the big one.

Introducing - The Pinto Four Wheel Drive

Introducing the Pinto Four Wheel Drive!

Don’t write the review until you can list at least three things you don’t like about the product. If you can’t find those three things, you haven’t used the product long enough.  For example, I’m drinking the Apple Kool-Aid, but even I can tell you three things I don’t like about a piece of Apple hardware within the first month of using it.  (My iPhone: the battery life sucks, it doesn’t fit in docks when it’s got a case on, and the browser keeps reloading pages whenever I switch windows.)

Send your review to the company before you post it. This isn’t an attempt to blackmail the company – rather, you’re asking them if there’s any inaccuracies.  You might have misunderstood how the product worked, or maybe you got some details wrong.  Ask the company’s marketing department to double-check your work before it goes live.

DON’T write too many sponsored reviews. Companies like PayPerPost, ReviewMe and SponsoredReviews offer bloggers $5-$500 per blog post depending on the blog’s popularity and the number of words & links in the review.  Done right, it comes off as somewhat funny and doesn’t offend too many people, as this example post shows.  (It still left me with a slimy feeling, but it’s still the best-written one I’ve seen.)  Done wrong, it exudes spamminess, and readers will unsubscribe from your blog after just a couple of those posts.  I’ve personally avoided these because I’m not in blogging to make money, as I discussed in my series on How to Start a Blog.

Amazon Earnings Report Snippet

Amazon Earnings Report Snippet

DO include an affiliate link to buy the product. Don’t be ashamed to make a little money off your work.  If you’re going to do a book review, sign up for the Amazon Affiliate program and generate an affiliate link for the book.  Use that link in your review article.  When someone clicks on your Amazon link to order the book, you get a 4% cut of the revenue.  Here’s the hilarious part: no matter what they buy, you get a cut, as evidenced in this screenshot of my Amazon earnings report.  If you’re reviewing something that’s not sold by Amazon, consider signing up for Commission Junction, which offers similar programs for other vendors like Newegg. I don’t make much off these programs – around $100/month – but it’s a nice perk.

Include product pictures, and link them to buy the item. People love clicking on pictures, even if they’re not scantily clad models.  Take advantage of that psychological impulse and use your aforementioned affiliate link so that when they click on the picture they go straight to the store to buy the item.  (If this kind of tip gets you all excited, check out Problogger’s series on how they made over $100k with the Amazon Associates program.)

If a company approaches you directly about writing a review, it’s not uncommon to ask for compensation in the form of their products.  For example, if a software company asks you to review their Widgetizer Pro, they’ll include a few free licenses too.  Consider using one for yourself and giving a couple away to your readers – maybe via a contest, choosing a random commenter on that blog post.  However, don’t be suckered into putting dozens of hours of your own time into researching the product, testing it, and writing the review, all in exchange for $250 of licensing.  Put a dollar amount on your time, estimate what it’ll take to do a fair job on the review, and ask the company to either compensate you as a consultant or ask for more freebies in exchange for the review.  If you don’t, then you probably won’t put the full amount of time into the review, and your readers will be able to tell you’re doing a puff piece.  Rule of thumb: if your knowledge of the product consists of reading the brochure, you’re not doing justice to your readers.

If you accept compensation, disclose that in the review. Just mention in the review that the gear was provided to you by Company X in exchange for the review.  If you were paid to write the review, things get more complicated – the FTC is considering holding bloggers liable for their sponsored reviews.

Finally, think twice before you body-slam a product. If a product just doesn’t float your boat, consider returning it to the company and not posting anything on your blog.  Maybe you weren’t the target audience after all, or maybe the product could get better in a version or two.  Send your feedback to the company so they can help improve their work.  If you roast a company’s product in your review, other companies will think twice before sending you a product for review.

This happens to me too – authors have sent me several books for review, but I didn’t end up posting the reviews on my blog.  I’ve forwarded my thoughts over, explained why I wasn’t such a big fan, but wished them the best of luck in their work.  No sense in burning bridges – you only have one online reputation.  Guard it carefully.

At the same time, if the product does something really boneheaded, like putting your production servers in danger, then you should probably identify that product before somebody makes a dumb investment.  After all, a lot of people bought Pintos….

Want Some Sample Reviews?

Here’s a few of the reviews I’ve done in the past:

Next Up: A Small Book That Makes a Big Difference In Your Blog Skills

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Blog Better Week: Spice Things Up with Images

This week I’m focusing on how you can improve your blog. So far I’ve talked about why you should schedule blog posts and the basics of search engine optimization.  Tomorrow’s post will cover how to write a product review on your blog.

Your writing is boring.

Bored Blog Reader

Your Blog Readers

I’ve read your blog.  I know you’re struggling to be funny, and I appreciate that.  I struggle with it too.  We can’t all come up with ways to weave detective stories into our SQL Server blog posts.

Cheat: add pictures to distract us from your writing.

Your writing can be dead serious and technically complex, but you can still liven things up with a romance novel cover, a drag queen, or a guy making fun of himself.  There’s just two simple rules you have to follow when adding images to your blog.

Rule #1: Don’t Steal Pictures

I hate plagiarism.  I hate it when people pass off my writing as their own, and I know my photographer friends feel the same way about their creative work.

Fortunately, some photographers don’t mind sharing their work as long as it’s properly attributed and linked.  There’s plenty of places to get free images for your blog, and my favorite is Flickr’s advanced search.  Put in your search terms, and then scroll to the bottom of the page and check the box that says “Only search within Creative Commons-licensed content.”  These are images that you can reuse as long as you link back properly to the original image.  (When I’m doing presentations with Creative Commons images, I put the link on the bottom of the slide.)

When you have trouble finding good pictures, turn your search around.  Instead of searching for technical terms related to your article’s topic, search for words that describe the emotion you’re trying to convey, like funny, confusing, challenge, broken, etc.  Sort by “Interesting”, and Flickr will show you the images people love the most.  I’m always surprised by how many great photos I find this way, and how well they work in the blog entry even though they didn’t initially appear to have anything in common with my point.

Side note – I tend to reuse funny images when I find real gems, so I mark them as favorites in Flickr.  If you ever wonder what my next presentation will include, check out what photos I’ve bookmarked recently, and that’ll give you a peek into my brain.

Before you edit the file (change the orientation, crop it, add a funny lolcats-style caption) double-check the usage rights.  It’s on the right side of the photo page on Flickr where it says “Some Rights Reserved.”  Some photos allow Remix use, whereas some don’t allow modifications.

Rule #2: Don’t Steal Bandwidth

When you find a picture you want to use, right-click on it and save it to your computer.  Upload it to your blog, and make the photo be a hyperlink back to the original web page, not the image.  The web page has information about the author and links to their other photos.

Don’t just put an IMG SRC tag that point directly to the other person’s web server.  This uses too much of their bandwidth at no gain to them.  Savvy webmasters will figure out what you’re doing and take action.

Next Up: How to Write a Product Review On Your Blog

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Blog Better Week: The Basics of SEO

This week I’m focusing on how you can improve your blog. Yesterday I kicked things off with why you should schedule blog posts.  Tomorrow I’ll break some bad news to you – your blog is boring.

I blog to help other people.

I’m only successful if they can find me.

Avoid the hot dogs.

No, not every player is a winner.

Picture yourself walking through a carnival jam-packed with crazy idiots, insightful geniuses, and half-clothed hotties all vying for your attention.  They’re all screaming at the tops of their lungs, enticing you into their carnival tent to see their freak show.  Some are free, some cost money, and all are desperate to get you inside.  When you finally pick a tent and go in, you find that even inside the tent, while you’re trying to focus on what you went in for, there’s even more barkers inside trying to get you to go to another tent.

The Internet isn’t fair. The Internet IS a fair.

You might be crafting the smartest, most well-written blog out there, but you’re still out there, and you’re out there along with a gazillion other carnies.  Some of them are trying to make money off their booth, and they’re going to do whatever it takes – fair, slimy or otherwise – in order to get people in the door.

Your one weapon, the great equalizer, is the search engine.

Search engines want to hook their users up with the best content possible.  The better the search results, the more likely the readers are to come back to that same search engine again.  Search engines make money off ads, so they too are carnies hawking their wares.  They want to help you help them help their users. (Triple score! I just won a giant stuffed banana!)  Making your site easier for search engines is called Search Engine Optimization (SEO).

Step 1: Break your blog posts into sections.

This assumes that your posts are longer than a couple hundred words – and frankly, they need to be.  The less content you have, the less search engines have to work with.  Less isn’t more when it comes to blog posts.

For every couple/few paragraphs, throw in a header like you see here.  In WordPress, you should use Heading 3, because Headings 1 & 2 are already used for higher-level titles in your blog (like the blog title and post titles).  Use descriptive words in those headings, words that match the kinds of things people are searching for.  For examples, check out my entry last week about truncate_only, and look at what words I used.

At the same time, you have to walk the line between serving the search engines and serving readers.  If you just stuff your headings chock full o’ keywords, your blog won’t be enjoyable to read.  Make the headlines fun first, and SEO-friendly second.

Step 2: Specify summaries and keywords for your posts.

If you go to a search engine and search for SQLIO, here’s what shows up:

SQLIO Search Results

SQLIO Search Results

See the one-sentence explanations below each page title?  Read through those more closely.  Which ones look the most inviting to the readers?

In the battle for visitors, this is like your opening shot.  You only get a tiny amount of screen real estate, and every pixel counts.  Instead of making the search engine guess what your article is about or using a random sentence from your post, why not tell it exactly what to show?  You can!

If you’re using WordPress, install the All in One SEO Pack.  After installation, it’ll warn you that it must be configured.  Just go to the settings page and click the Enable radio button.  All done.  Then, when editing a blog post, you’ll have these fields at the bottom of the post:

All in One SEO Pack

All in One SEO Pack

Without the All in One SEO Pack plugin, WordPress tries to guess the post’s Title, Description and Keywords.  The plugin gives you fine-tuned control over exactly what your post is about.

I don’t set these fields on every blog post I write, because I don’t expect most of ‘em to have long-lasting search engine power.  The more work I put into a post, though, the more likely I am to put some effort into the SEO fields so that more folks can find my work.

Step 3: Publish a sitemap.xml file.

If you’re using WordPress, all you have to do is install the Google XML Sitemaps Generator plugin.  There’s not much to configure, but set yourself a reminder in your favorite task management software to check the settings once a month.  I’ve had some problems when my file permissions changed and the plugin was no longer able to write the sitemap file.  If that happens, the plugin shows instructions on how to fix it, but unless you go into the plugin’s configuration page, you’ll never know there’s a problem.  It doesn’t send an email or alert you other than showing an error on the config page.

If you’re using a different kind of blog, I got nothin’ for ya.  It’s up to you to figure out how it works.

After publishing a sitemap.xml file, sign up for Google Webmaster Tools.  It’s a completely free service that gives you valuable statistics and diagnostics about your blog, your readers and your search engine optimization.  Once a month, I log into Webmaster Tools to find out if Google’s had any problems indexing my blog.

These steps take a little work, but I’ve found that over time they make a big difference.  Of course, if you’re lazy, there’s a solution for that too.

Enter the Snake Oil: Search Engine Optimization

Wherever there’s carnivals, there’s snake oil vendors: people selling mythical potions that will cure all ailments.  In this case, the ailment is your low search engine ranking, and there’s a long list of vendors who’d love to give you a hand with that problem.

If you pay someone $500 to do search engine optimization for you and boost your search rankings, how do you know if they succeeded?  They’ll tell you that it may take days or weeks for the search engines to notice the changes.  They’ll tell you that your mileage may vary, and that all sales are final, no refunds allowed.  You might even be working on your blog yourself at the same time, and it’s impossible to tell how much improvement was due to their efforts versus yours.

Some SEO vendors do a fantastic job, but they’re priced outside the reach of most bloggers (including me).  If you’re dead set on spending money on search engine optimization, check out the book Landing Page Optimization by Tim Ash.  It explains how to build out sections of your site specifically for search engine visitors and how to get them to stick around.

I’d recommend my favorite SEO company to you here, but then I’d lose my competitive advantage.  After all, the other carnies are reading this too…

WordPress SEO Tutorial Video from Google

Matt Cutts (BlogTwitter) is a member of Google’s Webspam team.  He spoke at WordCamp San Francisco about how WordPress bloggers can make their web site more searchable.  It’s a 45-minute long video, so warm up that plate of bacon and get cozy.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Blog Better Week: Building Your Blogging Momentum

This week I’m focusing on how you can improve your blog.  Enjoy!  Tomorrow’s post will show you how to get people into your carnival booth – I mean, web site.

The question bloggers ask me over and over is, “How do you blog so often?”

The answer is simple: stop clicking Publish and start clicking Schedule.

Blog Nirvana - Plenty of Scheduled Posts

Blog Nirvana - Plenty of Scheduled Posts

Fail to Plan and You Plan to Fail

Blogging is no different than any other IT work; if you’re always doing things at the last possible moment, you’re going to do a crappy job.  If you start doing your work in advance before it’s due, then you’ll find yourself putting more and more polish into your work.  You’ll stop sweating bullets, stop stressing out over quality versus quantity, and stop approaching your blog with guilt.

I schedule my posts for publication on weekdays, often a week or more ahead of time.  I’ve gotten into the routine of scheduling posts on Mondays and Wednesdays, leaving myself Fridays for spontaneous stuff.  If I have an urgent flash of news that I just have to push out ASAP, I’ll write it up and then rotate out my next scheduled blog post to later in the line.  This post is a great example – I’m writing it on Monday, August 3rd for publication on Wednesday, August 19th, but if something comes up, I can reschedule this post later and later.  (Edit – sure enough, I pushed it back, and I had enough blog entries about blogging that I built a whole week of ‘em.) It’s a timeless post – not good for eternity, but at least it can be published at any time without losing its impact.

Plus, when I schedule a blog post ahead of time and sleep on it, often I’ll return to it the next day and remember something I should have added.  I can take my time to refine the post rather than hitting Publish and cringing.

Write When You Can, Not When You Gotta

Scheduling posts ahead of time gives you a sudden flexibility.  When you feel creative, write, and write until you don’t feel creative anymore.  Write as many blog posts in a row that you’ve got time for, and then quit.

My best blogging time seems to be Saturday mornings.  I’ll pile up a list of blog ideas in my favorite task management tool, RememberTheMilk.com, and on Saturday morning I’ll pull up the list to see what strikes my fancy.  If I find the words coming easily to my fingers, then I’ll blog until I get constipation of the word processor.  Usually I can bang out 3-4 entries at once, which buys me two weeks of time.

Next Saturday, if I’m not feelin’ the love, I won’t feel guilty – because I’ve already got enough articles to tide me over.  Voila: stress-free blogging.

How to Get Started Scheduling Blog Posts

Brace yourself: just go cold turkey.

The next time you write a blog post, schedule it to appear a week from now – minimum.  Yes, you’re going to feel guilty.  Yes, you’re going to think that your readers will be horrified at your lack of blogging, but no, none of your readers will actually notice.

What they WILL notice is your sudden increase of quality from that point forward.

Isn’t it worth 7 days of silence for a lifetime of better blogging?

Next Up: The Basics of WordPress SEO (Search Engine Optimization)

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

More Thoughts on Blog Plagiarism

In the aftermath of the InformationFlash plagiarism incident, several questions have come up from the site’s webmaster and from other bloggers.

Is it okay if the plagiarizer isn’t making money?

No.  Authors work really, really hard to create their original content.  Seeing someone else pass it off as their own, whether there’s a charge or not, reduces the value of our hard work.

If I took the whole content of The Manga Guide to Databases and reproduced it here on my blog, I wouldn’t be making a dime off it.  However, I’d be robbing the author of income.  Even if that author was giving away the work for free, the author might be benefitting in a way that I don’t understand yet, so I need to contact the author before republishing their copyrighted work.

Is it okay if I don’t understand my blog aggregation software?

No.  If you pick up a gun, it’s your responsibility to understand how it works. The first time it accidentally goes off and shoots somebody, you might be able to get away with claiming you didn’t know it was loaded.  After several people complain about gunshot injuries, though, you need to put the gun down.

Just as you can go to a local gun club to learn about firearm safety, you can get help with RSS aggregators too.  Post a message in the product’s support forum, contact other users of the product, or post a message on StackOverflow.  But whatever you do, don’t wave that thing around until you understand what you’re doing.

Shouldn’t the bloggers change their feeds to prevent theft?

Bloggers can choose whether to include the full article or just a few words in the RSS feed.  In my series on how to start a technical blog, I recommend using the full article because readers like it a lot more.  They don’t want to click through to read your full article on your site.  (Personally, I hate the holy hell out of blogs who just include the abstract, and their content has to be insanely good for me to subscribe to one of those kinds of blogs.)

Even if the blogger changes their feed to just include an abstract, it still doesn’t prevent syndication sites from stealing content with screen-scraping techniques.  Then the naysayers would say, “It’s the blogger’s fault for not requiring a username and password in order to read the blog.”

If we have another site pop up like InformationFlash, I’ll probably end up including a copyright note at the bottom of every blog entry.  It’ll say something like, “If you’re not reading this article at BrentOzar.com or SQLServerPedia.com, it was stolen.”  I hate doing that, though, because it looks crappy.  It’s like bolting the TV remote to the nightstand.

Is it okay if end users submit the copyrighted blogs?

No.  When the owner of copyrighted content notifies you that your site has their stuff on it, and they want it taken down, you have to take it down pronto.  YouTube is a good example because people try to upload copyrighted data all the time.  If the original content owner files a DMCA complaint at YouTube, then YouTube acts quickly to take the content down.

Just as a side note – if you try to claim some other user uploaded the copyrighted content, you need to be *very* prepared to show database records and web server access logs to prove the site administrator wasn’t the one uploading content.

How come it’s okay when Digg or DotNetKicks does it?

Because those sites don’t publish the full content of the article.  They show the first few words of the article, and if the reader is interested, they click through to the full content of the article on the blogger’s site.

InformationFlash was showing the entire article, start to finish, without even showing the author’s name.  That isn’t promoting the authors at all.  To make matters worse, InformationFlash had a Google PageRank of a whopping zero – meaning it wasn’t promoting anyone other than itself by stealing content.

Then is it okay if the site promotes the bloggers?

No. When you’re taking copyrighted content from bloggers, you have to get their permission first, period.

Some authors are completely okay with you republishing their work as long as you attribute them appropriately and link back to them.  For example, I’ve told SQL Server Magazine they’re free to use any material from my blog as long as they quote me.  (Part of this is a selfish reason: despite what Compete thinks, I’m pretty sure SQL Server Magazine has more readers than I do.)

Is it okay if it’s not illegal?

Even if you register your domain name anonymously and ignore all incoming emails, sooner or later people are going to figure out your real name.  They’re going to post your name in public along with an explanation of what happened.  That kind of information will turn up in Google searches, and it’ll make for very ugly job interviews and client negotiations down the road.

Besides, don’t you want to be successful?  Your site simply can’t become a success by alienating the very people upon whom your site depends for content.  You can be successful by working with the community and making sure everything is a win-win.  It’s not easy, and it’s not cheap, but it works in the long run.

Stealing is easy and cheap – but the long-term outlook is not so good.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube