<?xml version="1.0" encoding="utf-8"?>
<rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:pingback="http://madskills.com/public/xml/rss/module/pingback/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
  <channel>
    <title>In Recovery...</title>
    <link>http://www.sqlskills.com/blogs/paul/</link>
    <description>Paul Randal on SQL Server</description>
    <language>en-us</language>
    <copyright>Paul S. Randal</copyright>
    <lastBuildDate>Sat, 04 Oct 2008 00:54:23 GMT</lastBuildDate>
    <generator>newtelligence dasBlog 2.0.7226.0</generator>
    <managingEditor>paul@sqlskills.com</managingEditor>
    <webMaster>paul@sqlskills.com</webMaster>
    <item>
      <trackback:ping>http://www.sqlskills.com/blogs/paul/Trackback.aspx?guid=f845cd4c-387f-47ac-9891-b7c1ac4727cc</trackback:ping>
      <pingback:server>http://www.sqlskills.com/blogs/paul/pingback.aspx</pingback:server>
      <pingback:target>http://www.sqlskills.com/blogs/paul/PermaLink,guid,f845cd4c-387f-47ac-9891-b7c1ac4727cc.aspx</pingback:target>
      <dc:creator>Paul S. Randal</dc:creator>
      <wfw:comment>http://www.sqlskills.com/blogs/paul/CommentView,guid,f845cd4c-387f-47ac-9891-b7c1ac4727cc.aspx</wfw:comment>
      <wfw:commentRss>http://www.sqlskills.com/blogs/paul/SyndicationService.asmx/GetEntryCommentsRss?guid=f845cd4c-387f-47ac-9891-b7c1ac4727cc</wfw:commentRss>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <font face="Verdana">
          <font size="2">
            <p>
I finally got to take Kimberly to Scotland in September and show her some of the country
where I was brought up. After spending 10 days teaching in England, Dublin, and Edinburgh,
we had another 10 days left of vacation. After spending a day sight-seeing in Edinburgh
we headed over to my home town of <a href="http://en.wikipedia.org/wiki/Helensburgh">Helensburgh</a> on
the west coast for my sister's wedding. After that I took Kimberly on a four-day,
whirlwind tour of some of my favorite parts of the north-western Highlands and the
Isle of Skye. The scenery around there is really breath-taking and she loved it.
</p>
            <p>
Below I've included a selection of my favorite photos from the trip. Click on them
to get a 1024x768 version. Kimberly's also blogged a bunch of photos today, so checkout
her <a href="http://www.sqlskills.com/blogs/kimberly/2008/10/03/ScotlandIsAmazinglyBeautifulButAhTheWeatherISWorseThanSeattle.aspx">post</a> if
you want to see some more, and hear her spin on things (including her scary sheep
and cow problem...)
</p>
            <p>
Enjoy!
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/1_IMG_0513.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_1_IMG_0513.JPG" border="1" />
              </a>
            </p>
            <p>
We went to <a href="http://en.wikipedia.org/wiki/Edinburgh_castle">Edinburgh Castle</a>,
as all tourists must do (must have been the 7<sup>th</sup> or 8<sup>th</sup> time
I've been there). The castle is ancient, and the oldest part that survives today is <a href="http://en.wikipedia.org/wiki/St_Margaret%27s_Chapel">St.
Margaret's Chapel</a>, which dates from the early 1100s. We were lucky enough to walk
into the Great Hall just before a display of armaments and dress from the time of <a href="http://en.wikipedia.org/wiki/Oliver_cromwell">Oliver
Cromwell</a> in the 1600s. The officer in the picture had just noticed Kimberly
taking pictures...
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/2_IMG_0590.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_2_IMG_0590.JPG" border="1" />
              </a>
            </p>
            <p>
Next we headed down the <a href="http://en.wikipedia.org/wiki/Royal_mile">Royal Mile</a> to
900-year old <a href="http://en.wikipedia.org/wiki/St_Giles_Cathedral">St. Giles Cathedral</a> to
check out the architecture. As we went in I realized that I'd never been there in
all the 8 years I lived and worked in the city. The image above is from one of the
many stained-glass windows.
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/3_IMG_0681.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_3_IMG_0681.JPG" border="1" />
              </a>
            </p>
            <p>
The day before the wedding, I took Kimberly for a drive around <a href="http://en.wikipedia.org/wiki/Argyll_and_Bute">Argyll</a> in
the mid-west coast. This is a shot of the sea-front of <a href="http://en.wikipedia.org/wiki/Inverary">Inverary</a> on <a href="http://en.wikipedia.org/wiki/Loch_Fyne">Loch
Fyne</a>. If you're into seafood and are ever in the area, make sure you visit the
nearby <a href="http://en.wikipedia.org/wiki/Loch_Fyne_Oysters">Loch Fyne Oyster Bar</a> for
some of best and freshest seafood you'll ever eat.
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/4_IMG_0698.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_4_IMG_0698.JPG" border="1" />
              </a>
            </p>
            <p>
The real reason for me organizing this trip - renting a cool car (Land Rover LR3)
and pretending to rally drive around the perilous, single-track roads of northern
Scotland :-). If you ever go to Scotland and want fantastic rental service, checkout <a href="http://www.4x4aberdeen.co.uk/">Aberdeen
4x4</a> - they'll deliver a car to your hotel and you can drop it anywhere in the
country when you're done.
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/5_IMG_0786.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_5_IMG_0786.JPG" border="1" />
              </a>
            </p>
            <p>
After Inveraray, we headed down to <a href="http://en.wikipedia.org/wiki/Lochgilphead">Lochgilphead</a>,
which is very aptly named as its the town at the head of Loch Gilp, and then further
west over the <a href="http://en.wikipedia.org/wiki/Crinan_Canal">Crinan Canal</a>.
This is a photo looking east up some of the locks.
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/6_IMG_0802.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_6_IMG_0802.JPG" border="1" />
              </a>
            </p>
            <p>
One of my aims that day was to take Kimberly to <a href="http://en.wikipedia.org/wiki/Kilmartin_Glen">Kilmartin
Glen</a>, home to some of coolest <a href="http://en.wikipedia.org/wiki/Neolithic">Neolithic</a> and <a href="http://en.wikipedia.org/wiki/Bronze_Age">Bronze
Age</a> monuments in Scotland. In the space of a few miles, there are standing stones,
stone circles and burial cairns - the Wikipedia link is worth reading. It really takes
a day to explore the whole valley but we could only stop quickly as we passed through.
The photo above is of the larger <a href="http://en.wikipedia.org/wiki/Temple_Wood">Temple
Wood</a> stone circle, dating back 5000 years.
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/7_P1010268.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_7_P1010268.JPG" border="1" />
              </a>
            </p>
            <p>
And on to the wedding, which was held in the hotel Kimberly and I stayed at in <a href="http://en.wikipedia.org/wiki/Rhu">Rhu</a>.
This was the first time in my life that I'd worn a kilt! I'd always resisted it until
now (although I describe myself as Scottish, because I lived there from a very early
age, my parents are both English and I was born in England - so I'm technically English)
but I *really* loved it. This was the same for my Dad (in the photo next to me) -
but he didn't enjoy it as much as I did. I think we both look really cool.
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/8_P1010353.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_8_P1010353.JPG" border="1" />
              </a>
            </p>
            <p>
And the happy couple. Well, not the couple that got married (my sister and her new
husband Dean), but we're happy too :-)
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/9_IMG_0829.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_9_IMG_0829.JPG" border="1" />
              </a>
            </p>
            <p>
After the wedding we had a day to recover (Scottish weddings involve copious amounts
of alcohol) and my parents had a party, partly to celebrate Kimberly's birthday (cue
more alcohol...). The next day we set off into the Highlands. I took Kimberly along
the roads with the best scenery I could think of. This is a shot from along the <a href="http://en.wikipedia.org/wiki/A82_road">A82</a> road
through <a href="http://en.wikipedia.org/wiki/Glen_Coe">Glen Coe</a> (which is
often considered the most spectacular place in Scotland), on the way up to <a href="http://en.wikipedia.org/wiki/Fort_William,_Scotland">Fort
William</a> and then to <a href="http://en.wikipedia.org/wiki/Kyle_of_Lochalsh">Kyle
of Lochalsh</a>.
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/10_IMG_0935.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_10_IMG_0935.JPG" border="1" />
              </a>
            </p>
            <p>
While staying in Kyle of Lochalsh, I took Kimberly on a trip around some of the really
remote roads in that area. This is a shot heading up one of the wildest roads
in the whole of the UK, the famous <a href="http://en.wikipedia.org/wiki/Bealach_na_Ba">Bealach-na-Ba</a> (Gaelic
for <em>Pass of Cattle</em>) that rises about 2000 feet above sea level in the space
of a few miles. The road is only just wider than the Land Rover and has some incredibly
tight and steep switch-backs.
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/11_IMG_0961.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_11_IMG_0961.JPG" border="1" />
              </a>
            </p>
            <p>
And here we're near the top looking down to the sea (almost exactly the same shot
as in the Wikipedia link above). If you click to enlarge the photo, you can see that
the road disappears over the precipice around half-way down - great fun to drive if
you're used to single-track roads.
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/12_IMG_0992.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_12_IMG_0992.JPG" border="1" />
              </a>
            </p>
            <p>
Here's why I wanted to drive that road - this is <a href="http://en.wikipedia.org/wiki/Applecross">Applecross</a>,
one of my top 5 places on the whole planet. The name really refers to the whole peninsula
that the road encircles, rather than just the little town itself. There's not much
here - just little roads, awesome views across the sea to the islands, and sheep.
Maybe a few cows too. But it's the views that are just unbeatable.
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/13_IMG_1062.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_13_IMG_1062.JPG" border="1" />
              </a>
            </p>
            <p>
There are more sheep than people on the Applecross peninsula, for sure.
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/14_IMG_1116.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_14_IMG_1116.JPG" border="1" />
              </a>
            </p>
            <p>
As we left Kyle of Lochalsh to head over to <a href="http://en.wikipedia.org/wiki/Skye">Skye</a> (using
the ferry, not the <a href="http://en.wikipedia.org/wiki/Skye_Bridge">Skye Bridge</a>),
we passed by the famous, 800-year old <a href="http://en.wikipedia.org/wiki/Eilean_Donan">Eilean
Donan Castle</a> on the shores of Loch Duich. This is my favorite castle in the world.
You may have seen it in the movie <a href="http://en.wikipedia.org/wiki/Highlander_(film)">Highlander</a> (one
of my favorite movies), or more recently in <a href="http://en.wikipedia.org/wiki/Made_of_Honor">Made
of Honor</a> (not one of my favorite movies).
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/15_IMG_1138.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_15_IMG_1138.JPG" border="1" />
              </a>
            </p>
            <p>
We'd decided to take the ferry from <a href="http://en.wikipedia.org/wiki/Glenelg,_Scotland">Glenelg</a> over
to <a href="http://en.wikipedia.org/wiki/Kylerhea">Kylerhea</a> on Skye. To do that
we had to drive over another famous road, the Bealach Ratagain. Here's the view from
almost the top looking down on Shiel Bridge and some of the <a href="http://en.wikipedia.org/wiki/Five_Sisters_of_Kintail">Five
Sisters of Kintail</a> (a 3500ft high mountain ridge with 5 distinct peaks, none of
which I've climbed unfortunately).
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/16_IMG_1154.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_16_IMG_1154.JPG" border="1" />
              </a>
            </p>
            <p>
And here's the <a href="http://www.skyeferry.co.uk/">Glenelg ferry</a>. This is a
6-car ferry and is the only surviving turntable ferry in Scotland. It's a far
more romantic way to get to Skye than going over the bridge. There used to be a ferry
from Kyle of Lochalsh to Kyleakin on Skye, but the advent of the bridge in the mid-1990s
made it economically unfeasible to continue the service. The narrow waterway that
the ferry crosses has one of the strongest tidal rushes in the UK - more then 12 knots
during a Spring tide.
</p>
            <p>
              <a href="http://www.sqlskills.com/blogs/paul/content/binary/17_P1010732.JPG">
                <img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_17_P1010732.JPG" border="1" />
              </a>
            </p>
            <p>
Once on Skye we did a bunch of touring around, mostly in the crappy rain. Kimberly
has some good photos on her <a href="http://www.sqlskills.com/blogs/kimberly/2008/10/03/ScotlandIsAmazinglyBeautifulButAhTheWeatherISWorseThanSeattle.aspx">blog
post</a> so I don't duplicate them here. To finish off, here we are looking slightly
damp after drying off in the bar of the <a href="http://www.royal-hotel-skye.com/">Royal
Hotel</a> (very much recommended) in <a href="http://en.wikipedia.org/wiki/Portree">Portree</a>,
over a few games of cribbage and a few pints of good beer.
</p>
            <p>
Cheers!
</p>
          </font>
        </font>
        <img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=f845cd4c-387f-47ac-9891-b7c1ac4727cc" />
        <br />
        <hr />
This weblog is sponsored by <a href="http://www.SQLskills.com">SQLskills.com</a>.
(c) Paul S. Randal. This feed is for personal, non-commercial use.</body>
      <title>Photos and stories from our Scotland trip</title>
      <guid isPermaLink="false">http://www.sqlskills.com/blogs/paul/PermaLink,guid,f845cd4c-387f-47ac-9891-b7c1ac4727cc.aspx</guid>
      <link>http://www.sqlskills.com/blogs/paul/2008/10/04/PhotosAndStoriesFromOurScotlandTrip.aspx</link>
      <pubDate>Sat, 04 Oct 2008 00:54:23 GMT</pubDate>
      <description>&lt;font face=Verdana&gt;&lt;font size=2&gt; 
&lt;p&gt;
I finally got to take Kimberly to Scotland in September and show her some of the country
where I was brought up. After spending 10 days teaching in England, Dublin, and Edinburgh,
we had another 10 days left of vacation. After spending a day sight-seeing in Edinburgh
we headed over to my home town of &lt;a href="http://en.wikipedia.org/wiki/Helensburgh"&gt;Helensburgh&lt;/a&gt; on
the west coast for my sister's wedding. After that I took Kimberly on a&amp;nbsp;four-day,
whirlwind tour of some of my favorite parts of the north-western Highlands and the
Isle of Skye. The scenery around there is really breath-taking and she loved it.
&lt;/p&gt;
&lt;p&gt;
Below I've included a selection of my favorite photos from the trip. Click on them
to get a 1024x768 version. Kimberly's also blogged a bunch of photos today, so checkout
her &lt;a href="http://www.sqlskills.com/blogs/kimberly/2008/10/03/ScotlandIsAmazinglyBeautifulButAhTheWeatherISWorseThanSeattle.aspx"&gt;post&lt;/a&gt; if
you want to see some more, and hear her spin on things (including her scary sheep
and cow problem...)
&lt;/p&gt;
&lt;p&gt;
Enjoy!
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/1_IMG_0513.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_1_IMG_0513.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
We went to &lt;a href="http://en.wikipedia.org/wiki/Edinburgh_castle"&gt;Edinburgh Castle&lt;/a&gt;,
as all tourists must do (must have been the 7&lt;sup&gt;th&lt;/sup&gt; or 8&lt;sup&gt;th&lt;/sup&gt; time
I've been there). The castle is ancient, and the oldest part that survives today is &lt;a href="http://en.wikipedia.org/wiki/St_Margaret%27s_Chapel"&gt;St.
Margaret's Chapel&lt;/a&gt;, which dates from the early 1100s. We were lucky enough to walk
into the Great Hall just before a display of armaments and dress from the time of &lt;a href="http://en.wikipedia.org/wiki/Oliver_cromwell"&gt;Oliver
Cromwell&lt;/a&gt;&amp;nbsp;in the 1600s. The officer in the picture had just noticed Kimberly
taking pictures...
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/2_IMG_0590.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_2_IMG_0590.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
Next we headed down the &lt;a href="http://en.wikipedia.org/wiki/Royal_mile"&gt;Royal Mile&lt;/a&gt; to
900-year old &lt;a href="http://en.wikipedia.org/wiki/St_Giles_Cathedral"&gt;St. Giles Cathedral&lt;/a&gt; to
check out the architecture. As we went in I realized that I'd never been there in
all the 8 years I lived and worked in the city. The image above is from one of the
many&amp;nbsp;stained-glass windows.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/3_IMG_0681.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_3_IMG_0681.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
The day before the wedding, I took Kimberly for a drive around &lt;a href="http://en.wikipedia.org/wiki/Argyll_and_Bute"&gt;Argyll&lt;/a&gt; in
the mid-west coast. This is a shot of the sea-front of &lt;a href="http://en.wikipedia.org/wiki/Inverary"&gt;Inverary&lt;/a&gt; on &lt;a href="http://en.wikipedia.org/wiki/Loch_Fyne"&gt;Loch
Fyne&lt;/a&gt;. If you're into seafood and are ever in the area, make sure you visit the
nearby &lt;a href="http://en.wikipedia.org/wiki/Loch_Fyne_Oysters"&gt;Loch Fyne Oyster Bar&lt;/a&gt; for
some of best and freshest seafood you'll ever eat.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/4_IMG_0698.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_4_IMG_0698.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
The real reason for me organizing this trip - renting a cool car (Land Rover LR3)
and pretending to rally drive around the perilous, single-track roads of northern
Scotland :-). If you ever go to Scotland and want fantastic rental service, checkout &lt;a href="http://www.4x4aberdeen.co.uk/"&gt;Aberdeen
4x4&lt;/a&gt; - they'll deliver a car to your hotel and you can drop it anywhere in the
country when you're done.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/5_IMG_0786.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_5_IMG_0786.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
After Inveraray, we headed down to &lt;a href="http://en.wikipedia.org/wiki/Lochgilphead"&gt;Lochgilphead&lt;/a&gt;,
which is very aptly named as its the town at the head of Loch Gilp, and then further
west over the &lt;a href="http://en.wikipedia.org/wiki/Crinan_Canal"&gt;Crinan Canal&lt;/a&gt;.
This is a photo looking east up some of the locks.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/6_IMG_0802.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_6_IMG_0802.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
One of my aims that day was to take Kimberly to &lt;a href="http://en.wikipedia.org/wiki/Kilmartin_Glen"&gt;Kilmartin
Glen&lt;/a&gt;, home to some of coolest &lt;a href="http://en.wikipedia.org/wiki/Neolithic"&gt;Neolithic&lt;/a&gt; and &lt;a href="http://en.wikipedia.org/wiki/Bronze_Age"&gt;Bronze
Age&lt;/a&gt; monuments in Scotland. In the space of a few miles, there are standing stones,
stone circles and burial cairns - the Wikipedia link is worth reading. It really takes
a day to explore the whole valley but we could only stop quickly as we passed through.
The photo above is of the larger &lt;a href="http://en.wikipedia.org/wiki/Temple_Wood"&gt;Temple
Wood&lt;/a&gt; stone circle, dating back 5000 years.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/7_P1010268.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_7_P1010268.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
And on to the wedding, which was held in the hotel Kimberly and I stayed at in &lt;a href="http://en.wikipedia.org/wiki/Rhu"&gt;Rhu&lt;/a&gt;.
This was the first time in my life that I'd worn a kilt! I'd always resisted it until
now (although I describe myself as Scottish, because I lived there from a very early
age, my parents are both English and I was born in England - so I'm technically English)
but I *really* loved it. This was the same for my Dad (in the photo next to me) -
but he didn't enjoy it as much as I did. I think we both look really cool.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/8_P1010353.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_8_P1010353.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
And the happy couple. Well, not the couple that got married (my sister and her new
husband Dean), but we're happy too :-)
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/9_IMG_0829.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_9_IMG_0829.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
After the wedding we had a day to recover (Scottish weddings involve copious amounts
of alcohol) and my parents had a party, partly to celebrate Kimberly's birthday (cue
more alcohol...). The next day we set off into the Highlands. I took Kimberly along
the roads with the best scenery I could think of. This is a shot from along the &lt;a href="http://en.wikipedia.org/wiki/A82_road"&gt;A82&lt;/a&gt; road
through &lt;a href="http://en.wikipedia.org/wiki/Glen_Coe"&gt;Glen Coe&lt;/a&gt;&amp;nbsp;(which is
often considered the most spectacular place in Scotland), on the way up to &lt;a href="http://en.wikipedia.org/wiki/Fort_William,_Scotland"&gt;Fort
William&lt;/a&gt; and then to &lt;a href="http://en.wikipedia.org/wiki/Kyle_of_Lochalsh"&gt;Kyle
of Lochalsh&lt;/a&gt;.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/10_IMG_0935.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_10_IMG_0935.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
While staying in Kyle of Lochalsh, I took Kimberly on a trip around some of the really
remote roads in that area. This is a shot heading up one&amp;nbsp;of the wildest roads
in the whole of the UK, the famous &lt;a href="http://en.wikipedia.org/wiki/Bealach_na_Ba"&gt;Bealach-na-Ba&lt;/a&gt; (Gaelic
for &lt;em&gt;Pass of Cattle&lt;/em&gt;) that rises about 2000 feet above sea level in the space
of a few miles. The road is only just wider than the Land Rover and has some incredibly
tight and steep switch-backs.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/11_IMG_0961.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_11_IMG_0961.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
And here we're near the top looking down to the sea (almost exactly the same shot
as in the Wikipedia link above). If you click to enlarge the photo, you can see that
the road disappears over the precipice around half-way down - great fun to drive if
you're used to single-track roads.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/12_IMG_0992.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_12_IMG_0992.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
Here's why I wanted to drive that road - this is &lt;a href="http://en.wikipedia.org/wiki/Applecross"&gt;Applecross&lt;/a&gt;,
one of my top 5 places on the whole planet. The name really refers to the whole peninsula
that the road encircles, rather than just the little town itself. There's not much
here - just little roads, awesome views across the sea to the islands, and sheep.
Maybe a few cows too. But it's the views that are just unbeatable.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/13_IMG_1062.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_13_IMG_1062.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
There are more sheep than people on the Applecross peninsula, for sure.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/14_IMG_1116.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_14_IMG_1116.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
As we left Kyle of Lochalsh to head over to &lt;a href="http://en.wikipedia.org/wiki/Skye"&gt;Skye&lt;/a&gt;&amp;nbsp;(using
the ferry, not the &lt;a href="http://en.wikipedia.org/wiki/Skye_Bridge"&gt;Skye Bridge&lt;/a&gt;),
we passed by the famous, 800-year old&amp;nbsp;&lt;a href="http://en.wikipedia.org/wiki/Eilean_Donan"&gt;Eilean
Donan Castle&lt;/a&gt; on the shores of Loch Duich. This is my favorite castle in the world.
You may have seen it in the movie &lt;a href="http://en.wikipedia.org/wiki/Highlander_(film)"&gt;Highlander&lt;/a&gt;&amp;nbsp;(one
of my favorite movies), or more recently in &lt;a href="http://en.wikipedia.org/wiki/Made_of_Honor"&gt;Made
of Honor&lt;/a&gt; (not one of my favorite movies).
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/15_IMG_1138.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_15_IMG_1138.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
We'd decided to take the ferry from &lt;a href="http://en.wikipedia.org/wiki/Glenelg,_Scotland"&gt;Glenelg&lt;/a&gt; over
to &lt;a href="http://en.wikipedia.org/wiki/Kylerhea"&gt;Kylerhea&lt;/a&gt; on Skye. To do that
we had to drive over another famous road, the Bealach Ratagain. Here's the view from
almost the top looking down on Shiel Bridge and some of the &lt;a href="http://en.wikipedia.org/wiki/Five_Sisters_of_Kintail"&gt;Five
Sisters of Kintail&lt;/a&gt; (a 3500ft high mountain ridge with 5 distinct peaks, none of
which I've climbed unfortunately).
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/16_IMG_1154.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_16_IMG_1154.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
And here's the &lt;a href="http://www.skyeferry.co.uk/"&gt;Glenelg ferry&lt;/a&gt;. This is a
6-car ferry and is the only surviving&amp;nbsp;turntable ferry in Scotland. It's a far
more romantic way to get to Skye than going over the bridge. There used to be a ferry
from Kyle of Lochalsh to Kyleakin on Skye, but the advent of the bridge in the mid-1990s
made it economically unfeasible to continue the service. The narrow waterway that
the ferry crosses has one of the strongest tidal rushes in the UK - more then 12 knots
during a Spring tide.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.sqlskills.com/blogs/paul/content/binary/17_P1010732.JPG"&gt;&lt;img src="http://www.sqlskills.com/blogs/paul/content/binary/Small_17_P1010732.JPG" border=1&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
Once on Skye we did a bunch of touring around, mostly in the crappy rain. Kimberly
has some good photos on her &lt;a href="http://www.sqlskills.com/blogs/kimberly/2008/10/03/ScotlandIsAmazinglyBeautifulButAhTheWeatherISWorseThanSeattle.aspx"&gt;blog
post&lt;/a&gt; so I don't duplicate them here. To finish off, here we are looking slightly
damp after drying off in the&amp;nbsp;bar of the &lt;a href="http://www.royal-hotel-skye.com/"&gt;Royal
Hotel&lt;/a&gt;&amp;nbsp;(very much recommended) in &lt;a href="http://en.wikipedia.org/wiki/Portree"&gt;Portree&lt;/a&gt;,
over a few games of cribbage and a few pints of good beer.
&lt;/p&gt;
&lt;p&gt;
Cheers!
&lt;/p&gt;
&lt;/font&gt;&lt;/font&gt;&lt;img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=f845cd4c-387f-47ac-9891-b7c1ac4727cc" /&gt;
&lt;br /&gt;
&lt;hr /&gt;
This weblog is sponsored by &lt;a href="http://www.SQLskills.com"&gt;SQLskills.com&lt;/a&gt;. (c) Paul S. Randal. This feed is for personal, non-commercial use.</description>
      <comments>http://www.sqlskills.com/blogs/paul/CommentView,guid,f845cd4c-387f-47ac-9891-b7c1ac4727cc.aspx</comments>
    </item>
    <item>
      <trackback:ping>http://www.sqlskills.com/blogs/paul/Trackback.aspx?guid=6477f805-3286-4a98-8545-db884fa1f1e0</trackback:ping>
      <pingback:server>http://www.sqlskills.com/blogs/paul/pingback.aspx</pingback:server>
      <pingback:target>http://www.sqlskills.com/blogs/paul/PermaLink,guid,6477f805-3286-4a98-8545-db884fa1f1e0.aspx</pingback:target>
      <dc:creator>Paul S. Randal</dc:creator>
      <wfw:comment>http://www.sqlskills.com/blogs/paul/CommentView,guid,6477f805-3286-4a98-8545-db884fa1f1e0.aspx</wfw:comment>
      <wfw:commentRss>http://www.sqlskills.com/blogs/paul/SyndicationService.asmx/GetEntryCommentsRss?guid=6477f805-3286-4a98-8545-db884fa1f1e0</wfw:commentRss>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <font face="Verdana" size="2">
          <p>
Just over a month since SQL Server 2008 went to RTM and the first Cumulative Update
(CU1) has been released. Bob Ward, a very good friend of mine, and a Principal Escalation
Engineer in the SQL Server Product Support team published a <a href="http://blogs.msdn.com/psssql/archive/2008/09/26/welcome-to-sql-server-2008-patching.aspx">detailed
blog post</a> on Friday explaining how to get it and install it.
</p>
          <p>
If you're not subscribed to the PSS blog, you should be. They post a ton of great
info on how things work and how to work around bugs. Bob just <a href="http://blogs.msdn.com/psssql/archive/2008/09/30/how-to-fix-your-sql-server-2008-setup-before-you-run-setup.aspx">blogged
again today</a> about how SQL Server 2008 Setup itself can be patched - not a
trivial problem to engineer around.
</p>
          <p>
Checkout the PSS blog at <a href="http://blogs.msdn.com/psssql/default.aspx">http://blogs.msdn.com/psssql/default.aspx</a>.
</p>
        </font>
        <img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=6477f805-3286-4a98-8545-db884fa1f1e0" />
        <br />
        <hr />
This weblog is sponsored by <a href="http://www.SQLskills.com">SQLskills.com</a>.
(c) Paul S. Randal. This feed is for personal, non-commercial use.</body>
      <title>SQL Server 2008 patching has begun - and the PSS blog</title>
      <guid isPermaLink="false">http://www.sqlskills.com/blogs/paul/PermaLink,guid,6477f805-3286-4a98-8545-db884fa1f1e0.aspx</guid>
      <link>http://www.sqlskills.com/blogs/paul/2008/09/30/SQLServer2008PatchingHasBegunAndThePSSBlog.aspx</link>
      <pubDate>Tue, 30 Sep 2008 22:35:29 GMT</pubDate>
      <description>&lt;font face=Verdana size=2&gt; 
&lt;p&gt;
Just over a month since SQL Server 2008 went to RTM and the first Cumulative Update
(CU1) has been released. Bob Ward, a very good friend of mine, and a Principal Escalation
Engineer in the SQL Server Product Support team published a &lt;a href="http://blogs.msdn.com/psssql/archive/2008/09/26/welcome-to-sql-server-2008-patching.aspx"&gt;detailed
blog post&lt;/a&gt; on Friday explaining how to get it and install it.
&lt;/p&gt;
&lt;p&gt;
If you're not subscribed to the PSS blog, you should be. They post a ton of great
info on how things work and how to work around bugs. Bob just &lt;a href="http://blogs.msdn.com/psssql/archive/2008/09/30/how-to-fix-your-sql-server-2008-setup-before-you-run-setup.aspx"&gt;blogged
again today&lt;/a&gt; about how&amp;nbsp;SQL Server 2008 Setup itself can be patched - not a
trivial problem&amp;nbsp;to&amp;nbsp;engineer around.
&lt;/p&gt;
&lt;p&gt;
Checkout the PSS blog at &lt;a href="http://blogs.msdn.com/psssql/default.aspx"&gt;http://blogs.msdn.com/psssql/default.aspx&lt;/a&gt;.
&lt;/p&gt;
&lt;/font&gt;&lt;img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=6477f805-3286-4a98-8545-db884fa1f1e0" /&gt;
&lt;br /&gt;
&lt;hr /&gt;
This weblog is sponsored by &lt;a href="http://www.SQLskills.com"&gt;SQLskills.com&lt;/a&gt;. (c) Paul S. Randal. This feed is for personal, non-commercial use.</description>
      <comments>http://www.sqlskills.com/blogs/paul/CommentView,guid,6477f805-3286-4a98-8545-db884fa1f1e0.aspx</comments>
      <category>Install / Setup</category>
    </item>
    <item>
      <trackback:ping>http://www.sqlskills.com/blogs/paul/Trackback.aspx?guid=e427ed83-e4a4-45cc-a8a6-e2a966dbe772</trackback:ping>
      <pingback:server>http://www.sqlskills.com/blogs/paul/pingback.aspx</pingback:server>
      <pingback:target>http://www.sqlskills.com/blogs/paul/PermaLink,guid,e427ed83-e4a4-45cc-a8a6-e2a966dbe772.aspx</pingback:target>
      <dc:creator>Paul S. Randal</dc:creator>
      <wfw:comment>http://www.sqlskills.com/blogs/paul/CommentView,guid,e427ed83-e4a4-45cc-a8a6-e2a966dbe772.aspx</wfw:comment>
      <wfw:commentRss>http://www.sqlskills.com/blogs/paul/SyndicationService.asmx/GetEntryCommentsRss?guid=e427ed83-e4a4-45cc-a8a6-e2a966dbe772</wfw:commentRss>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <font face="Verdana" size="2">
          <p>
For the first time in ages, Kimberly sneaked in an interview without me! I was teaching
a class on Database Maintenance for some Microsoft DBAs and Kimberly recorded a <a href="http://www.runasradio.com/">RunAs
Radio</a> interview on her favorite subject - indexes. I love listening to her talk
about indexes - or maybe I just like the sound of her voice :-)
</p>
          <p>
Check it out at <a href="http://www.runasradio.com/default.aspx?showNum=76">http://www.runasradio.com/default.aspx?showNum=76</a>.
</p>
          <p>
Enjoy!
</p>
          <p>
PS She also drops some hints about an upcoming project of ours...
</p>
        </font>
        <img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=e427ed83-e4a4-45cc-a8a6-e2a966dbe772" />
        <br />
        <hr />
This weblog is sponsored by <a href="http://www.SQLskills.com">SQLskills.com</a>.
(c) Paul S. Randal. This feed is for personal, non-commercial use.</body>
      <title>RunAs Radio interview on indexes (and future projects...)</title>
      <guid isPermaLink="false">http://www.sqlskills.com/blogs/paul/PermaLink,guid,e427ed83-e4a4-45cc-a8a6-e2a966dbe772.aspx</guid>
      <link>http://www.sqlskills.com/blogs/paul/2008/09/30/RunAsRadioInterviewOnIndexesAndFutureProjects.aspx</link>
      <pubDate>Tue, 30 Sep 2008 22:28:16 GMT</pubDate>
      <description>&lt;font face=Verdana size=2&gt; 
&lt;p&gt;
For the first time in ages, Kimberly sneaked in an interview without me! I was teaching
a class on Database Maintenance for some Microsoft DBAs and Kimberly recorded a &lt;a href="http://www.runasradio.com/"&gt;RunAs
Radio&lt;/a&gt; interview on her favorite subject - indexes. I love listening to her talk
about indexes - or maybe I just like the sound of her voice :-)
&lt;/p&gt;
&lt;p&gt;
Check it out at &lt;a href="http://www.runasradio.com/default.aspx?showNum=76"&gt;http://www.runasradio.com/default.aspx?showNum=76&lt;/a&gt;.
&lt;/p&gt;
&lt;p&gt;
Enjoy!
&lt;/p&gt;
&lt;p&gt;
PS She also drops some hints about an upcoming project of ours...
&lt;/p&gt;
&lt;/font&gt;&lt;img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=e427ed83-e4a4-45cc-a8a6-e2a966dbe772" /&gt;
&lt;br /&gt;
&lt;hr /&gt;
This weblog is sponsored by &lt;a href="http://www.SQLskills.com"&gt;SQLskills.com&lt;/a&gt;. (c) Paul S. Randal. This feed is for personal, non-commercial use.</description>
      <comments>http://www.sqlskills.com/blogs/paul/CommentView,guid,e427ed83-e4a4-45cc-a8a6-e2a966dbe772.aspx</comments>
      <category>Indexes From Every Angle</category>
      <category>Interviews</category>
    </item>
    <item>
      <trackback:ping>http://www.sqlskills.com/blogs/paul/Trackback.aspx?guid=96ccd3e9-49e9-4f3d-88f2-03ef5434fb96</trackback:ping>
      <pingback:server>http://www.sqlskills.com/blogs/paul/pingback.aspx</pingback:server>
      <pingback:target>http://www.sqlskills.com/blogs/paul/PermaLink,guid,96ccd3e9-49e9-4f3d-88f2-03ef5434fb96.aspx</pingback:target>
      <dc:creator>Paul S. Randal</dc:creator>
      <wfw:comment>http://www.sqlskills.com/blogs/paul/CommentView,guid,96ccd3e9-49e9-4f3d-88f2-03ef5434fb96.aspx</wfw:comment>
      <wfw:commentRss>http://www.sqlskills.com/blogs/paul/SyndicationService.asmx/GetEntryCommentsRss?guid=96ccd3e9-49e9-4f3d-88f2-03ef5434fb96</wfw:commentRss>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <font face="Verdana" size="2">
          <p>
It's been almost two weeks since my last post as we've been offline in Scotland (another
photo post to follow - I owe you two now...) but now we're back for the crazy Fall
conference and teaching season.
</p>
          <p>
The latest installment of my regular Q&amp;A column in TechNet Magazine is available
at <a href="http://technet.microsoft.com/en-us/magazine/cc895648.aspx">http://technet.microsoft.com/en-us/magazine/cc895648.aspx</a>.
This month I cover the following topics:
</p>
          <ul>
            <li>
How backups and restores work and why the times for each may differ 
</li>
            <li>
The difference between log shipping and database mirroring around BULK_LOGGED operations 
</li>
            <li>
How other factors apart from log backups can contribute to excessively large transaction
logs 
</li>
            <li>
Why database repair exists and why it shouldn't be used 
</li>
            <li>
Tracking index usage with sys.dm_db_index_usage_stats</li>
          </ul>
          <p>
Enjoy!
</p>
        </font>
        <img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=96ccd3e9-49e9-4f3d-88f2-03ef5434fb96" />
        <br />
        <hr />
This weblog is sponsored by <a href="http://www.SQLskills.com">SQLskills.com</a>.
(c) Paul S. Randal. This feed is for personal, non-commercial use.</body>
      <title>TechNet Magazine: October SQL Q&amp;A column</title>
      <guid isPermaLink="false">http://www.sqlskills.com/blogs/paul/PermaLink,guid,96ccd3e9-49e9-4f3d-88f2-03ef5434fb96.aspx</guid>
      <link>http://www.sqlskills.com/blogs/paul/2008/09/23/TechNetMagazineOctoberSQLQAColumn.aspx</link>
      <pubDate>Tue, 23 Sep 2008 01:07:45 GMT</pubDate>
      <description>&lt;font face=Verdana size=2&gt; 
&lt;p&gt;
It's been almost two weeks since my last post as we've been offline in Scotland (another
photo post to follow - I owe you two now...) but now we're back for the crazy Fall
conference and teaching season.
&lt;/p&gt;
&lt;p&gt;
The latest installment of my regular Q&amp;amp;A column in TechNet Magazine is available
at &lt;a href="http://technet.microsoft.com/en-us/magazine/cc895648.aspx"&gt;http://technet.microsoft.com/en-us/magazine/cc895648.aspx&lt;/a&gt;.
This month I cover the following topics:
&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
How backups and restores work and why the times for each may differ 
&lt;li&gt;
The difference between log shipping and database mirroring around BULK_LOGGED operations 
&lt;li&gt;
How other factors apart from log backups can contribute to excessively large transaction
logs 
&lt;li&gt;
Why database repair exists and why it shouldn't be used 
&lt;li&gt;
Tracking index usage with sys.dm_db_index_usage_stats&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;
Enjoy!
&lt;/p&gt;
&lt;/font&gt;&lt;img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=96ccd3e9-49e9-4f3d-88f2-03ef5434fb96" /&gt;
&lt;br /&gt;
&lt;hr /&gt;
This weblog is sponsored by &lt;a href="http://www.SQLskills.com"&gt;SQLskills.com&lt;/a&gt;. (c) Paul S. Randal. This feed is for personal, non-commercial use.</description>
      <comments>http://www.sqlskills.com/blogs/paul/CommentView,guid,96ccd3e9-49e9-4f3d-88f2-03ef5434fb96.aspx</comments>
      <category>Backup/Restore</category>
      <category>Database Maintenance</category>
      <category>Database Mirroring</category>
      <category>Log Shipping</category>
      <category>Repair</category>
      <category>TechNet Magazine</category>
      <category>Transaction Log</category>
    </item>
    <item>
      <trackback:ping>http://www.sqlskills.com/blogs/paul/Trackback.aspx?guid=6d0d76b3-7b21-4b5b-a62c-d82d51133c93</trackback:ping>
      <pingback:server>http://www.sqlskills.com/blogs/paul/pingback.aspx</pingback:server>
      <pingback:target>http://www.sqlskills.com/blogs/paul/PermaLink,guid,6d0d76b3-7b21-4b5b-a62c-d82d51133c93.aspx</pingback:target>
      <dc:creator>Paul S. Randal</dc:creator>
      <wfw:comment>http://www.sqlskills.com/blogs/paul/CommentView,guid,6d0d76b3-7b21-4b5b-a62c-d82d51133c93.aspx</wfw:comment>
      <wfw:commentRss>http://www.sqlskills.com/blogs/paul/SyndicationService.asmx/GetEntryCommentsRss?guid=6d0d76b3-7b21-4b5b-a62c-d82d51133c93</wfw:commentRss>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <font face="Verdana">
          <font size="2">
            <a href="http://www.devconnections.com/sfworkshops/defaultsql.asp?s=127">
              <img src="http://www.sqlskills.com/images/PwrWrkShps_SQL=lg.gif" align="left" border="1" />
            </a>
            <p align="justify">
 
</p>
            <p align="justify">
 
</p>
            <p align="justify">
 
</p>
            <p align="justify">
 
</p>
            <p align="justify">
Over the last six months on the blog, you'll have seen me mention internal training
that Kimberly and I wrote for Microsoft on SQL Server 2008. This deep training covers
all the features around database infrastructure and scalability and we've just finished
revamping it for RTM. We did a one-day version of this content at TechEd in June,
and last week for the Microsoft Ireland "SQL Academy" training program, but we've
never presented the course to the public - until now!
</p>
            <p>
We're teaching the entire demo-laden 2.5 day course at the Connections event in San
Fransisco next month, including the hands-on labs. Click the image for full details
and registration.
</p>
            <p>
Here's the abstract:
</p>
            <p>
SQL Server 2008 offers an impressive array of capabilities for professional developers
that build upon key innovations introduced in SQL Server 2005. The use of many of
these will have manageability and infrastructure implications for a database - and
hence the DBA! There are also enhancements to existing high-availability technologies,
plus a variety of significant new tools to aid in managing performance, scalability,
administration, and troubleshooting. This workshop helps you understand how to exploit
the new toolset and how to manage a database that makes use of the new features in
SQL Server 2008. The multi-day format of this event allows us to explore each feature
in more detail, with more in-depth demonstrations and labs. 
<br /><br />
Topics covered include: 
</p>
            <ul>
              <li>
Availability Enhancements 
<ul><li>
Database Mirroring 
</li><li>
Backup Compression 
</li><li>
Peer-to-Peer Replication 
</li></ul></li>
              <li>
Security Enhancements 
<ul><li>
Transparent Data Encryption 
</li><li>
Extensible Key Management 
</li><li>
All Actions Audited 
</li></ul></li>
              <li>
Policy-Based Management and Multi-Server Administration 
</li>
              <li>
Troubleshooting and Resource Management 
<ul><li>
Resource Governor 
</li><li>
Extended Events 
</li></ul></li>
              <li>
New Development Technologies 
<ul><li>
Spatial Indexes 
</li><li>
Sparse Columns 
</li><li>
Filtered Indexes and Statistics 
</li><li>
Change Tracking and Change Data Capture 
</li><li>
FILESTREAM 
</li></ul></li>
              <li>
Performance Data Collection 
</li>
              <li>
Scalability Enhancements 
<ul><li>
Data Compression 
</li><li>
Partition-Level Lock Escalation 
</li></ul></li>
            </ul>
            <p>
Who should attend this workshop? 
</p>
            <ul>
              <li>
Database administrators 
</li>
              <li>
IT Pros who also manage databases 
</li>
              <li>
Application developers who would like to know how feature choice affects database
scalability and infrastructure requirements 
</li>
            </ul>
            <p>
What are the benefits of attending this workshop? 
</p>
            <ul>
              <li>
Learn all the essential elements of SQL Server 2008 administration in an interactive,
instructor-led format 
</li>
              <li>
Learn about the new features of SQL Server 2008 that developers will use that have
management implications 
</li>
              <li>
Deep and intensive 200-300-level technical training custom-designed for professional
DBAs and IT-Pros 
</li>
              <li>
Courseware developed by Paul S. Randal and Kimberly L. Tripp of <a href="http://www.sqlskills.com/">http://www.sqlskills.com/</a>,
pre-eminent experts in SQL Server administration 
</li>
              <li>
Get hands-on experience with SQL Server 2008 administration 
</li>
            </ul>
            <p>
This workshop runs Oct 6 (9am - 4pm), Oct 7 (9am - 4pm), Oct 8 (9am - 12pm). 
</p>
          </font>
        </font>
        <img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=6d0d76b3-7b21-4b5b-a62c-d82d51133c93" />
        <br />
        <hr />
This weblog is sponsored by <a href="http://www.SQLskills.com">SQLskills.com</a>.
(c) Paul S. Randal. This feed is for personal, non-commercial use.</body>
      <title>SQL Server 2008 public class - database infrastructure and scalability</title>
      <guid isPermaLink="false">http://www.sqlskills.com/blogs/paul/PermaLink,guid,6d0d76b3-7b21-4b5b-a62c-d82d51133c93.aspx</guid>
      <link>http://www.sqlskills.com/blogs/paul/2008/09/10/SQLServer2008PublicClassDatabaseInfrastructureAndScalability.aspx</link>
      <pubDate>Wed, 10 Sep 2008 07:41:24 GMT</pubDate>
      <description>&lt;font face=Verdana&gt;&lt;font size=2&gt;&lt;a href="http://www.devconnections.com/sfworkshops/defaultsql.asp?s=127"&gt;&lt;img src="http://www.sqlskills.com/images/PwrWrkShps_SQL=lg.gif" align=left border=1&gt;&lt;/a&gt; 
&lt;p align=justify&gt;
&amp;nbsp;
&lt;/p&gt;
&lt;p align=justify&gt;
&amp;nbsp;
&lt;/p&gt;
&lt;p align=justify&gt;
&amp;nbsp;
&lt;/p&gt;
&lt;p align=justify&gt;
&amp;nbsp;
&lt;/p&gt;
&lt;p align=justify&gt;
Over the last six months on the blog, you'll have seen me mention internal training
that Kimberly and I wrote for Microsoft on SQL Server 2008. This deep training covers
all the features around database infrastructure and scalability and we've just finished
revamping it for RTM. We did a one-day version of this content at TechEd in June,
and last week for the Microsoft Ireland "SQL Academy" training program, but we've
never presented the course to the public - until now!
&lt;/p&gt;
&lt;p&gt;
We're teaching the entire demo-laden 2.5 day course at the Connections event in San
Fransisco next month, including the hands-on labs. Click the image for full details
and registration.
&lt;/p&gt;
&lt;p&gt;
Here's the abstract:
&lt;/p&gt;
&lt;p&gt;
SQL Server 2008 offers an impressive array of capabilities for professional developers
that build upon key innovations introduced in SQL Server 2005. The use of many of
these will have manageability and infrastructure implications for a database - and
hence the DBA! There are also enhancements to existing high-availability technologies,
plus a variety of significant new tools to aid in managing performance, scalability,
administration, and troubleshooting. This workshop helps you understand how to exploit
the new toolset and how to manage a database that makes use of the new features in
SQL Server 2008. The multi-day format of this event allows us to explore each feature
in more detail, with more in-depth demonstrations and labs. 
&lt;br&gt;
&lt;br&gt;
Topics covered include: 
&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
Availability Enhancements 
&lt;ul&gt;
&lt;li&gt;
Database Mirroring 
&lt;li&gt;
Backup Compression 
&lt;li&gt;
Peer-to-Peer Replication 
&lt;/li&gt;
&lt;/ul&gt;
&lt;li&gt;
Security Enhancements 
&lt;ul&gt;
&lt;li&gt;
Transparent Data Encryption 
&lt;li&gt;
Extensible Key Management 
&lt;li&gt;
All Actions Audited 
&lt;/li&gt;
&lt;/ul&gt;
&lt;li&gt;
Policy-Based Management and Multi-Server Administration 
&lt;li&gt;
Troubleshooting and Resource Management 
&lt;ul&gt;
&lt;li&gt;
Resource Governor 
&lt;li&gt;
Extended Events 
&lt;/li&gt;
&lt;/ul&gt;
&lt;li&gt;
New Development Technologies 
&lt;ul&gt;
&lt;li&gt;
Spatial Indexes 
&lt;li&gt;
Sparse Columns 
&lt;li&gt;
Filtered Indexes and Statistics 
&lt;li&gt;
Change Tracking and Change Data Capture 
&lt;li&gt;
FILESTREAM 
&lt;/li&gt;
&lt;/ul&gt;
&lt;li&gt;
Performance Data Collection 
&lt;li&gt;
Scalability Enhancements 
&lt;ul&gt;
&lt;li&gt;
Data Compression 
&lt;li&gt;
Partition-Level Lock Escalation 
&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;
Who should attend this workshop? 
&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
Database administrators 
&lt;li&gt;
IT Pros who also manage databases 
&lt;li&gt;
Application developers who would like to know how feature choice affects database
scalability and infrastructure requirements 
&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;
What are the benefits of attending this workshop? 
&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
Learn all the essential elements of SQL Server 2008 administration in an interactive,
instructor-led format 
&lt;li&gt;
Learn about the new features of SQL Server 2008 that developers will use that have
management implications 
&lt;li&gt;
Deep and intensive 200-300-level technical training custom-designed for professional
DBAs and IT-Pros 
&lt;li&gt;
Courseware developed by Paul S. Randal and Kimberly L. Tripp of &lt;a href="http://www.sqlskills.com/"&gt;http://www.sqlskills.com/&lt;/a&gt;,
pre-eminent experts in SQL Server administration 
&lt;li&gt;
Get hands-on experience with SQL Server 2008 administration 
&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;
This workshop runs Oct 6 (9am - 4pm), Oct 7 (9am - 4pm), Oct 8 (9am - 12pm). 
&lt;/p&gt;
&lt;/font&gt;&lt;/font&gt;&lt;img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=6d0d76b3-7b21-4b5b-a62c-d82d51133c93" /&gt;
&lt;br /&gt;
&lt;hr /&gt;
This weblog is sponsored by &lt;a href="http://www.SQLskills.com"&gt;SQLskills.com&lt;/a&gt;. (c) Paul S. Randal. This feed is for personal, non-commercial use.</description>
      <comments>http://www.sqlskills.com/blogs/paul/CommentView,guid,6d0d76b3-7b21-4b5b-a62c-d82d51133c93.aspx</comments>
    </item>
    <item>
      <trackback:ping>http://www.sqlskills.com/blogs/paul/Trackback.aspx?guid=87e4bd63-09d0-436e-a2b8-89bef4fbf786</trackback:ping>
      <pingback:server>http://www.sqlskills.com/blogs/paul/pingback.aspx</pingback:server>
      <pingback:target>http://www.sqlskills.com/blogs/paul/PermaLink,guid,87e4bd63-09d0-436e-a2b8-89bef4fbf786.aspx</pingback:target>
      <dc:creator>Paul S. Randal</dc:creator>
      <wfw:comment>http://www.sqlskills.com/blogs/paul/CommentView,guid,87e4bd63-09d0-436e-a2b8-89bef4fbf786.aspx</wfw:comment>
      <wfw:commentRss>http://www.sqlskills.com/blogs/paul/SyndicationService.asmx/GetEntryCommentsRss?guid=87e4bd63-09d0-436e-a2b8-89bef4fbf786</wfw:commentRss>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <font face="Verdana" size="2">
          <p>
At the last Connections conference in April, the conference organizers tapped a bunch
of speakers for interviews, articles, and other content to put into a free "newsletter"
called <em>MyDevConnections</em>, and now it's finally available. It covers all the
Connections conferences, so isn't just limited to SQL Server. As far as SQL is concerned,
Kimberly and I wrote an article about our favorite SQL Server 2008 features (data
compression and filtered indexes, respectively), and <a href="http://www.networkworld.com/community/mistry">Ross
Mistry</a> wrote an article on hardening a SQL Server 2005 installation. There's also
an extract from a <em>Women in Technology</em> interview that Kimberly took part in.
Overall there's 84 pages of content in the PDF, with some adverts for the Connections
shows (obviously).
</p>
          <p>
Check it out at <a href="http://www.devconnections.com/mydevconnections/S08_DevOnlineMag_Web.pdf">http://www.devconnections.com/mydevconnections/S08_DevOnlineMag_Web.pdf</a></p>
        </font>
        <img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=87e4bd63-09d0-436e-a2b8-89bef4fbf786" />
        <br />
        <hr />
This weblog is sponsored by <a href="http://www.SQLskills.com">SQLskills.com</a>.
(c) Paul S. Randal. This feed is for personal, non-commercial use.</body>
      <title>Dev Connections newsletter</title>
      <guid isPermaLink="false">http://www.sqlskills.com/blogs/paul/PermaLink,guid,87e4bd63-09d0-436e-a2b8-89bef4fbf786.aspx</guid>
      <link>http://www.sqlskills.com/blogs/paul/2008/09/10/DevConnectionsNewsletter.aspx</link>
      <pubDate>Wed, 10 Sep 2008 07:29:02 GMT</pubDate>
      <description>&lt;font face=Verdana size=2&gt; 
&lt;p&gt;
At the last Connections conference in April, the conference organizers tapped a bunch
of speakers for interviews, articles, and other content to put into a free "newsletter"
called &lt;em&gt;MyDevConnections&lt;/em&gt;, and now it's finally available. It covers all the
Connections conferences, so isn't just limited to SQL Server. As far as SQL is concerned,
Kimberly and I wrote an article about our favorite SQL Server 2008 features (data
compression and filtered indexes, respectively), and &lt;a href="http://www.networkworld.com/community/mistry"&gt;Ross
Mistry&lt;/a&gt; wrote an article on hardening a SQL Server 2005 installation. There's also
an extract from a &lt;em&gt;Women in Technology&lt;/em&gt; interview that Kimberly took part in.
Overall there's 84 pages of content in the PDF, with some adverts for the Connections
shows (obviously).
&lt;/p&gt;
&lt;p&gt;
Check it out at &lt;a href="http://www.devconnections.com/mydevconnections/S08_DevOnlineMag_Web.pdf"&gt;http://www.devconnections.com/mydevconnections/S08_DevOnlineMag_Web.pdf&lt;/a&gt;
&lt;/p&gt;
&lt;/font&gt;&lt;img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=87e4bd63-09d0-436e-a2b8-89bef4fbf786" /&gt;
&lt;br /&gt;
&lt;hr /&gt;
This weblog is sponsored by &lt;a href="http://www.SQLskills.com"&gt;SQLskills.com&lt;/a&gt;. (c) Paul S. Randal. This feed is for personal, non-commercial use.</description>
      <comments>http://www.sqlskills.com/blogs/paul/CommentView,guid,87e4bd63-09d0-436e-a2b8-89bef4fbf786.aspx</comments>
      <category>Compression</category>
      <category>Conferences</category>
      <category>Indexes From Every Angle</category>
      <category>Security</category>
      <category>SQL Server 2008</category>
    </item>
    <item>
      <trackback:ping>http://www.sqlskills.com/blogs/paul/Trackback.aspx?guid=98048ff3-ef1c-4cc4-9ccb-be7131cc23b6</trackback:ping>
      <pingback:server>http://www.sqlskills.com/blogs/paul/pingback.aspx</pingback:server>
      <pingback:target>http://www.sqlskills.com/blogs/paul/PermaLink,guid,98048ff3-ef1c-4cc4-9ccb-be7131cc23b6.aspx</pingback:target>
      <dc:creator>Paul S. Randal</dc:creator>
      <wfw:comment>http://www.sqlskills.com/blogs/paul/CommentView,guid,98048ff3-ef1c-4cc4-9ccb-be7131cc23b6.aspx</wfw:comment>
      <wfw:commentRss>http://www.sqlskills.com/blogs/paul/SyndicationService.asmx/GetEntryCommentsRss?guid=98048ff3-ef1c-4cc4-9ccb-be7131cc23b6</wfw:commentRss>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <font face="Verdana" size="2">
          <p>
This is the second of the two sessions I recently recorded with Richard and Greg on <a href="http://www.RunAsRadio.com">RunAs
Radio</a> (the first one on being an "involuntary DBA" is <a href="http://www.runasradio.com/default.aspx?showNum=72">here</a>).
I've just finished the final edited version of a whitepaper for Microsoft on the FILESTREAM
feature of SQL Server 2008 and this session goes into details of why you'd want to
use it and how to setup a system for optimal FILESTREAM performance. The whitepaper
should be available before PASS in November, in the meantime, checkout the show!
</p>
          <p>
The show is 35 minutes long and you can download it at <a href="http://www.runasradio.com/default.aspx?showNum=74">http://www.runasradio.com/default.aspx?showNum=74</a>. 
</p>
          <p>
Enjoy!
</p>
        </font>
        <img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=98048ff3-ef1c-4cc4-9ccb-be7131cc23b6" />
        <br />
        <hr />
This weblog is sponsored by <a href="http://www.SQLskills.com">SQLskills.com</a>.
(c) Paul S. Randal. This feed is for personal, non-commercial use.</body>
      <title>RunAs Radio interview on FILESTREAM</title>
      <guid isPermaLink="false">http://www.sqlskills.com/blogs/paul/PermaLink,guid,98048ff3-ef1c-4cc4-9ccb-be7131cc23b6.aspx</guid>
      <link>http://www.sqlskills.com/blogs/paul/2008/09/10/RunAsRadioInterviewOnFILESTREAM.aspx</link>
      <pubDate>Wed, 10 Sep 2008 07:13:24 GMT</pubDate>
      <description>&lt;font face=Verdana size=2&gt; 
&lt;p&gt;
This is the second of the two sessions I recently recorded with Richard and Greg on &lt;a href="http://www.RunAsRadio.com"&gt;RunAs
Radio&lt;/a&gt;&amp;nbsp;(the first one on being an "involuntary DBA" is &lt;a href="http://www.runasradio.com/default.aspx?showNum=72"&gt;here&lt;/a&gt;).
I've just finished the final edited version of a whitepaper for Microsoft on the FILESTREAM
feature of SQL Server 2008 and this session goes into details of why you'd want to
use it and how to setup a system for optimal FILESTREAM performance. The whitepaper
should be available before PASS in November, in the meantime, checkout the show!
&lt;/p&gt;
&lt;p&gt;
The show is 35 minutes long and you can download it at &lt;a href="http://www.runasradio.com/default.aspx?showNum=74"&gt;http://www.runasradio.com/default.aspx?showNum=74&lt;/a&gt;. 
&lt;/p&gt;
&lt;p&gt;
Enjoy!
&lt;/p&gt;
&lt;/font&gt;&lt;img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=98048ff3-ef1c-4cc4-9ccb-be7131cc23b6" /&gt;
&lt;br /&gt;
&lt;hr /&gt;
This weblog is sponsored by &lt;a href="http://www.SQLskills.com"&gt;SQLskills.com&lt;/a&gt;. (c) Paul S. Randal. This feed is for personal, non-commercial use.</description>
      <comments>http://www.sqlskills.com/blogs/paul/CommentView,guid,98048ff3-ef1c-4cc4-9ccb-be7131cc23b6.aspx</comments>
      <category>FILESTREAM</category>
      <category>Interviews</category>
      <category>SQL Server 2008</category>
    </item>
    <item>
      <trackback:ping>http://www.sqlskills.com/blogs/paul/Trackback.aspx?guid=af2cd503-ebb1-4ea6-8ead-6530f86ff429</trackback:ping>
      <pingback:server>http://www.sqlskills.com/blogs/paul/pingback.aspx</pingback:server>
      <pingback:target>http://www.sqlskills.com/blogs/paul/PermaLink,guid,af2cd503-ebb1-4ea6-8ead-6530f86ff429.aspx</pingback:target>
      <dc:creator>Paul S. Randal</dc:creator>
      <wfw:comment>http://www.sqlskills.com/blogs/paul/CommentView,guid,af2cd503-ebb1-4ea6-8ead-6530f86ff429.aspx</wfw:comment>
      <wfw:commentRss>http://www.sqlskills.com/blogs/paul/SyndicationService.asmx/GetEntryCommentsRss?guid=af2cd503-ebb1-4ea6-8ead-6530f86ff429</wfw:commentRss>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <font face="Verdana" size="2">
          <p>
In the last few classes I've taught, we've discussed the on-disk structures where
everything is stored in a database, and I've also been asked privately where all the
info is on my blog. I know that a lot of people reading my blog now are new in the
last six months or so and will have missed some of the earlier foundation info I posted.
Now, admittedly, there's a ton of stuff in my blog archive and most people have limited
time to go trawling through it, so I'll do a few posts that just list suggested reading
based on my posts.
</p>
          <p>
First up are on-disk structures - here are the posts to read:
</p>
          <ul>
            <li>
              <a class="TitleLinkStyle" href="http://www.sqlskills.com/blogs/paul/2007/09/30/InsideTheStorageEngineAnatomyOfARecord.aspx" rel="bookmark">
                <font color="#696969">Inside
the Storage Engine: Anatomy of a record</font>
              </a>
            </li>
            <li>
              <a class="TitleLinkStyle" href="http://www.sqlskills.com/blogs/paul/2007/10/03/InsideTheStorageEngineAnatomyOfAPage.aspx" rel="bookmark">
                <font color="#696969">Inside
the Storage Engine: Anatomy of a page</font>
              </a>
            </li>
            <li>
              <a class="TitleLinkStyle" href="http://www.sqlskills.com/blogs/paul/2007/10/03/InsideTheStorageEngineAnatomyOfAnExtent.aspx" rel="bookmark">
                <font color="#696969">Inside
the Storage Engine: Anatomy of an extent</font>
              </a>
            </li>
            <li>
              <a class="TitleLinkStyle" href="http://www.sqlskills.com/blogs/paul/2007/10/04/InsideTheStorageEngineIAMPagesIAMChainsAndAllocationUnits.aspx" rel="bookmark">
                <font color="#696969">Inside
the Storage Engine: IAM pages, IAM chains, and allocation units</font>
              </a>
            </li>
            <li>
              <a class="TitleLinkStyle" href="http://www.sqlskills.com/blogs/paul/2008/03/14/InsideTheStorageEngineGAMSGAMPFSAndOtherAllocationMaps.aspx" rel="bookmark">
                <font color="#696969">Inside
The Storage Engine: GAM, SGAM, PFS and other allocation maps</font>
              </a>
            </li>
            <li>
              <a class="TitleLinkStyle" href="http://www.sqlskills.com/blogs/paul/2008/07/11/SearchEngineQA20BootPagesAndBootPageCorruption.aspx" rel="bookmark">
                <font color="#696969">Search
Engine Q&amp;A #20: Boot pages, and boot page corruption</font>
              </a>
            </li>
            <li>
              <a class="TitleLinkStyle" href="http://www.sqlskills.com/blogs/paul/2008/07/25/SearchEngineQA21FileHeaderPagesAndFileHeaderCorruption.aspx" rel="bookmark">
                <font color="#696969">Search
Engine Q&amp;A #21: File header pages, and file header corruption</font>
              </a>
            </li>
          </ul>
          <p>
Have fun!
</p>
        </font>
        <img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=af2cd503-ebb1-4ea6-8ead-6530f86ff429" />
        <br />
        <hr />
This weblog is sponsored by <a href="http://www.SQLskills.com">SQLskills.com</a>.
(c) Paul S. Randal. This feed is for personal, non-commercial use.</body>
      <title>How the on-disk data structures fit together</title>
      <guid isPermaLink="false">http://www.sqlskills.com/blogs/paul/PermaLink,guid,af2cd503-ebb1-4ea6-8ead-6530f86ff429.aspx</guid>
      <link>http://www.sqlskills.com/blogs/paul/2008/09/08/HowTheOndiskDataStructuresFitTogether.aspx</link>
      <pubDate>Mon, 08 Sep 2008 04:31:48 GMT</pubDate>
      <description>&lt;font face=Verdana size=2&gt; 
&lt;p&gt;
In the last few classes I've taught, we've discussed the on-disk structures where
everything is stored in a database, and I've also been asked privately where all the
info is on my blog. I know that a lot of people reading my blog now are new in the
last six months or so and will have missed some of the earlier foundation info I posted.
Now, admittedly, there's a ton of stuff in my blog archive and most people have limited
time to go trawling through it, so I'll do a few posts that just list suggested reading
based on my posts.
&lt;/p&gt;
&lt;p&gt;
First up&amp;nbsp;are on-disk structures - here are the posts to read:
&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;a class=TitleLinkStyle href="http://www.sqlskills.com/blogs/paul/2007/09/30/InsideTheStorageEngineAnatomyOfARecord.aspx" rel=bookmark&gt;&lt;font color=#696969&gt;Inside
the Storage Engine: Anatomy of a record&lt;/font&gt;&lt;/a&gt; 
&lt;li&gt;
&lt;a class=TitleLinkStyle href="http://www.sqlskills.com/blogs/paul/2007/10/03/InsideTheStorageEngineAnatomyOfAPage.aspx" rel=bookmark&gt;&lt;font color=#696969&gt;Inside
the Storage Engine: Anatomy of a page&lt;/font&gt;&lt;/a&gt; 
&lt;li&gt;
&lt;a class=TitleLinkStyle href="http://www.sqlskills.com/blogs/paul/2007/10/03/InsideTheStorageEngineAnatomyOfAnExtent.aspx" rel=bookmark&gt;&lt;font color=#696969&gt;Inside
the Storage Engine: Anatomy of an extent&lt;/font&gt;&lt;/a&gt; 
&lt;li&gt;
&lt;a class=TitleLinkStyle href="http://www.sqlskills.com/blogs/paul/2007/10/04/InsideTheStorageEngineIAMPagesIAMChainsAndAllocationUnits.aspx" rel=bookmark&gt;&lt;font color=#696969&gt;Inside
the Storage Engine: IAM pages, IAM chains, and allocation units&lt;/font&gt;&lt;/a&gt; 
&lt;li&gt;
&lt;a class=TitleLinkStyle href="http://www.sqlskills.com/blogs/paul/2008/03/14/InsideTheStorageEngineGAMSGAMPFSAndOtherAllocationMaps.aspx" rel=bookmark&gt;&lt;font color=#696969&gt;Inside
The Storage Engine: GAM, SGAM, PFS and other allocation maps&lt;/font&gt;&lt;/a&gt; 
&lt;li&gt;
&lt;a class=TitleLinkStyle href="http://www.sqlskills.com/blogs/paul/2008/07/11/SearchEngineQA20BootPagesAndBootPageCorruption.aspx" rel=bookmark&gt;&lt;font color=#696969&gt;Search
Engine Q&amp;amp;A #20: Boot pages, and boot page corruption&lt;/font&gt;&lt;/a&gt; 
&lt;li&gt;
&lt;a class=TitleLinkStyle href="http://www.sqlskills.com/blogs/paul/2008/07/25/SearchEngineQA21FileHeaderPagesAndFileHeaderCorruption.aspx" rel=bookmark&gt;&lt;font color=#696969&gt;Search
Engine Q&amp;amp;A #21: File header pages, and file header corruption&lt;/font&gt;&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;
Have fun!
&lt;/p&gt;
&lt;/font&gt;&lt;img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=af2cd503-ebb1-4ea6-8ead-6530f86ff429" /&gt;
&lt;br /&gt;
&lt;hr /&gt;
This weblog is sponsored by &lt;a href="http://www.SQLskills.com"&gt;SQLskills.com&lt;/a&gt;. (c) Paul S. Randal. This feed is for personal, non-commercial use.</description>
      <comments>http://www.sqlskills.com/blogs/paul/CommentView,guid,af2cd503-ebb1-4ea6-8ead-6530f86ff429.aspx</comments>
    </item>
    <item>
      <trackback:ping>http://www.sqlskills.com/blogs/paul/Trackback.aspx?guid=51f2f9cc-e40b-40e5-a10b-95e9b35cac00</trackback:ping>
      <pingback:server>http://www.sqlskills.com/blogs/paul/pingback.aspx</pingback:server>
      <pingback:target>http://www.sqlskills.com/blogs/paul/PermaLink,guid,51f2f9cc-e40b-40e5-a10b-95e9b35cac00.aspx</pingback:target>
      <dc:creator>Paul S. Randal</dc:creator>
      <wfw:comment>http://www.sqlskills.com/blogs/paul/CommentView,guid,51f2f9cc-e40b-40e5-a10b-95e9b35cac00.aspx</wfw:comment>
      <wfw:commentRss>http://www.sqlskills.com/blogs/paul/SyndicationService.asmx/GetEntryCommentsRss?guid=51f2f9cc-e40b-40e5-a10b-95e9b35cac00</wfw:commentRss>
      <slash:comments>2</slash:comments>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <font face="Verdana" size="2">
          <p>
Well, it's been a year since I left Microsoft (8/31/07) to join Kimberly running SQLskills.com
- and what a blast it's been!
</p>
          <p>
From 8/31/07 to 8/31/08 I've:
</p>
          <ul>
            <li>
Had one front-page article in TechNet Magazine 
</li>
            <li>
Written two whitepapers 
</li>
            <li>
Presented at 4 conferences 
</li>
            <li>
Taught in 5 countries outside the US 
</li>
            <li>
Taken 39 flights (still 18 more to go in 2008...) 
</li>
            <li>
Posted 182 blog posts 
</li>
            <li>
Had more than a million hits on my blog!! (actually way more... 1,305,717)</li>
          </ul>
          <p>
The last one's awesome - I love blogging stuff and it's really cool that so many people
read what I write. Thank you all for all your comments and support over the year.
I wonder how many of those numbers I can better over the next year?
</p>
          <p>
Cheers!
</p>
        </font>
        <img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=51f2f9cc-e40b-40e5-a10b-95e9b35cac00" />
        <br />
        <hr />
This weblog is sponsored by <a href="http://www.SQLskills.com">SQLskills.com</a>.
(c) Paul S. Randal. This feed is for personal, non-commercial use.</body>
      <title>One year on...</title>
      <guid isPermaLink="false">http://www.sqlskills.com/blogs/paul/PermaLink,guid,51f2f9cc-e40b-40e5-a10b-95e9b35cac00.aspx</guid>
      <link>http://www.sqlskills.com/blogs/paul/2008/09/03/OneYearOn.aspx</link>
      <pubDate>Wed, 03 Sep 2008 11:35:25 GMT</pubDate>
      <description>&lt;font face=Verdana size=2&gt; 
&lt;p&gt;
Well, it's been a year since I left Microsoft (8/31/07) to join Kimberly running SQLskills.com
- and what a blast it's been!
&lt;/p&gt;
&lt;p&gt;
From 8/31/07 to 8/31/08 I've:
&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
Had one front-page article in TechNet Magazine 
&lt;li&gt;
Written two whitepapers 
&lt;li&gt;
Presented at 4 conferences 
&lt;li&gt;
Taught in 5 countries outside the US 
&lt;li&gt;
Taken 39 flights (still 18 more to go in 2008...) 
&lt;li&gt;
Posted 182 blog posts 
&lt;li&gt;
Had more than a million hits on my blog!! (actually way more... 1,305,717)&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;
The last one's awesome - I love blogging stuff and it's really cool that so many people
read what I write. Thank you all for all your comments and support over the year.
I wonder how many of those numbers I can better over the next year?
&lt;/p&gt;
&lt;p&gt;
Cheers!
&lt;/p&gt;
&lt;/font&gt;&lt;img width="0" height="0" src="http://www.sqlskills.com/blogs/paul/aggbug.ashx?id=51f2f9cc-e40b-40e5-a10b-95e9b35cac00" /&gt;
&lt;br /&gt;
&lt;hr /&gt;
This weblog is sponsored by &lt;a href="http://www.SQLskills.com"&gt;SQLskills.com&lt;/a&gt;. (c) Paul S. Randal. This feed is for personal, non-commercial use.</description>
      <comments>http://www.sqlskills.com/blogs/paul/CommentView,guid,51f2f9cc-e40b-40e5-a10b-95e9b35cac00.aspx</comments>
      <category>Personal</category>
    </item>
  </channel>
</rss>