SkyDrive integrates very nicely with Windows 8. More on that later. First, let’s discuss using Windows 8 x64 on VirtualBox. Since I wanted to test with x64 and didn’t have a Hyper-V server available, I used VirtualBox. The latest version of VirtualBox does list Windows 8 as a guest operating system choice. The first time I attempted the installation, I chose the experimental Direct3D graphics support. That didn’t work well. After what seemed like FOREVER looking at a completely black screen, I decided the experimental Direct3D graphics and Windows 8 Consumer Preview were not a good combination, so I reinstalled Windows 8 from scratch leaving that option uninstalled. Depending on when you actually read this post, it might work just fine. Eventually both Windows 8 and VirtualBox Direct3D will probably be compatible.

Figure 1. Leave the Direct3D Support (Experimental) unchecked.

I keep all of my SQL Saturday presentations and MVP Deep Dives files on SkyDrive. Windows 8 integrates with SkyDrive seamlessly. As a full-time nursing student, I also keep all of my school files on SkyDrive. I think both working professionals and students will like the seamless integration of cloud storage with Windows 8. Here’s what it looks like:

Figure 2. SkyDrive application in Windows 8 CTP.

Notice that it says John’s SkyDrive. During the installation process, I was prompted for my Windows Live ID, which is my Hotmail address. That is my login to the Windows 8 machine. Windows 8 clearly has the cloud baked in.

One thing that immediately caught my attention was that even though I hadn’t installed any applications, my pdf files were viewable. The Microsoft Reader is preinstalled and reads pdf files. That’s quite convenient. Office documents were of course readable with the Office Web Apps. Next, Office 2010 was installed to view the SkyDrive documents in local Office programs. Although Office 2010 with all programs and features was installed, the Office Web Apps couldn’t detect that Office 2010 was actually installed. I filed this bug report: http://answers.microsoft.com/en-us/windows/forum/windows_8-winapps/skydrive-not-detecting-powerpoint/dcabc763-5b5a-424a-a050-461a80b3899f

Also, I didn’t like the usability of closing a SkyDrive document and not returning back to the SkyDrive application. Instead, I returned to a SkyDrive web page in IE. I filed this item: http://answers.microsoft.com/en-us/windows/forum/windows_8-winapps/skydrive-and-closing-office-web-apps/7832f1c5-5599-4a46-b428-49d98165d0c5

Unrelated to SkyDrive, I found that a rare and obscure bug in Windows 7 is still a bug in Windows 8. This bug report was filed: http://answers.microsoft.com/en-us/windows/forum/windows_8-files/windows-7-unzip-bug-still-in-windows-8/eee093ff-1dd1-4e50-ae99-a084172326fe

I didn’t find any major problems and definitely liked what I saw. SkyDrive will be much more useful to more people when Windows 8 is used.

Finally, the Betta splendens fish from the Windows 7 beta is back. I was expecting 8 bubbles to the 7 bubbles in the Windows 7 beta, but didn’t see what I was expecting. I looked a second time. Two of the bubbles are joined to form an 8.

Figure 3. Windows 8 Consumer Preview default desktop.

Is your SQL Server running slower than you’d like? Is it your SQL Server configuration or your slightly old hardware? We need to use tools to gather information.

My subjective impression is that my 2.2 GHz laptop outperforms my 3.0 GHz overclocked desktop in CPU bound tasks. Both are quad core machines. The desktop has a first generation quad and the laptop has a second generation quad core processor. To introduce objectivity, PassMark’s Performance Test was used to benchmark the two machines.

If you look under CPU Mark, you can see that the laptop’s second generation 2.2 GHz processor significantly outperforms the desktop’s first generation 3.0 GHz processor. The point here is that stated processor speeds aren’t everything. Comparing clock speeds from one generation of processor to another or from AMD to Intel is like comparing apples to oranges. We can drill down into the processor details and see where the differences are.

If you look under Disk Mark in the first screen capture, you can see that the laptop’s SSD is rated as being faster than the desktop’s 7200 rpm hard drive. Drilling down into the details indicates that the SSD’s advantages aren’t as pronounced for sequential reads.

It’s wise to periodically benchmark hardware. At a client site a few years ago, I used Performance Test to trace a performance problem back to the hardware. Before doing extensive performance tuning of a SQL Server, make sure that the hardware isn’t the culprit. You can’t tune away hardware problems.

Microsoft upped the level of service for my SQL Azure account. I can think of things I’d like to do, but there isn’t any point with Comcast as my ISP. This is the problem with cloud based services – the ISP is the weak link. I can make a PowerPoint slide of a grand plan, but it is all for naught when connectivity can’t be taken for granted. My connection speed has dropped from 30++ mbps to under 5 mbps while my monthly bill has gone up. It took over half an hour of my lost time for Comcast to suggest sending out a technician. The issue was not resolved because I literally ran out of available free time to continue the discussion.

I think cloud based solutions are great in theory, but not so great when implemented in the real world. ISPs act like utilities, but have nowhere near the level of service reliability gas and electric utilities are known for.

Office applications and SQL Server Management Studio (SSMS) handle superscripts and subscripts differently. Office apps such as Word allow you to assign font properties to make a character appear superscripted or subscripted. SSMS doesn’t support font properties, but Unicode does provide special characters for common superscripting and subscripting symbols.

Before you get the green light to build that SQL Server database, you’ll first have to make a compelling case for it using Word or PowerPoint. You want your proposal to look slick, full of superscripts, subscript, and Greek math symbols. That’s where we’ll start. Consider the following:

water is H20 and it boils at 100 C

That’s not very impressive. We can subscript the 2 by selecting it and right-clicking to bring up the Font dialog box. Select Superscript or Subscript to make your formatting change.

Figure 1. Font dialog box in Office applications.

If you have a lot of subscripting and superscripting to do, using the Font dialog box to do the formatting takes too long. It’s faster and simpler to use keyboard shortcuts. Highlight the character(s) of interest and use Ctrl = to subscript, Shift Ctrl = to superscript. Just so there is no confusion, = is the key on which both + and = appear. (It’s possible someone may prefer to describe Shift Ctrl = as Ctrl + using the logic that Shift = is the same thing as the + key.)

But even with the subscripting done, we’re still not fully done. We need the degree symbol. I did a search using Unicode degree symbol as my search string and discovered that it is the Unicode character that is hexadecimal 00B0. I find that it is faster to search for the hex code using a search engine instead of bringing up the dialog box that shows all of the Unicode character set and scrolling until I see what I need.

Once you know the hex value for the symbol you need, go to the Insert tab in Word and then select Symbol. Use the Symbol dialog box to enter the hex value for the symbol of interest.

Figure 2. Select More Symbols… to specify your symbol by its hexadecimal value.

Figure 3. Enter the hexadecimal value for your symbol into the Character code box.

Now your text looks quite professional and complete (although a scientist would feel compelled to mention STP).

water is H₂0 and it boils at 100° C

To add subscripting, superscripting, and special characters in SSMS strings, string concatenation using the NCHAR function is necessary.

Figure 4. Building strings with the NCHAR function.

SELECT N'H' + NCHAR(0x2082) + N'O';

SELECT N'Ca' + NCHAR(0x207A) +  NCHAR(0x207A);

SELECT N'E = mc' + NCHAR(0x00B2);

SELECT N'98.6' + NCHAR(0x00B0) + N'F';

SELECT NCHAR(0x03B2) + N'-blocker';

SELECT N'X ' + NCHAR(0x2265) + N' 6.0221415 * 10' + NCHAR(0x00B2) + NCHAR(0x00B3);

Try the preceding strings for yourself. The inverse of the NCHAR function is the UNICODE function, which returns a decimal value. You can use either decimal values or hexadecimal values with the NCHAR function. I showed mostly hexadecimal examples because I think you’ll most often find hex values when you are looking up the numeric value of a Unicode special character.

Figure 5. Working with decimal values.

SELECT UNICODE(N'₂');

SELECT N'H' + NCHAR(8322) + N'O';

NOTE: Some of the code samples may not render correctly depending on the capabilities and settings of your browser. Thanks to my fellow SQL Server MVPs Greg Low and Rob Farley for technical assistance in writing this post.

Using Unicode characters for superscripting and subscripting is particularly useful when markup languages can’t be used, such when posting in some social media platforms.

I previously posted how to add a medical dictionary to Word 2010. It’s a simple matter of copying a file and adding it to Word. Although the concept is the same with Word 2011 on a Mac operating system, implementation on a Mac requires some additional effort. For those of you who aren’t Mac power users, I’ve provided screen captures detailing the tricks you must know to achieve success.

The file you need is downloaded from here where where I posted how to add a custom dictionary to Word 2010 on Windows 7. Scroll almost to the bottom of the post and right-click the OpenMedSpel100.zip link to open the download menu. Select the Download Linked File As option.

Figure 1. Right-click the link and select Download Linked File As.

Next, you must specify a file name and location for the dictionary file. You can use any file name and location. I chose en_US_OpenMedSpel100 for the file name and the Microsoft Office 2011 folder for the location.

Figure 2. Under Favorites, select Applications, then select Microsoft Office 2011. Provide a meaningful name for the file (I used en_US_OpenMedSpell100) and click Save.

You will need to navigate to your Microsoft Office 2011 folder and open the downloaded zip file to extract the dictionary file. You can do this by opening your Documents folder, then selecting Applications, and finally selecting Microsoft Office 2011. You can delete your zip file after extracting its contents if you want to keep your folders neat and clean.

Figure 3. Navigate to the Microsoft Office 2011 folder and open the zip file.

Go to Word’s menu and select Preferences as shown.

Figure 4. Select and open Word’s Preferences menu.

Figure 5. Select Spelling and Grammar on the Preferences dialog box.

Figure 6. Click the Dictionaries button on the Spelling and Grammar dialog box.

Figure 7. Click the Add button to add the custom dictionary.

Figure 8. The dictionary file appears but is not selectable. Select All Files to make it selectable.

Figure 9. Select your custom dictionary file and click the Open button.

Figure 10. Click OK to finish adding the custom dictionary file.

If you try typing anything in PowerPoint 2010 running on Windows 7 installed in Boot Camp, PowerPoint may abort. The first time I installed Windows 7 on my MacBook Pro, PowerPoint 2010 worked just fine. But the second time was a disaster. PowerPoint aborted every time I tried to type anything. The fix is easy and is detailed in the screen captures shown below. You have to specify a keyboard layout to resolve this issue.

I do not know why the first installation was fine and the second was not, but I am willing to speculate. The first time the Office 2010 suite was installed using defaults. The second time a custom installation was done and all features were installed. I do not know if that difference caused the problem, but in the interest of full disclosure, I thought you should know.

Figure 1. PowerPoint 2010 aborted on Windows 7 installed on a MacBook Pro.

Figure 2. Windows did not notify me of a solution.

Figure 3. Go to File and then select Options.

Figure 4. Select Language and then click the Not enabled hyperlink. The problem is caused by not having a keyboard layout specified.

Figure 5. Click the Add button.

Figure 6. Select an appropriate keyboard. Click OK.

Figure 7. Problem solved. Click OK.

PowerPoint’s find feature is limited because it works on only a single file at a time and I need to search groups of files. There is a simple, high value search capability available in Adobe Reader X that I’m using to search PowerPoint files. All I had to do was open the PowerPoint files with Office 2010/2011 and save them as pdf files. Using the advanced find feature in Adobe Reader X makes it easy to find a word in a group of files. I’m using this technique to prepare for final exams as I study the PowerPoint slides from nursing school lectures.

I’ve also loaded my PowerPoint slides in SQL Server Denali with semantic search enabled and will investigate that after finals are over.

Step 1

Put all of the PowerPoint files you want to search in a separate folder. This isn’t technically required, but I did find it easier to have one folder per course.

Step 2

Open each PowerPoint file and save as pdf.

Step 3

Open any of the pdf files. Select Advanced Search or use Shift+Ctrl+F to go right to it.

Step 4

Select All PDF Documents in and browse to the folder containing your pdf files. Click the Search button.

Step 5

Find the item of interest in the search results. Notice that the results are hyperlinks. Click a hyperlink to be taken directly to the slide where the search term was found.