PC Pro Podcast 285

On this week’s podcast: Microsoft tries to scare XP users into upgrading; 3D-printed “gun parts” turn out to be printer spares; Apple’s profits take a tumble despite record iPhone sales; and F-Secure’s Mykko Hypponen worries that the web has become a “US colony”. In hot hardware of the week, Toshiba’s “detachable business Ultrabook”, the Portégé Z10t, tries to convince us to give up our ThinkPads.

Minecrafter Badge

I have commissioned a special badge with a goal of showing that the wearer is an avid Minecraft player.

If used in Scouting, at present it can only be worn on uniform for 1 year from the date of issue as a custom badge with approval from your county commissioner, however I am working to get it internationally recognised as an activity badge.

I have requested approval from the Scout Association to call this an official activity badge, however this has not been granted, and has to wait until their next review, so they are not official activity badges, and does not have the scouting logo on the badge. I am obviously hoping the the Scout Association approves the badge and allows me to make it an official badge with the logo on it!

Its called the Minecrafter Badge. Its available in four different styles.

Explorer Minecrafter Badge - Pack of 5 Scouts Minecrafter Badge - Pack of 5 Cubs Minecrafter Badge - Pack of 5

Its primarily designed to encourage those who are not perhaps the most athletic and sporty to feel that they too can achieve something, and a wonderful way to get potential new members interested.

 

Getting the badge

For Scout leaders wishing to purchase this badge, it is available for £1 each from below. This covers the cost of making the badge, the postage and a very small amount of profit that is used to support a local scout troop. NB. For all orders  of £15 or over there is free shipping.

 

 

Minecrafter badge – Red edge, blue background

Minecrafter badge – Gold edge, red background

Minecrafter badge – Light blue edge, blue background

Minecrafter badge – Dark blue edge, yellow background

 

 

These are not official scouting badges, however as they were conceived of and designed by scouts we propose the following criteria to help you with determining sufficient knowledge to attain the badge if you wish to do so. Lots of the goals are about creativity, but you should add a focus of online safety if possible.

Proposed Badge Criteria (Beavers & Cubs)
UPDATED to cater for single-player where no internet access is possible.

Here are the criteria that need to be met for you to be awarded the Minecrafter Badge.

Complete the following:

1. Play Minecraft on either a PC, Xbox, Playstation, iPad/Tablet or Raspberry Pi

2. Show that you know how to create a single-player world

3. Demonstrate an understanding of how to make/craft the following using a crafting table

  • Furnace
  • Chest
  • Bed
  • Torch
  • Ladder
  • Cobblestone stairs
  • Armour
  •  Sign
  • Bucket
  • Sandstone slab
  • Pane of glass

4. Demonstrate an understanding of how to make the following tools and from what materials they can be made

  • Sword
  • Pickaxe
  • Shovel
  • Axe

5. Play minecraft in a single-player or multi-player environment for at least 1 hour in a 7 day period and build something unique in the world (something you have come up with, not a copy of something someone else has made).

6. Explain why it is important not to do the following when on a multi-player world

  • Breaking the creative works of others

 

Proposed Badge Criteria (Scouts)

Here are the criteria that need to be met for you to be awarded the Minecrafter Badge.

Complete the following:

1. Have your own Minecraft account (where financially possible, recommended, but ideally not purchased as part of this badge). Not applicable for Raspberry Pi.

2. Show that you can download and install Minecraft on to a computer or Raspberry Pi

3. Show that you know how to create a single-player world

4. Show that you know how to add / join a multiplayer world

5. Demonstrate an understanding of how to make/craft the following using a crafting table

  • Furnace
  • Chest
  • Bed
  • Torch
  • Ladder
  • Cobblestone stairs
  • Armour
  •  Sign
  • Painting
  • Bucket
  • Sandstone slab
  • Pane of glass
  • Stone bricks
  • Red Brick

6. Demonstrate an understanding of how to make the following tools and from what materials they can be made

  • Sword
  • Pickaxe
  • Shovel
  • Axe

7. Play minecraft in a multi-player environment for at least 1 hour in a 7 day period and build something unique in the world.

8. Explain why it is important not to do the following when on a multi-player world

  • Breaking the creative works of others
  • Disclosing your real name or personal details about yourself on the chat
  • Use bad language or say things that others may find offensive or to deliberately inflame the situation
  • Arrange to meet up with someone you don’t already know
  • Build offensive structures or signs

 

Proposed Badge Criteria (Explorers)

Here are the criteria that need to be met for you to be awarded the Minecrafter Badge.

Complete the following:

1. Have your own Minecraft account (where financially possible, recommended, but ideally not purchased as part of this badge). Not applicable for Raspberry Pi.

2. Show that you can download and install Minecraft on to a computer

3. Show that you know how to create a single-player world

4. Show that you know how to add / join a multiplayer world

5. Demonstrate an understanding of how to make/craft the following using a crafting table

  • Furnace
  • Chest
  • Bed
  • Torch
  • Ladder
  • Cobblestone stairs
  • Armour
  •  Sign
  • Painting
  • Bucket
  • Sandstone slab
  • Pane of glass
  • Stone bricks
  • Red Brick

6. Demonstrate an understanding of how to make the following tools and from what materials they can be made

  • Sword
  • Pickaxe
  • Shovel
  • Axe

7. Play minecraft in a multi-player environment for at least 1 hour in a 7 day period and build something unique in the world.

8. Explain why it is important not to do the following when on a multi-player world

  • Breaking the creative works of others
  • Disclosing your real name or personal details about yourself on the chat
  • Use bad language or say things that others may find offensive or to deliberately inflame the situation
  • Arrange to meet up with someone you don’t already know
  • Build offensive structures or signs

9. Demonstrate the following working  constructions:

  • 2×2 Jeb Door using pistons and redstone (http://minecraft.gamepedia.com/Tutorials/Jeb_Doors)
  • Redstone tripwire that causes a dispenser to shoot snowballs or arrows at the person who has tripped the wire
  • A working roller coaster with start and stop similar to a real roller coaster.

 

Sales of the minecrafter badges have supported individuals / provided the following equipment for a local scout troop:

  • Purchase of equipment for the survival skills badge work and a survival skills bivouac camp
  • Special fully-funded scout adventure camp to the Mourne Mountains for scouts and their families
  • 20 AirSoft BB Guns for Master At Arms badge
  • 20 bows, arrows and targets for Master At Arms badge
  • Tug of war rope
  • Funding for scouts living in areas of rural deprivation to go to 3 annual scout camps and 2 overnight camps
  • Annual subs for 18 scouts living in areas of rural deprivation whose parents cannot afford the annual costs
  • Purchase of over 800 award/merit badges so that there is no additional costs for parents of scouts living in areas of rural deprivation

1000 Subscribers!

1000-29k4153Today I am honoured and privileged, my blog has reached new heights of numbers of subscribers – over 1000 subscribers! With daily visitors now averaging over 100 visitors per day, its really great that so many people are finding things I have written about to be useful.

Just last week one of the guys I work with said that he was talking to a fellow developer  who lives in England and they got talking about SSL certificates, and he mentioned that he had come across a great blog post that had complete step-by-step guide that he followed and it worked perfectly, and it turned out to be a post on here! Very glad that I have been able to be of service!

PC Pro Podcast 284

On this week’s podcast, Apple’s autumn keynote serves up a new iPad Air, a Retina-screened iPad Mini, new MacBook Pros, OS X Mavericks and full specifications and pricing for the Mac Pro. Meanwhile, Windows 8.1 arrives amidst a flurry of new features, minor tweaks and show-stopping bugs, and Microsoft’s Surface Pro 2 tablet goes for gold in hot hardware of the week.

SQL Server – List all tables and the fragmentation percentage

This is another check you should perform once databases start to get large, as having fragmented indexes have a huge performance hit.

For more on what fragmented indexes are, read this fantastic article.

After significant trial and error we have come up with an SQL script that lists all indexes for every table and shows the percentage fragmentation for the selected database on your server in one go!

 

SELECT
a.database_id,
db_name(a.database_id) As DatabaseName,
a.page_count,
a.OBJECT_ID,
a.index_id,
b.name,
a.avg_fragmentation_in_percent
FROM
sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS a
INNER JOIN sys.indexes AS b ON a.OBJECT_ID = b.OBJECT_ID AND a.index_id = b.index_id
WHERE
a.database_id = DB_ID()
ORDER BY
a.OBJECT_ID