Skip to main content

Pragmatic TSQL Programmer

Go Search
Home
  

Pragmatic TSQL Programmer > Categories
I'm ready for the Zombie Apocalypse!
Twitter SharePoint Web Part

FYI – the new SharePoint web part on the right was created from this post by Michael Gannotti. Giving credit where credit is due. . .

Entering the Twitter-verse

I finally was dragged kicking and screaming into starting to Twitter. Follow me here: http://twitter.com/greg_wilson. If anyone has any great ideas on how to organize the twitter chaos, I am all ears. I know there are lots of twitter add-ons, and I'd love to know if any of them are worth using.

It's official
Not only is SQL 2008 RTM, but I'm a genious!
 
 
I am 12% Idiot.
Friggin Genius
I am not annoying at all. In fact most people come to me for advice. Of course they annoy the hell out of me. But what can I do? I am smarter than most people.
Back 2 Blogging

I realized it has been a while since my last post, but I figured it would be a great time to get back to adding some new content. Last week I wrapped up an 18+ month contract with Wells Fargo and on Monday I am starting a new full time position with Ontuet doing some pretty interesting work with the supply chain of the hardware industry. The workplace looks pretty interesting and I'm looking forward to working with them on their upcoming projects. They are small Microsoft shop with a pretty tight-knit group of employees and a casual environment. I've got several other posts that I will probably get up in the next few days. I've got some cool info on some local code camps and other stuff that I've been working on.

Iowa State Cyclones Beat Iowa Hawkeyes

Just thought I'd make sure to publicize the fact that, once again, the Iowa State Cyclones (who came in as 17.5 point underdogs) defeated an over-confident squad of Iowa Haweyes 15-13. Watching the game, the game was not nearly as close as the score indicated. The Cyclones dominated most every statistic, and the Hawkeye linemen were getting pushed all over the field at the whim of the Cyclones. More details here.

A Hawkeye friend of mine said, "But next year we'll beat you for sure!" To which I replied, "If you do, and you beat us again the next year, and the next year, and the next year after that, the Hawkeyes could get back to 500 since '97!" 'Nuff said.

Not SQL related, but I couldn't help it.

Who is this blog written for?

This Blog is written for .NET programmers who are out in the trenches writing applications that run against Microsoft SQL Server. If you are an academic who wants to start a holy war on the “proper” way for a database to support XML or on the obscure details of which database generates the “best” execution plans for queries, this is not the place for you. This place is how to answer real world questions about producing business value with .NET and TSQL. Got questions? Bring ‘em on. I’ll do my best to answer them.

What is my background?

I am not a DBA. I haven’t worked with SQL since before Microsoft bought it from Sybase. I don’t daydream about manually tweaking indexing schemes on databases. I’m a .NET programmer (mostly C#). I work on real projects as a consultant to real companies and don’t live in an Ivory tower. I get paid to crank out business value in a .NET/TSQL environment. While I working with C# a lot, I’ve realized that a whole lot of the “magic” I deliver to my clients is more related to TSQL than .NET coding. The database is often the center of an application. And, correspondingly, I’ve often discovered that the weakest part of many .NET programmers’ skill sets is their ability to effectively use TSQL in a way that delivers business value. So, I plan to take this Blog space to help other .NET coders learn to better use TSQL.

In other words, I'm a guy, out in the trenches who loves do deliver value with SQL Server.

The most painful blog post ever
This post is the product of over 5+ weeks of pain and tedium. Why? Because that is how long the nightmare of installing the blog software on my system took.

Let's start back at the beginning at the end of February 2007.

Because Mike Benkovich promised the crowd at a launch event that the free SharePoint Services 3.0 had a really easy to use and setup Blog functionality, I decided to give it a whirl. Shouldn't be hard, should it? I'm an experienced developer and have installed tons of web software in my day, and maintained numerous web servers. Plus it is a Microsoft product, so I assumed it would work fairly well out of the box.

Not knowing how wrong I was, I began undertaking the most painful installation I've ever done. A rough recap of the recent weeks:

1) Install sharepoint server 2007 from my MSDN subscription. Futz around trying to figure it out.
2) Discover after a week of frustration that the reason I couldn't get anything to work was because the Central Administration Website failed to install correctly. Any attempt to use it would throw Out of Memory Exceptions.
3) Uninstall and reinstall sharepoint server 2007. Discover that now ASP.NET will not function on my server. All ASP.NET pages simply throw an Out of memory Exception upon startup.
4) Completely uninstall Sharepoint 2007, IIS, ASP.NET and the .NET frameworks. Reinstall them all with all modern patches. Discover that IIS is still hosed and unworkable.
5) Swallow hard and realize that the next step is to reformat my server. It is my only server in my home environment, so it has all the DC, SQL, file sharing and IIS roles that need to be preserved.
6) Build a VM on my development machine and install W2K3R2, patch it and promote it to DC.
7) Move the DC roles over to the virtual machine and backup the OS partition of my server.
8) Reinstall W2K3R2 on the server. Patch, Add SQL, Patch, Promote to DC, Install Sharepoint 2007. Begin setup
9) Discover that the MSDE instance that Sharepoint installed hurled and got stuck in an un-uninstallable state. Excited to find that the KB article on MS about how to "manually" uninstall a SQL instance relies upon the automatic uninstaller. Real bright, SQL Team. Ever think that the reason I was trying to manually uninstall it was that THE AUTOMATIC UNINSTALLER ISN'T WORKING?!?!?!?
10) Reformatted server AGAIN. Reinstalled 2003R2 AGAIN. Patched AGAIN. Installed it all AGAIN.
11) Went through the entire setup process of manually installing Sharepoint so that it would point to my SQL 2005 instance instead of installing MSDE.
12) Discovered that this installation of sharepoint somehow failed to create an actual web site in the root location.
13) Uninstalled and reinstalled Sharepoint 2007 AGAIN 14) Finally got a (mostly) working installation
15) Realized that it absolutely refused to allow anonymous authentication on any of the sites. (I'd had this issue several times already, but figured I'd spare you the details.)
16) Contemplated going postal.
17) In a fit of desparation, I sent an SOS message to an old acquaintance from here in Ames, IA, Todd Klindt, who luckily enough, happens to be an outstanding Microsoft SharePoint MVP who was kind enough to give me a call and take a look at the installation.
18) After an hour or so of free tech support from Todd (man, I owe you, Todd) we declared the whole thing FUBARed, and came up with the plan that finally worked: Stop using the full blown SharePoint 2007, and just use the free, base level Share Point 3.0 and isolate the web server by building a VM inside my server with nothing but IIS and Sharepoint on it.
19) Created the virtual machine. Installed OS, patched. Installed base-level free sharepoint services 3.0. Configured.
20) When I saw that it worked, I began spontaneously screaming the Alleluia chorus at the top of my lungs. The ordeal was over.