Tag Archives: Blogging

Blog Stats – 2010 in a nutshell

Posted on by
1

Now that 2010 is done and dusted, I figured it was time to have a look at how the blog has done over the last year.

Before I even had a look at any of the numbers I knew that there was one area that would be way below the level that I had hoped for. This number refers to the number of blog posts that I put out during the year. I had started the year with a view to post at least once a week – 52 blog posts. Well that didn’t happen… only a paltry 21 made it online last year. This needs to change this year.

Here’s a look at what took place:

 

Overall Stats
Blog Posts 21
Comments 216
Total Site Visits 34,618

 

Traffic Sources
Source Visits
Search Engines 28,880
Site Referrals 2950
Direct 2786
Other 82

 

Top Content
Blog Post Pageviews
The DatePart() Function in SSRS 5,540
The InScope() Function and the key to formatting subtotals in SSRS Matrix Objects 5,421
Custom Visibility Toggling in SSRS (2005) 4,967
Custom Visibility Toggling in SSRS 2008 2,819
Managing Reporting Services Layouts using the Rectangle in SSRS 2,778
The Join() Function in SSRS 2,415
The DateAdd() function in SSRS 1,908
The Choose() function in SSRS 1,614
Creating Subtotals in a Matrix in SSRS (2005/2008) 1,663
Homepage 1,536

 

Top 5 Locations
Country Visits
United States 15,380
United Kingdom 4,013
India 3,383
Canada 1,438
Australia 1,414

 

I’m pretty happy with these numbers and they certainly give me a benchmark for this year. If you have any feedback on these numbers let me know, I’m always interested to hear your views.

In my next post I’ll outline my goals for the blog and what I hope to achieve for 2011.

SQLServerPedia Syndication!

Posted on by
4

Today I made a commitment, a commitment to the community. And it starts with SQLServerPedia Syndication. That commitment means that I’ll be writing more, interacting more, sharing more, and if at all possible, entertaining more. (OK, so I’m not sure about the last one, but I sure am gonna try).

I have to say, it’s a little daunting being listed amongst MVP’s, professionals with decades of experience and other big personalities in the SQL Server Community. Thankfully, I thrive in situations like these. Being amongst people who are better than you enables you to up your game – or at least that’s been the story for me. Upping my game means that you, dear reader, get more quality content on the topics I care about. For now, that includes SQL Server’s Reporting Services and Integration Services. But you knew that already.

I would ask one favour (yes, that’s the way we spell it over here…) of you, and that is feedback. Of any sort. Whilst I get it right most of the time (I hope), there may be occasions that I’m talking absolute dribble. SPEAK UP! I’m sharing from my own experience and opinion, if it’s wrong, or at least if you believe it’s ‘wrong’, I want to know about it and what you believe the right answer to be.

A big thank you to Brent (Blog | @BrentO) and everyone else at SQLServerPedia for the opportunity to give something back. I’m thoroughly looking forward to the journey ahead and seeing where it takes me.

Blogging with Windows Live Writer

Posted on by
8

Who, What, Why & When

When I first got into blogging (not that long ago), all my writing was done online. It meant that I had to be connected when I wanted to write, which was fine most of the time. But I found that more and more I needed/wanted to write when I didn’t have the luxury of being online. When I was on the train for example. So I started using [notepad/word/other] to draft my posts and then used ‘copy/paste’ to transfer them to the blog. This was frustrating as any formatting in the draft would be mangled on pasting it into the ‘new post’ on the blog. It meant that I would have to reformat everything, normally with horrible consequences. Many of my earlier blog posts were of varying styles. Ugly stuff.

Then I found out about Windows Live Writer. It does everything I need it to do, from saving drafts, inserting pictures, hyperlinks, tables, maps, video, code snippets. All while preserving formatting [Paragraph, Heading1, heading2, headingn], which is handled in the blog at the other end of the tubez.

So what is Windows Live Writer? In their own words:

“Windows Live Writer is a desktop application that makes it easier to compose compelling blog posts”

What are some of the features of WLW?

  • Integration with most [all?] blogging sites (WordPress/Blogger/TypePad/Live Spaces…)
  • WYSIWYG authoring
  • Save drafts locally
  • Publish to draft (on blog)
  • Scheduling – set the publish date & time.
  • A great UI.
  • Photo editing (basic) – crop, tilt, border styles, tints (no caption inclusion though???)
  • Photo albums (care of Windows Live Photo Albums)
  • Insert & publish video (YouTube)
  • Tagging – both server-side and 3rd party integration (technorati, del.icio.us, etc)
  • A whole load of plugins – I use Code Snippet & Polaroid Picture among others
  • Multi-Blog management
  • Many of the Microsoft keyboard shortcuts you are already used to –Ctrl [S|C|V|I|B|Z|Y|K|etc]

 

Getting Started

Firstly, go download the setup file. There is a gotcha here though. When you click the link you’ll be directed to the download page for WL Writer and should get a ‘Save as’ dialog box pop-up. This file is only 1.1MB and will not fulfil your installation requirements. Cancel that download and instead click the ‘Try Again’ button located on the right. This will download a much larger file (~135MB), which will enable you to successfully install WL Writer.

Installation is straight forward, just follow each of the instructions selecting the options you want and click ‘next’.

 

Setting up a connection to your blog

Once installed, locate & run WL Writer to set up your blog account(s). If you don’t yet have a blog, you can set up a Live Spaces blog from Writer, otherwise you will need to go to your preferred provider and create one.

WL Writer will attempt to get your blog’s template (so that you can preview your posts in all their formatted glory), and you will likely get a message pop-up asking if you would like WLW to detect the blog theme by posting a temporary post:

The fact that this does not work (most of the time – for me with WordPress) and that when it does (blogger), it makes writing a post quite awkward, so I have chosen to say ‘NO’ here. This means that I create my posts without previewing the theme that I use on the blog. I still use the Paragraph/header formatting that’s available which is carried through to the blog – which will apply the appropriate style sheet and ensure consistency to the look & feel.

Update – a recent update to WLW has meant that previewing your posts using the theme from your blog now works just fine. With no funny business.

 

Plugins

There are a number of great plugins available for integration with Windows Live Writer. The preinstalled features include the following:

The ones I use at the moment are (the last two on the list above):

- Code Snippet an AWESOME plugin that formats any code that you paste into it in the style associated with the code type that you choose. Here’s a sample in SQL:

- Polaroid Picture allows you to add pictures to your blog posts with captions, as in the picture above. Honestly though, the caption is the only real difference over the integration Picture… feature.

 

Categories, Tags & Scheduling

Adding Categories (or topics), Tags and a publishing date (& time) can be done easily using the category/tag/publish boxes located at the bottom part of the application:

You can also add Tags using your favourite provider (Technorati, del.icio.us, etc) using the Tags…. plugin.

 

That’s about it. Now all that remains is to write your posts and save locally or online as a draft or publish to your blog (immediately or at a specified date & time).

 

Happy typing!