Blog of an overweight SharePoint addict

Wed 28 Feb 07

SQL 2005 Std Installation

Filed under: Uncategorized — Reginald @ 3:14 pm

10 hours down the road and we now have a SQL 2005 installation. I’m not sure if I missed something during the install (and I did it twice after the tempDB issues (see below)) but I couldn’t find where to set the default Database and Logfile locations during install. (Should I have used the command line perhaps?)

Anyway, after install, I then proceeded to follow the Microsoft KB article on moving the Master, Model, MSDB and TempDB databases. And here is the important hint, make sure you read a KB article all the way through before beginning to implement it. I didn’t and happily sailed through the article detaching and reattaching the databases right up until the TempDB which happily detaches, but won’t re-attach. And then your SQL install is quite frankly screwed. All that is required is restoring the MasterDB and you’re well away. I however have only just installed this server and thus don’t have a backup yet!!

Back to the second install!

This time the move went smoothly and I now have the following configuration.

C: and D: on a pair of 36Gb drives housing OS and SQL binaries plus page file.
F: on 3 * 72Gb drives in a Raid 5 housing the Database files.
G: on 2 * 72Gb drives in a Raid 1+0 housing the Log files.

For more information on moving the database and logfiles see:-

How to move SQL Server databases to a new location by using detach and attache functions

The next step today was the configuration of a Maintenance plan, but this wasn’t exactly free of problems as I hit the “GUID should be 32 characters with 4 dashes” error which is apparently a known issue. I’m loading SP2 now and we’ll see if they did managed to fix it in time!

#EDIT# Turns out they did fix it in time!

Tue 27 Feb 07

SQL installations..

Filed under: Installation — Reginald @ 7:41 pm

Well I didn’t find a ton of information last night on SQL 2005 installations, but I did find an interesting WhitePaper on the Microsoft site that looks at Physical DataBase Storage design, which really did cover a lot of what information I was looking for.

Click here for the Physical Database Storage Design Whitepaper

Some of it’s a little bit too database design for me, But As I work through this tommorrow, I’ll put a basic breakdown of how I’m aligning my SQL server install with the white paper.

As ever, wts…

Mon 26 Feb 07

10 Things to do when waiting for RDP to image a server!

Filed under: Installation — Reginald @ 10:21 pm

Well actually it’s just one thing. That is, make sure we get the SQL 2005 installation right first time for MOSS 2007.

So, I’m sat here at 10pm, waiting for a process to finish thats going to run until at least 11:45pm. So google is my latest friend in the search for installation and tuning considerations when installing SQL 2005 for a MOSS 2007 installation.

watch this space..

Sat 24 Feb 07

Home again.

Filed under: Training — Reginald @ 2:50 pm

Well the journey home wasn’t too bad, although I had to dive off the M1 at junction 10 due to the traffic backing up from the M25. Apparently 44 miles of queuing traffic trying to get round from Leatherhead to the M1 was to blame! I cut along the A1081 and through St Albans which wasn’t too bad. (Apart from the dodgy diversion around St Albans town centre whilst they pedestrianise it.)

Anyhow, I promised a review of the course, so here goes:-

SharePoint 2007 Administration Track – Combined Knowledge Training
5 Days – Best Western Hotel – Ullesthorpe

Instructor Craig Carpenter

Overview:-

The course covers 5 days and runs from 9:30 each morning to approc 5pm each night. It starts with an initial introduction to MOSS 2007 and how the course will cover it as well as the obligatory, who are you and what is your background. The course notes are well written however there are some inaccuracies that still need to be ironed out. This is due to the course notes being originally written at Beta TR2 stage. The course covers all of the ‘Core’ functionality and as such does not go into any great detail regarding the Enterprise options. Therefore don’t expect to cover Excel Services, Business Data Catalogue or KPI’s other than to mention where the options exist.

The instructor Craig had a very good presenting style and chose not to plough page by page through the book as some courses do. As he said ‘If we do that, you may as well read the book yourself’. Instead he let himself be guided by flow of the books modules, covering each topic in turn through demonstration and discussion. (Personally I found this the most engaging method and even with the odd 2am finish the night before, I was at full attention for 98% of the day)

Overall, I found the course to be extremely useful and very well presented. There was the odd moment where I found the discussions a little below my skill level, however Craig had to cater for all levels of experience in the course. It was however a good oppourtunity to play with the test system in front of me.

The price for the course was £2000 including the accomodation. When you take into account that this includes all food and refreshments during the day and evening (Drinks have to be paid for yourself in the evenings!), as well as the course itself, then I think this more than matches up to a standard MicroSoft course which normally run at around £200 per day. The hotel itself was extremley pleasant and the rooms were of a very good standard. The food is plentiful and the staff very nice and always happy to help you with any needs. In addition, I was lucky enough to be with a very nice group of people that were happy to socialise in the evenings. This is one aspect of training courses that I normally find lacking, however this one was a nice exception. (I won one of the games of bowling too!! 157 points!)

Course Breakdown:-

Module 0 – Discussed the problems facing Corporations today and discussed the need for SharePoint and what its driving requirements were.

Module 1 – Reviewed the MOSS 2007 architecture, discussing the base requirements for an installation as well as the supporting services (e.g. .Net, IIS). Demonstrated Collaboration, Portal Services, Content Management and other features.

Module 2 – Covered installation and configuration of Single Server farms in MOSS 2007. Craig talked at length about the requirement for multiple user accounts and the need to ensure that the install account is only used for that purpose.

Module 3 – Configuring and Administering Central Administration Operations in MOSS 2007 – Introduced Central Administration, a new concept for MOSS 2007 that brought all the familiar options from 2003 into a central area as well as a whole host of unfamiliar options for the control of the Farm and related services

Module 4 – Configuring and Administering Application Management in MOSS 2007 – As with Opertions, this section looks at the Application Management abilities that are now pulled into a central location for control of the Application Pools and Shared Service Providers within one place.

Module 5 – Configuring and Administering Shared Service Providers – Details the configuration and administering of SSP’s for the provision of services such as Search, Profiles and My Sites, Excel Services, Usage reporting and the Business Data Catalogue.

Module 6 – Overview of MOSS 2007 site templates – A nice straight forward look at the template options available with MOSS 2007 as well as what abilities you have to create and modify you’re own templates. (Also a handy hint on how to get around the 10Mb limit on templates)

Module 7 – Working with SharePoint Web Parts – Covered the use of the out of the box templates, installing third party web parts, exporting and inter connection of web parts in the site.

Module 8 – Design Considerations and Scaling out a Farm. This topic covered some of the planning decisions you should consider when installing your MOSS 2007 infrastructure, as well as the Pros and Cons of the various initial configurations. Covered a brief introductions to NLB and other load balancing options for Multiple Web Front Ends, as well as the idea of distributed service models.

Module 9 – Portal Overview and Administration – This topic looked at what the role of a portal was and how best to administer this in a corporate environment. Looked at the use of My Sites and audiences to deliver the correct content to the correct recipient.

Module 10 – Covered in some detail the configuration of search and indexing within the MOSS 2007 environment. Some very good exercises on the configuration of the crawl rules and scope.

Module 11 – Configure and Administer Document Management in MOSS 2007 – Covered the use of content types within libraries and the use of workflows to control them. (Note, only out of the box workflows are covered and not those created within SharePoint designer)

Module 12 – Configure and Administer Records Management in MOSS 2007 – This covered the configuration of Microsofts first entry into the records management arena. Coveres retension periods, auditing and disposition at expiry,

Module 13 – Overview of Web Content Management in MOSS 2007 – Covers the use of the publishing feature throughout MOSS 2007 and the methods available to affect the branding of the SharePoint site through master pages. Includes the use of re-usable content and the publish to another location options. This section also includes the idea of Variation pages that are tied to such things as Language or browser type and can be used to deliver targetted content.

Module 14 – Disaster Recovery in MOSS 2007 – This about says it all, however it does cover some of the very different backup options available to you in MOSS 2007 as well as some of the more familiar terms that you will have seen in SP 2003.

Fri 23 Feb 07

A hectic week..

Filed under: General — Reginald @ 9:31 am

Well the course is nearly over, and it’s been an interesting week. Not everything that I did on our Sandbox environment was completely wrong, but the course has given me some much better ideas of how to do things and the best practices involved.

One thing Microsoft, How many passwords do you want set up for SharePoint? It’s an AD admins nightmare… Though recommendations on the course show you can cut these down to 5.

I’ll post a more detailed breakdown of the course in the next post, for now, I’ve just paid my Bar Bill (£52.00, not bad for a week of excessive drinking!!)

Mon 19 Feb 07

Mmm.. relaxed start.

Filed under: General — Reginald @ 7:47 am

Well, I’m up in Leicestershire now ready for a 9am start on my course. SharePoint 2007 Administration with Combine-Knowledge. I’ll put a review of the course up on the SUGUK forums later this week.

Something about a relaxing start in a hotel room, whats especially nice is that I don’t actually have to leave the hotel and travel to another location for the training, Combined Knowledge rent a whole boardroom here and set-up the labs on-site.

And on another note, completely un-related to SharePoint, Have you seen the plans for the ‘Council Tax Inspectors’? An article in this mornings Daily Mail shows that these new house inspectors will look at things like Peace and Quiet, Good Schools and clean streets? Does this mean I’ll get a discount because of the Asbo kids that live next door? My council tax already costs me £140.00 a month, My salary does’t climb the same amount each year, Surely we will reach saturation at some point where all the taxes add up and equal more than the incoming?

Fri 16 Feb 07

Moving on…swiftly..

Filed under: General — Reginald @ 9:47 am

Well I finally managed to persuade the boss to send me on a SharePoint 2007 admin course, So Sunday evening I’m off up to the Combined Knowledge residential course for a week of total immersion into MOSS2007. Finally I’ll be able to get some confirmation of the thoughts and dreams I’ve had for SharePoint but not really played with.

In addition, I’ve now got two spanking new DL380 servers ready to play the roles of SQL Master and the Search and indexing server. I contemplating putting the Admin website onto the search and indexing server too. not sure what impact that might have on a CorasWorks license thought if we go down that route as the Search and Indexing server should be a WFE as well.

The WFE is currently planned to go on a VMWare virtual host, so it might be that we’ll have to put the indexing service on that one and gear it up to only run in the whee small hours.. Guess thats a question I’ll have to pass to CorasWorks..

Tue 13 Feb 07

Time to focus..

Filed under: General — Reginald @ 8:49 am

Well MOSS 2007 is now starting to make headway, We’ve received the medias and I’ve now got to freshly built physical boxes to put the SQl database and the Search and indexing platforms on. We’re going to put the Web front endonto a virtual server, this will enable us to scale the solution up, rather than out to take into account a third party licensing issue.

On the subject of Third parties, I went to see CorasWorks last week to look at an end to end development package for SharePoint. This package basically replaces the need to develop an awful lot of your own code, allowing you to put tree navigation and drop down tab menus onto any SharePoint site with no coding at all. The benefits? Cross site functionality in either a tiered or Matrix design.. something that is not available with native SharePoint functionality. And not a drop of .Net coding in sight!!

Take a look for yourself, www.corasworks.net

Sun 11 Feb 07

Reminiscent Journey

Filed under: General — Reginald @ 6:24 pm

Took a trip to the Wood and Power tool show at Ally Pally today (Alexandra Palace in London for those that aren’t familiar). It’s weird how much the area has changed in 20 years and yet still looks the same.

I guess it’s like your living room, The colour and wallpaper changes over time, but unless you do some building work the basic structure stays the same.

Seeing old haunts brought back some very fond memories and one or two distinctly not so fond ones.. Could write a book now..views from a coach.. or maybe not..

Fri 9 Feb 07

Hmm..

Filed under: General — Reginald @ 10:18 pm

Friday just dragged… Not the most of exciting days today.. However Grease 2 was on this evening. Most of my hormonal years were spent dreaming of Michelle Pfeiffer in some of the costumes from that film. I went to see it at the cinema in Barnet 15 times!

Older Posts »

Powered by WordPress