Tag Archive: syndication

Gestalt IT: an IT magazine, syndication style

Last week, a new web-based enterprise IT magazine launched: GestaltIT.com, and the whole thing is based on blog syndication.

Gestalt IT consists of some of the best enterprise technology bloggers syndicating their content under one roof. These guys have been blogging separately on their own individual blog sites, and I’ve long subscribed to Stephen Foskett’s blog on storage. All of their topics relate to each other, and if you follow one of their blogs, you’d probably enjoy reading all of them.  That’s where the syndication magazine format comes in.

Each of these individual bloggers figured out that they’d get a better audience, reach more people and cover more topics if they teamed together.  Syndication makes all of this painless for the reader.  When you surf GestaltIT.com, you don’t realize that this content is being sucked straight off their personal blogs and presented as a seamless magazine.

Gestalt IT has needs very similar to SQLServerPedia’s blog syndication, but the execution is a little different.  SQLServerPedia is designed to get more readership for great blog entries: our authors focus on solving specific technical issues or giving implementation tips, and they want to get those tips out to as many people as possible.  They don’t want to be blogging in the dark, so to speak.  When readers surf SQLServerPedia syndicated blogs, each blog can have plenty of links driving traffic back to the individual blogger’s site to read other articles.

GestaltIT, on the other hand, has a more traditional magazine style: the articles don’t link back frequently to individual bloggers.  It’s designed so that the readers see the whole thing as a self-contained magazine, no different than any other enterprise magazine. This approach works really well for guys like Stephen who have written extensively for magazines, and who are familiar and comfortable with that professional style.

I like this approach a lot: for example, I could envision a “Business Intelligence Magazine” web site where the best SQL BI bloggers teamed together and syndicated their content.  Heck, I could even imagine some of the SQLServerPedia bloggers syndicating their own content over at Gestalt IT.

And here’s the best part: if you run your own blog under your own domain name, you have the freedom to syndicate your content any way that you please.  It’s your content, your rules.  Over time, as syndication catches on, there will be more sites like SQLServerPedia and Gestalt IT that would love to work with authors to collect great content under the same roof.

I talked to Stephen about the syndication concept as he was in the process of building Gestalt IT.  We talked about everything from the blogger benefits to the mechanics of WordPress syndication.  Stephen and I both had to make some of the same choices as we built our site, and it was funny that we came to the same conclusions.

For example, placing commercial ads on syndicated blogs opens a Pandora’s box of issues.  If ads are shown next to a blogger’s content, how do you share revenue?  Both Stephen and I were lucky enough to avoid that entire problem.  At SQLServerPedia, Quest just eats the cost of the entire site, and at Gestalt IT, they’re doing it to build their own personal brands.

But if I was blogging for free and someone was showing ads next to my content, I’d probably start asking questions.  Furthermore, what happens if the blogger decides to leave the syndicated group?  Do they still get a cut of ad revenue, or do the posts go away completely?  And what about ads on shared pages that have multiple posts on them?  There’s a lot to think about, and sooner or later, somebody’s going to put ads next to syndicated blogs, and I’d hate to be involved in the bean counting.  Accounting bores me to death.

Networking, storage and virtualization interest me to no end, though, and if you’re like me, go check out Gestalt IT.

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

Now syndicating Gail Shaw and Kendal Van Dyke

Two weeks ago today, I asked you folks if you were interesting in syndicating your blog at SQLServerPedia.  I’ve been amazed at the outpouring of interest, and today we’re up to 19 blogs with the addition of Gail Shaw and Kendal Van Dyke:

Gail Shaw of SQLinTheWild

I first started reading Gail’s blog after Jason Massie started sharing some of her items in Google Reader.  She does a great job of explaining concepts.  Some of her recent highlights have been:

  • All Indexes Are Unique – no, really.  This is kind of a trick post, but pay attention to the point, because it can impact what fields you pick for the index.  Hint: even nonclustered indexes include some information about the table’s unique index.
  • Index columns, selectivity and inequality predicates – understanding how the engine picks an index for your query helps you build better indexes and better queries.  I’ve learned a lot from this series.
  • Seek or scan? – how does SQL Server determine when to pick one over the other?

Kendal Van Dyke of My Life as a SQL Server DBA

Kendal Van Dyke

Kendal Van Dyke

Kendal, aka SQLDBA on Twitter, is easily identifiable by his fresh-faced avatar.  When he asked if he could use his avatar as his headshot on the SQLServerPedia Editors page, I slapped myself for not seeing that coming.  And of course I couldn’t say no.  I’ll never be able to recognize the guy in person though – he’d better be wearing a t-shirt with the avatar on it.  Some of his recent blog posts include:

  • Disk Performance: RAID 10 Stats – when you hear guys like me and Jimmy May yell and holler about how important it is to do your partition alignment and your allocation unit sizing, you might not take our word for it. After all, we’re crazy.  Fortunately, Kendal has done all the hard work and actually shown proof of how some of these settings affect your performance.  I’m really looking forward to the rest of this series.
  • Sysprep Breaks Your SQL Server – if you use imaging tools to deploy lots of servers, they can cause problems with SQL Server’s security.  Kendal shows how to fix it.
  • Installing SQL Server Express as a Default Instance – isn’t it a pain how every Express Edition install is a named instance (starting with something like $MSSQL) by default?  Wanna know how to install it as a default instance, just like the big boy version?

More Good News to Come

I’m excited at the way this thing has just totally taken off.  Andy Grant, Christian Hasker and I weren’t sure if we were the only ones who believed in the power of syndication, the need to maintain control over your own personal brand, and the desire to get blog posts seen by more community members.

We’re changing the way database administrators communicate.

We used to be in a rock concert in a stadium: a few people played onstage, and they played really loud.  Everybody else stood around and admired their work, but never really got a chance to approach the stage and get involved.

Today, we’re moving towards a small, intimate coffee shop’s open mike night.  We might not all be Bono, but because there’s so many more of us, we can reach out to more people individually.  We can have personal conversations instead of just listening.  If we have a question about someone’s writings, we can simply dash off a Tweet or comment on their blog and get fast, personal feedback.

I’m excited – but I promise not to start reading poetry.

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

Tips for Syndicated Bloggers

Now that we’ve got more than a dozen bloggers syndicating at SQLServerPedia, we’re starting to see some good practices and ideas around syndication best practices.

Use FeedBurner’s FeedFlare To Bring Traffic to You

FeedBurner is a free Google service that takes your RSS feed, adds some super-rocket-science code to it, and then makes it available to the public.  Instead of giving people a feed like this:

http://www.brentozar.com/feed/

You give them your FeedBurner feed like this:

http://feeds2.feedburner.com/BrentOzar-SqlServerDba

Give me that FeedBurner feed location, and I can change your syndication setup to point to that feed.

Go into the FeedBurner options under Optimize, Feed Flare.  This service will automagically add links to the bottom of every one of your posts like this:

feedburner-feed-flare

FeedBurner Feed Flare

In that example, I’ve got links for Delicious, Digg, adding a comment, sending a Tweet, and bookmarking it.  But here’s the important thing: all of those links refer back to YOUR blog post on YOUR site, regardless of where the person is viewing your blog entry.  Whether someone is reading your RSS feed from your site, or reading it through the SQLServerPedia syndicated feed, if they click on these links, they’re coming to your blog.

While you’re playing around in FeedBurner, you’ll notice the ability to add advertisements into your RSS feed too.  Bad idea.  None of us, me included, are popular enough to pull that one off – I instantly unsubscribe from any RSS feed that has ads, including commercial web sites.

In Multi-Part Articles, Link To Your Site

When you write that epic four-part series on why managers should not be allowed to schedule meetings before 9:30 AM, make sure it’s easy for users to read.  At the beginning of every post in the series, link back to the post before.  At the end of every post, link to the next post.

This means that you have to go back and edit each post after you’ve published the next part in the series.  After all, when you publish part 1, you can’t link to part 2 since it isn’t public yet.  This does create a small bit of work on your part, but it’s worth it.

This way, when people stumble across your blog post in the future, and they read one article in the series, they’ll click to Read Part 3 and come to your site – no matter where they’re reading it.

If you’re really aggressive about bringing more traffic to your site, remember that you don’t have to syndicate every article in the series.  In my Index Fragmentation Findings series, for example, I didn’t syndicate part 1 of the series, but I syndicated Part 2.  That way, people who are reading my syndicated feed at SQLServerPedia will see part 2 and say, “Oh, wow, I didn’t see part 1.  I’ll click on that link and read it,” and bam, next thing you know, they’re at my site.  It’s only a matter of time until they’re clicking on my ads for Extenze and Viagra.  Schazam!  I’m rich!

Don’t Syndicate Everything – Keep Some for Yourself

Add a category in your blog called “Syndication”, and tell your syndication partner (like SQLServerPedia) that you only want to syndicate those articles.  Even if your blog is 100% SQL Server, all the time, you still might not want to syndicate every article.  A good example of that is doing comparison reviews between multiple commercial products, or posting a complaint about a commercial production – that might not be allowed in syndication.  If you only syndicate one category of your blog, you can still post things like that.

You can also keep gems for yourself: write a non-syndicated flagship post with a lot of good content, and then in your syndicated posts, keep referencing back to that flagship post on your own site.  I’ve done this – but not intentionally, oddly – with my How To Get Started Blogging series.  That multi-part series took me a long time to write, but I’ve linked to it more times than I can remember (and I’m purposely not linking to it today because I bet you’re as sick of seeing it as I am).  These kinds of high-effort posts will reward you again and again over time.

Write a Flagship Post With Staying Power

Find something that you know forwards and backwards, something that you can talk about for an hour or two without stopping to draw a breath.  A few years ago, I was using Perfmon all day long to wring every bit of performance out of servers.  I didn’t find it interesting enough to blog about – I thought come on, everybody knows how to work this thing. It’s Perfmon, right?  Click here, click there, game over.

I wrote a Perfmon tutorial anyway, and for years, it’s consistently drawn a steady stream of visitors.  When I talk to people about performance problems and they’re trying to figure out their bottleneck, I can just say, “Go to brentozar.com/perfmon, follow the instructions, and email me the results.”  That alone saves me ten minutes of explanation.

This type of flagship post is what hardcore blog geeks call “evergreen” content: it’s useful over the span of several years.  I can go back to it now and then, add a few lines of updates, and it’s good to go.  That post will still be useful three years from now.  And you know what?  I’m writing another flagship evergreen post right now – this one.

Flagship posts help readers associate you with a particular subject.

When I think partition alignment, I think Jimmy May.  Jimmy has a series of articles on partition alignment that will still be useful three years from now, and that would have been useful if I’d have read them five years ago.  I’ll always remember Jimmy’s site when I want partition alignment information.  And here’s the funny part – when I need partition alignment info, I don’t search the web for that – I search for Jimmy May, and then I go to his site to find the info I need.  That’s what flagship posts are all about, and that’s why evergreen content will help win you a long-term audience.

For better or worse, with the blogging I’ve been doing over the last month, you will probably associate me with blogging and syndication, not with SQL Server!  Don’t worry – I’m already writing more SQL-related content as we speak.  Well, not as we speak, but just a couple of minutes ago.

And I know what you’re thinking: how on earth did this bozo go from talking about SQL Server all the time to suddenly yapping about “flagship post” and “evergreen content”?  Well, I read the manual.

How Embarrassing

How Embarrassing

RTFM: Read The Fine Manual

There are some excellent books out there on how to blog. There are also a great many poor books about it. I’d recommend ProBlogger: Secrets for Blogging Your Way to a Six-Figure Income.

I KNOW.

I know, it sounds really cheesy. It sounds like I’m endorsing a work-from-home gig.  (Wait – I work from home. Damn!)  Holding this book up and endorsing it might just be the low point of my professional career. And we’re talking about a guy who built a production web application with an Access 97 back end and a Classic ASP front end – in Dreamweaver.

But bear with me: it’s a really good book.

If you’re too embarrassed to have this $20 charge appear on your credit card statement (and who could blame you?) you can get an RSS feed at the ProBlogger web site, or follow ProBlogger on Twitter. Or you could pay cash for the book. Send your spouse into the bookstore for it, that works great too. But no matter how you do it, I really do recommend picking this book up – it’s helped me become a better blogger by opening my mind to ideas I wouldn’t have come up with otherwise.

Choose Your Audience: Humans or Search Engines

Once you pick up books like ProBlogger and start reading about search engine techniques, it’s easy to lose focus and start obsessing over Google Analytics metrics like bounce rates and average time on page.  Next thing you know, you’re writing blog posts about how to make money fast and sources for cheap online Viagra.

There’s a right way to get visitors to your blog – write good content that helps people.

There’s a wrong way to get visitors to your blog – game the search engines to fool people in.

In between, there’s a lot of gray area.  For example, take Pinal Dave’s recent blog post, “SQL SERVER – Quickest Way to – Kill All Threads – Kill All User Session – Kill All Processes.”  The post title is clearly designed for search engine optimization, not for human readers.  It’s up to you as the blog author to decide where you want to draw the line.  I can see why Pinal chooses this approach: it gets his message out to more readers, and his MVP award recognizes these efforts to educate the global community.

If you want to choose a different technique to attract readers, you might try meta tags.  Meta tags are hidden elements on the web page that give search engines a clue as to what’s in your page.  WordPress users can get the All in One SEO Pack Plugin, which lets you stuff as many keywords as you want in each page’s meta tags without your users seeing them.  This helps improve your search engine rankings – without looking like you’re trying to improve your search engine rankings.

Add “Recommended Reading” at the Bottom of Each Post

After you’ve been blogging for a while, you’ll build up a little army of articles.  When you write new ones, add a “Related Articles” section at the bottom of your post that points back to some of your older posts.

These related articles may not live at your site.  If you’ve written articles for another site like SQLServerCentral or MSSQLTips, you should link to those too.

Arrr Matey

Arrr Matey

That comes back to my original point in my How to Get Started Blogging series where I talked about remembering why you’re blogging: if you’re blogging for your career, then don’t be worried about sending web visitors off your site to these other places where you’ve written articles.  You put a lot of work into those articles – show ‘em off!

My Opinion: Have a Personality

I know there’s bloggers who say you should blog about SQL, the whole SQL, and nothing but the SQL.  They write their blog as if it’s a book: very professional, but very dry.  That’s a great technique for professional authors, but for the rest of us, don’t be afraid to let your personality shine through.

Crack jokes. Tell stories about how a SQL Server technique served you well – or poorly – at work.  Poke fun at yourself and at others.  If Bill Graziano can get a head tattoo at PASS and live to tell about it, then you don’t have to keep a completely straight face on your blog either.

Having a personality helps you stand out from the army of faceless, boring bloggers that drone on and on about dry technical stuff.  If your readers wanted that, they’d go buy a book.

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

Another 3 SQL Server bloggers at SQLServerPedia

You guys are wearin’ me out!  Yesterday I blogged about Grant Fritchey and Scott Herbert, and now we’ve got another 3 new bloggers syndicating their blogs at SQLServerPedia, bringing our total to 17 syndicated blogs:

Bryan Oliver aka SQLBloke

I had the excellent privilege of working with Bryan, aka SQLBloke on Twitter, at Quest Software, and now he’s with Solid Quality Mentors.  I can personally attest that he’s one of the most qualified engine DBAs I’ve ever met: he knows the engine forwards and backwards, and he’s seen some of the toughest and largest SQL Server environments around.  Now that he’s got a cushy consulting job, we’d better start seeing some more blog entries out of him like these:

  • Backing Up To Tape? Going, Going, Gone – if you’re using the native SQL Server backup commands to go straight to tape, read Bryan’s post about why you won’t be able to rely on this in future versions of SQL Server. One of the first things I do when a new SQL Server version comes out is look at the list of deprecated features.  They’re time bombs waiting to surprise you later.
  • Fill Factor Guidelines – this setting is rarely understood and often abused.  Bryan gives some good default starting values.

Rob Boek of RobBoek.com

Rob’s a man after my own heart: he blogs under his own name, and he’s RobBoek on Twitter too.  I’m all about the personal branding.

Rob’s also challenged me to make sure SQLServerPedia is really about helping the community and not just about grabbing blogger content for SQLServerPedia.  Bloggers out there, you should high-five Rob, because he’s in your corner.  He’s fighting to make sure you don’t get taken advantage of, and that companies like Quest do what’s right for you – not just what’s right for them. I’m proud that Rob decided to syndicate with us, because it means I’m doing the right thing, and I want to continue to work to earn the trust of guys like Rob and bloggers everywhere.

Some of his recent blog entries include:

  • Solving FizzBuzz with Set-Based T-SQL – I talked about using the FizzBuzz problem to filter out DBA job candidates and a couple of answers popped up on blogs.  Rob noticed that the answers wouldn’t perform well, and he upped the ante by writing a very well-performing and easy-to-read solution.
  • SQL Server Blogs Rob Reads – Rob’s a Google Reader addict, and he consumes a lot of good blogs.  If you can’t keep up with that many blogs, here’s what you do: subscribe to Rob’s shared items in Google Reader.  It’s like having Rob personally filter your blogs for you and find the best stuff.  Other Google Reader people you may want to subscribe to are me and Jason Massie.
  • Software Rob Uses Every Day – browse through this list and you might discover your next favorite tool. (And by that I don’t mean Rob.)

Sean Decker

Sean is a SQL Server DBA for one of the top ten US accounting and consulting firms, and he’s just recently started blogging.  Some of his posts include:

  • Using SQL Server Snapshots to Document a Change Process – I’d never thought of this!  When you’re walking through the deployment process for a new software version or a code change, snapshots give you the ability to quickly restore over and over while you’re testing.  Sean explains how to do it.
  • How to Move Your SQL Server Client Config To Another Machine – when you get a new laptop/desktop/Mac Pro, follow Sean’s instructions to copy your SSMS configuration and files.
  • Building Dynamic SQL – this is useful for building utility statements.  I’ve used this often to build select statements to rebuild indexes, audit column contents, and more.  Once you learn how to build dynamic SQL with the INFORMATION_SCHEMA views, you’ll never look back.

If you want to reach more readers and help more DBAs, I’ve added a page in the wiki on how to syndicate your blog at SQLServerPedia.  If you’re stumped for new blog ideas and wondering what people are wondering about, check out our Article Requests section, which breaks out hot topics by section.

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

Now syndicating Grant Fritchey and Scott Herbert

The hits just keep comin’!  Here’s our new additions today:

Grant Fritchey, the Scary DBA

Grant, aka GFritchey on Twitter, is active in PASS and wrote the e-book Dissecting SQL Server Execution Plans.  I met him at the PASS Summit in Seattle, and yes, he is indeed scary.  He walked up to random developers in bars and yelled, “I saw that T-SQL you wrote!  It’s disgusting!  Gimme your beer!” And they would. He’s like the Gordon Ramsey of SQL.  Some of his recent posts have included:

Scott Herbert aka the SQLNinja Blog

Scott Herbert started blogging late last year, and some of his recent blogs have touched on Reporting Services issues, something I appreciate learning more about:

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

SQLServerPedia Blog Syndication FAQ

We’re up to 13 syndicated bloggers (I’ll add another announcement in a day or two about the latest) and a few questions have come up.  Here’s some answers:

Can I syndicate my blog if I’m blogging at a group blog site?

We’d love to, but so far, all of the group blog sites have said no.  They want exclusive rights to their bloggers’ content, and they’re not allowing bloggers to syndicate their content anywhere else.

This comes back to a point that I hammer home in my How to Get Started Blogging series – you really want to own your own blog content and your own brand.

Can I syndicate a non-English blog?

Not yet, but we’re looking at solutions for that.  We’d like to end up with different RSS feeds for each language, and users could pick which language they’d like to subscribe to.  It’s not too technically difficult, but it’s just a matter of resources.  I don’t want to do it until we’ve got a really good user experience.

Looking down the road, I wouldn’t be surprised if we ended up with separate RSS feeds by technology, too, like the SQL Server engine, SSRS, SSIS, SSAS, etc.  The RSS feeds are already getting pretty big.

Can I write about things other than SQL Server?

If you want to write about things that are fairly close to SQL Server, yes.  For example, if you’d like to write about querying with Crystal Reports, database development with Data Dude, or data mining with Excel, then it’s a topic that our audience will probably find interesting.

If you want to write exclusively about Oracle or MySQL, it’s probably not a good fit, but articles every now and then are good.  Jason Massie’s MySQL Cheat Sheet for SQL Server DBAs is a good example – it’s technically about MySQL, but it’s interesting for SQL Server DBAs.

We’ve been approached by a few people who want to start up syndication sites for other types of technology, and I’m more than willing to tell you everything I know about getting started, but I’d rather not be the one hosting it.  There’s a fair bit of management involved.  (I think I’ve done maybe ten hours of real SQL Server work in the last two weeks – the rest has been PHP, MySQL and emailing!)

Do the blog posts link back to each blogger’s home site?

Not yet, but that’s a top priority.  We’re trying to bring on PHP/MySQL help to enhance the aggregation process.  Ideally, I’d like to have every blog entry have a link that points back to the blogger’s site that says something like, “Read More Articles by Tim Ford.” I’d also like the author’s name to hyperlink back to their blog.

The blog aggregation plugin we’re using, FeedWordPress, has the ability to set the blog permalink to the blogger’s original home site.  the problem with that is the bloggers will only get search engine exposure while the post remains on the first couple of pages of SQLServerPedia, which at this point is only a couple of days.  The longer your stuff is on SQLServerPedia, the more exposure you get to web searches, and believe me, it’s huge.  We’ve got posts from a year or older that get hundreds of hits per day from Google, and if you looked at the post, you’d never believe it.

Can I link to other web sites?

Absolutely.  In a perfect world, everything you would need would be at SQLServerPedia.com.  In this perfect world, I would also be driving a Porsche 911 Targa, and Chipotle burritos would make me lose weight.  We’re not quite there yet, so when you find something really useful on another site, you should tell other DBAs about it.

However, please don’t write one-sentence articles that say things like, “Wow, this post was really cool – go check it out!”  Try to add value to the post.  Tell a story about why it’s useful to DBAs, your experiences with the T-SQL code provided, or the pros and cons of different solutions.

If you just want to share links, I’d suggest doing a weekly link post on Friday like this.  I don’t syndicate my weekly link posts on SQLServerPedia, but other bloggers are welcome to.  Come to think of it, that’s a great lead-in for the next question:

Are you just trying to rip off blogger content?

Absolutely not, and the very thought makes me pretty pissed off.  Let me lay out the evidence:

  1. I preach loudly that you need to own your own blog.  Other syndication sites won’t even let you copy your content somewhere else, as some of my readers have found out the hard way.
  2. We don’t put ads on the blog posts or in the RSS feeds. We could – but we don’t, and we’re really hard-core about this.  We have the technology to do that right now with just the flip of a switch, but we won’t do it.  (Yes, it says “Powered by Quest” at the top of the page, but I’d hardly call that an ad – you can’t even click on it.)
  3. I heartily encourage syndicated bloggers to link back to their own site. I do it all the time – in fact, on every single syndicated blog entry I do, I post at least one link back to an article on my own site.  (I’ve done it twice above in this one blog post alone.)
  4. Bloggers don’t have to syndicate every article on SQLServerPedia – they can pick and choose what they’d like to syndicate.  I’m writing a “how-to-blog-for-syndication” series that will cover how to do this in a way that will bring the most visitors to your blog.  I’ll talk about what kinds of entries you should write for syndication, which ones you should keep on your own blog, and how to join them together in a way where everybody wins.
  5. I spend my own personal time advising bloggers how to write better articles. I’m the biggest personal-brand cheerleader I know.  Whenever a blogger has approached me with a question about how to reach more people, how to write a better article, or what kinds of information people are interested in, I’ve invested my own blood, sweat and tears to help make them better. I thoroughly enjoy helping people, not fleecing people.
  6. The evidence is right there on the home page. Check out the SQLServerPedia home page where I link to each of the syndicated bloggers.  The link doesn’t go to their blog feed on SQLServerPedia – it goes to their personal blog.  I’ve done the exact same thing with every single announcement I’ve put out about new bloggers, too – I link to their site, not ours.
  7. We’re spending our own money to make the syndication process even better. We’re in talks to bring a full time PHP/MySQL programmer on staff to make it even smoother, like putting an automatic link in every syndicated post back to the blogger’s original post.  If we can figure out how to have a single set of comments appear in both places, we’ll do that too.

That’s way more than I should probably devote to a topic like that, but I want to make it abundantly clear that we’re in this for the community, and we’re in this for the long term.  I’m the guy who tells you to run your blog under your own personal name because you want to build up your online reputation.  I only have one reputation, and I won’t screw it up by shafting bloggers.

Everything I’ve got so far personally, I didn’t gain by taking from others – I gained it by giving to others.  I’m not rich, but I sleep great at night.

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

Now syndicating Colin Stasiuk and Tim Ford

The list of SQLServerPedia’s syndicated SQL Server bloggers grew by two this week, bringing our total to twelve!  The new voices are:

Colin Stasiuk of BenchmarkITConsulting.com

Young Colin turned 30 last week, and celebrated on Twitter where he’s known as BenchmarkIT.  Some of Colin’s recent blog entries include:

  • What TCP Port is SQL Server running under? The default port for SQL Server is 1433, but when you run multiple instances of SQL Server on the same server, you have to do a little detective work to find the port number of each instance.
  • Doing Pivot Tables in SQL Server – if your data is organized by row, and you need it in columns instead, then you need a pivot table.  Colin gives an example.
  • Copy_Only Backups – I had no clue what this was before I came to work for Quest, and looking back, I wish I’d have learned more about it earlier.  It lets you do backups without breaking your log shipping chains.

Tim Ford of Ford-IT.com

I met Tim, also known as SQLAgentMan on Twitter, at the Professional Association for SQL Server Summit in Seattle.  He’s a good photographer, a fellow Michigander, but alas, a Zune user.  Some of his recent posts include:

  • Book Editing By Dummies – the author’s name goes on the front, but the editors and reviewers are the ones who make sure the author looks good.  I echo Tim’s sentiments about the shock of how fast your career can move once you get involved with PASS – one day you’re trying to decide what book to buy at the bookstore, and the next day you’re trying to figure out how to phrase things in the book you’re writing or editing!
  • SQL Quiz: Toughest Challenges – Chris Shaw started a blog questionnaire about our toughest challenges as DBAs, and Tim’s answer is a problem that every DBA faces sooner or later.
  • How My Dog’s Ovaries Got Me Through Writer’s Block – no, this one wasn’t syndicated, but it’s good.  (I can’t stop laughing when I read Tim’s blog.)

If you’re interested in syndicating your blog at SQLServerPedia, email us at brento@brentozar.com or send me a message on Twitter.  Both Colin & Tim had emailed us at ask@sqlserverpedia.com, but it looks like our spam filter is a little overaggressive, so they didn’t get added until today.  If you emailed us and you haven’t heard back, let me know.

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 SQLServerPedia syndicated bloggers

We’ve added two more bloggers to our syndicated SQLServerPedia blogroll:

Jason Massie of StatisticsIO.com

Known as StatisticsIO on Twitter, Jason not only blogs, but produces the Captain Varchar(MAX) and the Pagelatch Posse comic:

Jeremiah Peschka of Facility9.com

Jeremiah is Peschkaj on Twitter, and some of his recent blog entries include:

  • Retrieve the top X random results from a query – you just use select top X, right? Not so fast – Jeremiah shows an exposure to SQL injection.
  • Flexible database-level roles – security roles come up a lot in enterprise-level deployments.  If you’re a DBA in a small shop, you may want to start learning about role-based security to help you grow your career.
  • How I get by without sysadmin – working for Quest, this stuff comes up a LOT! People want to know how they can work with the least permissions possible because the security team keeps locking them down.  Jeremiah talks about how he does it.

We’ve got a few more in the works – stay tuned!  If you’re interested in signing up too, just drop us a line at ask@sqlserverpedia.com.

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

First round of SQLServerPedia syndicated bloggers

Wow – that went better than I could have hoped.  When I first wrote about syndicating your blog at SQLServerPedia, I figured we’d get maybe a handful of bloggers taking us up on it.  Instead, setting up syndication is now my primary job duty, hahaha.

We’ve got more people waiting in the wings (more on that in a sec) but here’s our first round of syndicated bloggers:

Bob Horkay of LifeAsBob.com

Some of Bob’s recent blog posts include:

  • How to alter a table’s column from varchar to datetime – sounds easy, but the way SQL Server Management Studio does it generates a lot of overhead.  Bob shows a faster way with less production impact.
  • Problems with the IsDate function – this was the subject of a recent StackOverflow bounty question, too.  The IsDate and IsNumeric functions don’t always work the way you’d expect, and to get around it, you may have to code a custom extended stored procedure.  (I’m not kidding.)
  • His home-brewed beer recipe – now, obviously this falls outside of the SQL Server syndication section, but just looking at the pictures makes my mouth water. (It’s five o’clock somewhere – here, actually!)

Jason Strate of Digineer.com

Also known as h4ppyd4y on Twitter, Jason’s been blogging a lot lately, including:

  • Presenting at the SSWUG Virtual Conference – like me and Tom LaRock, among many others, Jason’s doing a set of sessions for this spring’s conference.
  • The Over() Clause – I’ve never used this, and I swear I’m going to read this article and pay attention.  I keep hearing about this.
  • Searching the cache for execution plans – when a user comes running in saying a stored proc was slow five minutes ago, you can find out why by looking at its execution plan after the fact.  Jason shows how.

Michelle Ufford of SQLFool.com

I’ve mentioned Michelle aka SQLFool before because of her index maintenance script contributions at SQLServerPedia, and now she’s contributing blog entries too!  Some of her recent posts:

  • Fragmentation on replicated tables – replication means copying data from one place to another, but not necessarily maintenance statements.  Michelle explains the important difference.
  • Index clean-up scripts – before you make new indexes to improve performance, are you sure you need the ones you’ve already got?
  • Indexing for partitioned tables – doing partitioning is one of those cutting-edge things that isn’t as well-documented as it could be.  Michelle talks about why you may not want to partition your indexes the same way you partition your tables.

Mike Walsh of StraightPathSQL.com

Also known as mike_walsh on Twitter, he writes a straightforward (get it?) blog about SQL with some good business advice like:

  • New vendor interview – before a vendor foists a crappy product on you that requires SA logins, wouldn’t it be nice to ask a few basic questions?  Mike lists his.
  • Do you focus too much on your backups? – like my buddy Bryan Oliver always says, there’s only one reason DBAs do backups: to restore.  Focus on your restores.
  • Empirical evidence – I had a question recently from a user who kept insisting that I tell him what solution would be the fastest for his specific environment.  There’s only one way to find out: test it there.

Tom LaRock of SQLBatman.com

PASS Board of Directors member, caped crusader, and blogger, with recent highlights like:

  • SQL Server 2008 Training from Microsoft – Tom attended a hands-on lab with tutorials on the new features in SQL 2008. He gives a walkthrough of each session.
  • My Vision for the PASS SIGs – want an inside peek at what he’s got planned for the Professional Association for SQL Server? Sadly, it doesn’t involve bacon, but…
  • Whale Bacon – like Bob Horkay’s home-brewed beer post, this one won’t be syndicated either, but it’s funny as hell.

There’s many more to come.  I’m working with several other bloggers to get their RSS feeds set up and get MySQL to stop crashing when I import big feeds like Jason Massie’s.  It keeps saying something about an MVP-ness size problem.  Odd.  Will follow up tomorrow with more bloggers.

I’d like to thank each of these bloggers personally for helping expand the community knowledge base.  They’re writing really good, useful stuff, and hopefully by getting them more exposure, we’re doing a favor to all of the community.

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

Syndicating Your Blog at SQLServerPedia

I’m a big believer that bloggers should run their own personal blogs, under their own personal domain names, to maximize their long-term investments in themselves. You’re building a brand for yourself, and you want to control that asset no matter what.

But What If You Want More Readers?

I’ve talked to bloggers who say they’re frustrated blogging on their own sites because they don’t have enough readers. They feel like they’re toiling alone in the dark, with nobody seeing their work. They’re not dying for readers, but they want to know that their work isn’t going in vain. If they post a valuable solution, a hard-to-write article, or a timely tip, they want to know that it’s going to benefit the most readers possible.

We’ve got a solution that lets you keep your independence and gets you more readers: syndicate your blog at SQLServerPedia. We’ll “echo” your blog posts from your own SQL Server blog automatically.

Syndication Means You Stay In Control

Syndicating your blog at SQLServerPedia doesn’t mean changing the way you write. If you’re like me, you blog about all kinds of things, not just SQL Server. We’ll help you set up a “SQL Server” category on your blog, and our syndication software only picks up blog entries in that category.

You can – and should – still blog about whale bacon, your favorite music, or your adventures in Vegas without feeling like you need to clean up your act for syndication.  If you feel like blogging about personal stuff ten times in a row, then do that – we’re not going to pressure you to keep up a minimum number of SQL Server posts per week in order to be syndicated.

How You Benefit From Being at SQLServerPedia

At the bottom of every blog post on SQLServerPedia, we show a list of related blog posts. Take a look at the bottom of this post by Kevin Kline to see an example. If you blog about something related to an existing hot topic here at SQLServerPedia, your blog post will show up as a related post on that existing link – thereby getting you more readers.

We also put time and effort into publicizing our site. We give out SQLServerPedia t-shirts at user group meetings, PASS events, and code camps. We run ads for SQLServerPedia online and in print magazines. We threw quite a nice relaunch party at the PASS Summit, some of which I even remember.

And it doesn’t require any work on your end – no logins to manage, no new blog editor to learn, no copy/pasting between blog systems. We just automatically suck your blog entries out of your RSS feed.

Bring SQLServerPedia Readers To Your Site

You know me: I’m a very big cheerleader on building your own brand. I wouldn’t set this up if it wasn’t about building your own brand too.

In your syndicated blog entries, you should link to other personal blog entries you’ve made that your readers may find interesting. They click the link, they go to your site to read the article, and they see you as a person instead of a faceless SQL-only blogger.

You should also link to your Twitter feed so readers can communicate more with you, get to know you better, and ask questions about your blog entries.

What If You Don’t Have A Blog Yet?

If the whole concept of starting your own blog sounds like too much work, we’ve got an answer for that too: you can blog at SQLServerPedia without your own blog.  We’ll give you an author account, show you how to use it, and let you write to your heart’s content.  Our only restriction is that your entries need to focus on SQL Server.

If you want help getting started, one of our editors (probably me) can proofread and fact-check your work before you publish it.  Write the draft on the web, and then ping us, and we’ll look it over for you before you post it just to make sure it makes sense.  I’ve worked with a few up-and-coming bloggers, and they all seem to value that initial handholding to make sure they’re not doing something crazy.

Why Is SQLServerPedia Doing It?

Our mission for SQLServerPedia is to be the community-owned resource, built by the SQL Server DBA community, for the community. There are a lot of really good bloggers out there that have gotten burned out toiling away in the dark, and I don’t want them giving up. If it’s exposure you want, we can help you get it.

Plus, SQLServerPedia has guys like me and Kevin who blog at multiple sites. Syndication just makes this whole process easier, as you’ll start to see by my own blog posts being syndicated. My SQL Server blog posts will appear at both BrentOzar.com and at SQLServerPedia.com.

Getting Your Blog Syndicated

To get started, email ask@sqlserverpedia.com. We’ll work with you to answer any questions you might have, and we can have it set up in no time.

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