Back to the UK for SQLBits again

One year on and I find myself in a similar situation to last year only this time I’m not in Boulder, Colorado I’m in Corpus Christi, Texas.  The other constant is that I’m lucky enough to be able to attend SQLBits 9 in Liverpool the day after I get back to the UK.

It’s nice to see that the north of England is hosting SQLBits again, I’m sure Liverpool will be a great location for the event.  I’m also happy that this time I will be attending with a good friend Tony Williams (@twith2sugars on Twitter)

In terms of topics I’m hoping I can attend a lot of the performance tuning and monitoring talks around the Development and DBA tracks as I know I’ll be able to put those skills to work right away. In particular I’d like to be able to get some real world examples of using PowerShell with SQL Server.

As well as refreshing topics I feel comfortable with I like the fact that I can go sit in on BI talk and get some more exposure to SSIS and Data Warehousing.  One of the most interesting talks at SQLBits 7 was on BI, a real eye opener.

The biggest problem is choosing between the great sessions in each time groups, it’s always hard as I wish I could attend two at once.  Also I’m going to miss not being able to see Brent Ozar or Buck Woody present again (they were at SQLBits 7 in York). After reading their blogs for so long it was good to see both of them present, but it allows me to see some new people offer their style of presenting which is always good.

Lastly I hope this year I hope I can win something in the prize giveaway they have, a nice PCI-E SSD card would be nice!

Posted in Conference, Microsoft, SQL Server | Leave a comment

SharePoint site suddenly Read Only even for Administrators!

So at some point in time something had happened to our SharePoint 2010 server to cause what appeared to be a total lock down on the SharePoint sites.

It must have been something strange, something weird, who knows what but it resulted in is ALL users, even site administrators and users with full administrative rights unable to do anything!  Nobody could add new documents or edit documents; nearly every single Document or Library option is greyed out!

The fix it would seem is performed via the central administration website for your server.

  1. Central Administration -> Site Collection Quotas and Locks.
  2. Select your site collection
  3. Change the Site Lock Information radio button from “Read-only” to “Not locked”
  4. OK the changes

 SharePoint 2010 Central Administration Site Collection Quotas and Locks Read-only
You don’t even need to reboot or issue an iisreset command.

Posted in Microsoft, Servers, SharePoint | 2 Comments

Cannot send SMTP mail on port 25, try port 587

I didn’t really want to blog about this, but it’s such a well-known piece of information I’d never heard of.  Most of this blog post is for my own records but if it’s useful to you too that’s great.

Having been a desktop user of Microsoft Exchange, which uses nonstandard proprietary methods to communicate with Outlook I’d never run into the issue of not being able to send out mail.

Using an external IMAP mail server setup to receive on TCP port 143 and send on TCP port 25 works great at the office, no problem.  First time you take your new laptop home, mail will not send with the usual setup

 SMTP Port options

The Simple Mail Transfer Protocol (SMTP) allows mail server administrators to receive email on TCP port 25.  Traditionally TCP port 25 was used for all email processing, submission and server-to-server mail transfers.

The Internet Engineering Task Force (IETF) published RFC 2476 http://tools.ietf.org/html/rfc2476 in December 1998.  In section 3.1 Submission Identification, TCP port 587 was reserved for the initial submission of email messages from a client to an email server.

The document goes on to say that you may still allow an email server to receive email submissions on port 25.  In practice a lot of email servers will accept submissions on both ports 25 and 587.

How clients should really send mail

Outlook SMTP port 25 to port 587

Due to the rise in unsolicited email (SPAM) a lot of ISPs will block port 25 unless you specifically ask for it if you are running your own mail server and take responsibility for not allowing SPAM to be routed through your email server.

My issue came when I was at home as my ISP does block port 25 so I could not send email, but when I was on the WiFi at a friend’s house whose ISP obviously does not block port 25 my outbox suddenly emptied?  Back at my house altering my mail client settings to submit email to the company email service on port 587 had me replying to co-workers once again.

From researching this point the recommendation is for all end user email software configurations to use port 587 as the default and leave port 25 for the server administrators to worry about.

Posted in Networking | Leave a comment

NiallBest.com one year anniversary

I thought it important to me that I should mark the first anniversary of my blog with a roundup post of the first year online for NiallBest.com.

My original goal of the site was to record interesting events and answers to difficult IT and programming situations I found myself in.  Most of these came from my work environment but some good ones were discovered away from the office.

Another goal of the site was to try and post at least once a month, Something I nearly managed excluding a December holiday.  I actually keep a folder with ideas for blog posts on my computer.  Some of them translate well into a post while others are far too lengthy and really quite dull.

A year is certainly a long time in computing terms and it’s somewhat of shame that I no longer get to program as much as I enjoy too.  With a change of employment I find myself sat in airport lounges a lot more that I sit writing code in Microsoft .Net, which makes me thing I should include more personal programming posts in my next year of blogs.

This has allowed me to explore more of a technology side of computing rather than a straight forward programming solutions blog.  I should think there will be a lot more posts in the coming year around the use of new technology and supporting the end users of new technology.

Top blog Posts

Over the whole year I was surprised by how popular some posts were, here are the best of them.

http://niallbest.com/dell-2950-strike-the-f1-key-to-continue/

One of my first posts to the blog but it still gets a surprising amount of traffic, it’s a really nasty issue.

http://niallbest.com/seagate-2tb-st32000542as-cc35-firmware-upgrade/

I never even realised you could (or might have to!) flash the firmware of a hard disk until we suffered the issue with Seagate 2TB disks nearly 12 months ago.  This is by far the most read blog post on my site and it’s still receiving comments from people who are flashing their hard disks even now!

http://niallbest.com/using-windows-azure-tables-to-persist-session-data/

It was nice to get a good programming blog post out and Windows Azure was still very much in its infancy at this point.  I was lucky enough to work for a company that was working with Microsoft using the Azure stack for a new product.  Help at that time was thin on the ground so I hope this post helped a few folks out.

http://niallbest.com/sqlbits-7/

SQLBits 7 was my first real SQL conference; it was a blast and really useful learning resource.  I was also lucky enough to be able to catch the train down in one day to attend.  I wrote this mainly as a roundup of the conference for myself but also to impress on readers that conferences do work as a learning aid, even if they just spark you interest to go investigate something further on your own.

http://niallbest.com/draytek-vigor-ip-pbx-2820-linksys-spa941/

The Draytek IP PBX 2820 is a constant source of irritation at work and I was sure that other people out there might face the same woe.  VoIP shouldn’t be difficult but situations conspire along with time constraints to make things hard.

I must have looked back at this page 10 times or more when doing config updates so for that reason alone it was a very useful blog post.

Stats

Some stats from the year:

  • Over 22,000 visits
  • 27,600 page views
  • 15,800 unique visitors
  • More than 50% of visits came from Google search engine

Visits from 144 different countries, top 5

  1. United States
  2. United Kingdom
  3. Germany
  4. Canada
  5. Russia

Web browser stats

  1. Firefox 38%
  2. IE 31%
  3. Chrome 18%
  4. Safari 5%
  5. Opera 5%
Posted in General | Leave a comment

Travel Tips

I find it strange in this day of Internet enabled devices and Skype meetings that companies pay for their tech people to fly round the world to setup hardware and explain systems to senior management in person rather than via a VPN or virtual meeting, but hey it gets me out of the office and into another one.

Traveling on business can be stressful and leave you exhausted at the other end with a deadline looming or important meeting. I’ve decided to write up my tips and ideas on how to make business travel a little easier.

Know your details

Probably the most important thing to have is a plan or schedule of What, Where, Who and When. We already know the why – business.

Knowing your flight times, flight numbers, airline contact numbers and terminal buildings should be top priority. Usually your company will provide you with an itinerary but I like to amend mine with extra details such as the local numbers for the airlines and airport information. Local taxi numbers at each destination and I also like to plan my way round a new airport in case my transfer time gets short and I need to hurry.

It’s also nice to let somebody else know your travel plans so they can stay in touch or help you out in a bind. http://www.tripit.com is a great site that can compile your itinerary from lots of difference sources.

Plan for delays

The biggest stress reliever I have is knowing that I have a plan if there are delays or alterations. Having a backup plan for travel when your flight gets in the hold for 30 minutes and you need to make a connection quickly really helps.

If you have a smartphone make sure you have any airline applications on your phone and use them for status updates, always try and be ahead of the pack otherwise you can find yourself at the back of a 300 person queue.

If you do need to queue and speak to somebody being civil is the best thing you can do regardless of how you might feel. A top tip from Scott Hanselman is to “speak the language of the airport” when dealing with staff. Give them flight numbers, 24-hour times, airport short codes e.g. LHR (London Heathrow) and have your passport and any boarding cards or booking references quickly to hand. The more you can help them the faster they will help you.

Know the rules

Security is an unfortunate part of air travel today, but you can ease your transition through the checkpoints by dressing cleverly and being selective about what is in your carryon bag.

For example I don’t wear a belt or jacket when flying (but would a jacket help with an operational seat upgrade?) and slip on shoes so it’s easy to move through the security process. I also don’t carry keys or change when flying so there is nothing to set off the scanner.

Easy access to my electronic devices is another plus. I like to pack all the gadgets I’ll need on the flight in a separate wash style bag so all I need to take out is the one bag for the security scanner and any laptop(s). Yes a tablet or iPad does count and needs to be removed from the bag, as I witnessed last week some guy got a grilling over the contents of his carryon for having a iPad2 in there.

Making it personal

I personally don’t work on a flight unless I really have to; I like to take a book I’m reading or latest magazine subscription. Music is good but a lot of airlines don’t let you use headphones or while taxiing or at take-off and landing so good reading material is essential.

If I do feel like sleeping on the plane then ear plugs are a must for me, noise cancelling headphones are great but I find them uncomfortable to sleep in and earplugs are cheap. Some of the better airlines carry them if you ask the cabin staff as well as eye masks.

I usually take several devices with me for the flight. I know most smartphones have an mp3 player capacity but how many also last 8 hours+? I still find a dedicated mp3 player, phone, netbook and handheld gaming device to be the best of all worlds. I always like to have enough to keep me occupied if I find I can’t sleep.

Top Tips

• Plan your itinerary.
• Make a list of useful numbers, both in your phone and in your bag.
• Have multiple forms of payment in different currencies, cash is still king in most places.
• Know your airports and the airport procedures for security.
• Know the correct boarder control procedure.
• Have a routine, you’ll feel better if it feels normal.
• Personalise the travel time with music, books or movies you like.

Posted in General, Travel | Leave a comment