Tomorrow, Saturday October 6th I will be presenting “Getting Started with Full Text Searching”. Here are the materials I’ll be using during the demo.
First, here is a PDF of the PowerPoint slides:
Full Text Search Power Points
Next, most of the demos used SQL statements. This PDF file has all of the SQL plus some associated notes.
Full Text Search Demo Scripts
Finally, I did a WPF project that demonstrated how to call a full text search query from a WPF Windows application. Annoyingly enough WordPress (who hosts my blog) won’t let me upload ZIP files, so I renamed the extension to pdf. After you download the file to your drive, remove the .pdf and put the zip extension back on, then it should expand all the source for you correctly. (Yes, I know, I really need to get a host server for binaries, one of these days I’ll get around to it, but for tonight…)
Source for WPF Demo
Holy Frameworks Batman! The news is spreading quick, Microsoft has announced that they will be releasing the source code, complete with comments and debugger support. Now you and I will be able to step into those framework classes in an effort to debug our apps and maybe even learn something. This will be part of the VS2008 Orcas release.
Check out the announcement on the ScottGu blog at
Shawn Burke has details on his blog:
Channel 9 video at:
Scott Hanselman also has the scoop on his podcast:
This ranks in the uber-cool category.
In reviewing my previously published notes on SQL Server Full Text Searching, I realized I omitted an important fact: which versions support it. If you wish to explore Full Text Searching under SQL Server 2005, you cannot use the standard SQL Server Express Edition.
The standard version of Express Edition lacks support for Full Text Searching, along with Reporting Services. Instead you will need to download and install the SQL Server 2005 Express Edition with Advances Services. This version includes everything you’ll need to experiment and implement Full Text Searching with SQL Server 2005.
You can download this version from Microsoft’s website:
Just look for the area named SQL Server 2005 Express Edition with Advanced Services SP2.
You need to be aware that even with the Advanced Services SP2 version, Full Text Searching is not automatically installed. During the install uncheck the box that talks about hiding advanced configuration features. Then on the appropriate screen change the installer to add FTS to your installed components.
For my previous posts on Full Text Searching, please check out the Arcane Lessons link at the top of this page. Scroll down to the Full Text Search area for links to all FTS related posts.
I just got done updating the Arcane Lessons page. I added the last couple of weeks of WPF lessons to the WPF area, added one new item to the SQL Server Full Text Search area, and created a new category: Arcane’s Toolbox. This first list is all of the Visual Studio add-ins I’ve blogged about. Later I plan to add some of my favorite Windows add-ins, but if you don’t want to wait you can click on the Windows Add-ins tag to see the posts.
Yes, it’s true, I just found out my friend and coworker Jeff W. Barnes was awarded MVP for 2008. Way to go Jeff! I know you’ve worked hard and richly deserve it.
Read more about it at his blog:
Did someone say WCF???
I spent a few minutes yesterday evening relaxing and activating the voice recognition features of Windows Vista. While I still have a good learning curve, it seems like this can be a really useful tool. I would suggest however that you should definitely go through the tutorial if you wish to use it for yourself.
It is also going to take time for you to learn the commands and the ins and outs of speech recognition, just as it is going to take vista time to learn your voice.
So far I have found that some programs, such as Microsoft Word, seem to work pretty well. Other programs, such as Firefox, don’t seem to hold up. In Firefox I found that dictation did not really work well at all. For those cases it might be easier to keep a copy of notepad open, dictate into it, then cut and paste.
By the way, I created this entire post using speech recognition. I admit it was a little frustrating but as I have worked through it, and gotten a little more proficient with the commands, it has gotten easier.
I spent my weekend learning Silverlight, writing a game in Silverlight 1.0. I did all of my project in Visual Studio 2005 and using Silverlight 1.0 runtime. It’s a pretty simple game, I’ll reveal more later in the week and eventually post all the code and blog about the development experience.
If you are want to look into Silverlight coding, I highly recommend you go to the Getting Started site on Silverlight’s website. http://silverlight.net/getstarted/Default.aspx
After you download all the bits, go to the very bottom of the page under “3. Learn from Samples and Documentation”. Go read all the QuickStarts!!! Very good code samples here to get you started.
After you go through the code samples, there are some really good focus videos at http://silverlight.net/Learn/learnvideos.aspx . These helped me over quite a few hurdles.
The documentation was also very helpful in looking up how some properties worked, going back and forth between Java and Xaml. http://msdn2.microsoft.com/en-us/library/bb188743.aspx
There will be more to come on this subject to be sure, but over the next few days I’ll be preparing my presentaion for Alabama Code Camp 5 on SQL Server 2005 Full Text Searching,