Devs and Data Dudes Oh My!

Microsoft has made a big announcement regarding the next version of Visual Studio, Visual Studio 2010. Among other welcome news is that the Developer Edition and Database Editions of Team System will be merging into a single product. This is great news for folks like me (and I suspect many developers) who do a lot of work on both the database side as well as the application side.

The really great news though is that we don’t have to wait for 2010 to take advantage of this. As part of the announcement Microsoft said that effective October 1st, 2008 people who are MSDN Licensed for the 2008 (or 2005) version of Visual Studio Team System Developer will now have access to the Database version, and vice versa.

Database Edition has some great features. One of the ones I use the most is the database comparison tool. It lets me compare data in one database with another and get them into sync. This is great for keeping my local development database that sits on my computer identical with our production system.

I’m sure Database Edition will be new to many developers, so I’d like to mention to books that will help you get up and running with “Data Dude” (as Database Edition is often called).

masteringvstsde The first I have mentioned before, it is SQL MVP Andy Leonard’s Mastering Visual Studio Team System Database Edition Volume 1. This is a great book that focuses exclusively on the database edition. It’s a great resource and one of my favorite books on the subject, I can’t wait for the next volume to come out.





apressprovsts The other book is from APress, Pro Visual Studio Team System with Team Edition for Database Professionals. This book covers all aspects of VSTS, including the database tools. I think too often we make life harder on ourselves than we have to, if we took some time to learn the tools available to us, we could be much more productive. I’ve found this book to be a good aid to help me do just that.

MSDN Southern Fried Roadshow Comes To Alabama

bucketsmall Since there are so many events coming to Alabama, we decided to create an uber-post listing them all! MSDN Southern Fried Roadshow – September Edition The MSDN Southern Fried Roadshow is a half day free developer event with a southern flair, where you will learn about some of the latest developments in Microsoft technologies. For September, 2008 the Roadshow will be presented by Architect Evangelist Chad Brooks and Developer Evangelist Glen Gordon. Chad and Glen will be loading up a minivan with lots of goodies, and trying to hit 5 cities in 5 days. We’ll start the morning with a quick update on a variety of developer topics. The we’ll spend the rest of the morning exploring the impact that REST has had on solutions architecture and the Microsoft Technologies that you need to leverage it. Every attendee will receive an MS Press book (while supplies last) as well as pointers to tons of resources for further learning. Register today using the links below. We’re trying to finalize the last cities, so check back for more.

Join our Facebook group! Come join our Facebook group and stay up to date on our travel adventures. Chime in with questions or comments, or just cheer us on. Resources Stay tuned for links, downloads and more about the topics we’ll be presenting on. Agenda Microsoft Developer Update First, we will do a survey of the set of just-released products and how they will impact developers. See what’s new in Windows Server 2008: Hypervisor Technology, IIS7, and others. SQL 2008 is also packed with goodies for Developers; see the geospatial capabilities as well as the LINQ enhancements. And don’t forget the myriad of enhancements that come with the .Net Framework 3.5! REST with WCF, ADO.NET Data Services, and ASP.NET MVC The evolution of the web has seen many changes in patterns and standards for working with services. In a world of AJAX and other lightweight clients, not all services need to be implemented with the bells and whistles that SOAP and its many specifications allow for. And not all services need to be “transport-neutral”. An alternative architectural approach known as REST is well suited for many web-based scenarios. You can implement a RESTful architecture using a variety of current and future Microsoft technologies. But how do you decide which ones are the best choices for your scenarios? These sessions of technical deep dives helps to answer that question. We will examine implementing RESTful services with WCF 3.5, using ADO.NET Data Services, and introduce the ASP.NET MVC framework.


MSDN Southern Fried Roadshow MSDN Southern Fried Roadshow

My Dev Kit

There’s a new meme of sorts on the web, folks talking about the tools they use to develop with. I first saw it on Shawn Wildermuth’s blog. Shawn’s a great guy, he co-wrote most of those .Net MCTS/MCPD study guides from MS Press, and does a lot of training on Silverlight. So I thought I would keep the meme alive and talk about my own tools.


I do a lot on the road, so a laptop is essential. Mine’s getting up there in age, it’s an HP Pavillion dv8000. 2 gig ram, two internal 160 gig hard disks, 17 inch wide screen, single core 64 bit processor. It’s OK, but will hopefully get replaced next year with something with more cores and horsepower. I don’t care much for the keyboard, so I bought an external keyboard from Lenovo. It’s got a trackpoint so I don’t have to take my hands off the keyboard very often, and I use it with both my laptop and the Dell that work supplies me.

At home I use a larger wireless Microsoft mouse, on the road I use one of the smaller Microsoft travel mice. Also in my hardware list is an external Seagate 1TB drive. It hooks up via either firewire or USB, which is nice when my USB ports are all full.

Also in my list is my Zune. Yes my Zune. Cubical farms can get noisy at times, some good tunes on my Zune really help me to zone out and ignore my surroundings, focusing on my code. It’s also nice on my commute or daily walk, I listen to podcasts to keep up my technical knowledge. At night I hook it to my TV via my X-Box 360 to watch video podcasts, or sometimes I lay in bed before going to sleep and watch.

My final piece of hardware is my iPaq, it helps keep my appointments in line and my contacts, plus I have lots of e-books loaded on it for reading. I also used to use it for podcasts prior to getting my Zune.

Operating System and Dev Tools

My laptop currently runs 32 bit Vista Ultimate with Service Pack 1. Since it maxes out at 2 gig, and some 64 bit drivers were not available when Vista first arrived, I saw no benefit to 64 bit and took the path of least resistance. I have quite a few virtual machines in a variety of OS (Server 2008, 2003, XP, Vista, and Ubuntu) for testing, development, and running Beta versions of programs. For a web browser, I bounce back and forth between FireFox and IE7. For a while I was using FF most of the time, but IE7 was a big improvement over 6, and I’m now using them about 50/50. I suspect when IE8 comes out I may be using it more, but will have to see.

Like Shawn I also use Outlook 2007 for my e-mail client. It’s so much easier to organize my mail in Outlook than the g-mail host. But I also use the other features, such as the calendar and task list to help manage my life. I also use the rest of the Office suite for my daily tasks.

I use SnagIt for grabbing still screen captures, awesome tool, and Camtasia for video screen captures. I’m working on several video tutorials now, which is fun but time consuming (which also explains while my blog posts have been off of late). I use Paint.Net for basic photo / image editing. For creating my blog posts, I write them originally in Word 2007, then use Windows Live Writer to post them to my blog.

For quick access to my daily programs, I use one of two things. I really like Bayden Systems SlickRun. I also create a shortcut menu using a technique I blogged about in February.

Developer Tools

As you might expect I use both SQL Server Management Studio and Visual Studio 2008 Team System for day to day development. My top add-ins are Red-Gates SQL Prompt bundle for SSMS and CodeRush for Visual Studio. For a text editor, I absolutely love UltraEdit. Since I have blogged a lot about my dev tools in the past, I will keep this section short.

The Cloud

I’m on a couple of social networking sites, in addition to this blog:

· Twitter

· Posterous

· LinkedIn

· MSDN Code Gallery – One site for SQL Server Full Text Searching and one for SQL Server Compact Edition.

Passing the Baton

OK, your turn, let’s see your blog with your tools!

SQL Server 2008 RTM!

It’s here it’s here! SQL Server 2008 RTM is now on MSDN. I’m downloading it now. Only downside, to use Visual Studio 2008 with it you need VS2008 SP1, and that hasn’t released yet. So be cautious if you install and desire to use VS2008 with it.

Deep Fried Debugging

I was listening to the current episode of Deep Fried Bytes and was reminded of an important lesson. In case you haven’t heard of it, Deep Fried Bytes is a relatively new but very good development podcast. I highly recommend the podcast, it’s become a favorite on my Zune.

The hosts, Keith and Woody were interviewing members of the support team. Yes, the guys who keep the actual website up and running. Keith Woody asked them about a really challenging problem they hand, and one of the team recounted the tale of a site that had been in production about a year, when performance suddenly tanked. Naturally they went through the standard debugging questions, including “has anything changed in the code?” Since nothing had, they said “oh, well can’t possibly be the code” and went on to look at other things.

They went on to look at other things before finally, in desperation, coming back to the code. It turned out there was a scalability bug that had been there since day one, buried deep in a stored procedure. The select statement inside the stored proc caused a table scan. Not so bad when there were few records but after being up for a year the number of records was bogging down the stored proc.

I have been on many projects where a developer insisted the bug couldn’t possibly be in the code as it’s been running “perfect” and no recent changes have been made. The lesson to learn is never to rule out anything when looking for bugs. True, you should start with the most likely suspects, if no changes have been made to code then the probabilities of it being code are low as compared to say a hardware issue, but don’t rule it out completely. Get the entire team working in parallel. Let the developers look at the code, the DBAs at the database, admins at the server and network, and so on. Through teamwork, and being open to all possibilities you can achieve some deep fried debugging.

The SQL Server Developer

This is a subject I’ve been thinking about for quite a while; perhaps others are drawing similar conclusions. I may even be late to the game, but if so I haven’t seen it discussed on the blogs or podcasts, and I keep up with these pretty regularly. After a lot of consideration, I’ve decided there is a new type of IT professional, the SQL Server Developer, of which I consider myself one.

Let’s start out with a basic definition. What is a SQL Server Developer? In my mind they fall into two categories. The first is the developer who works with the SQL Server Business Intelligence (SSBI) tools, namely SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), or SQL Server Analysis Services (SSAS). The second is the type of developer who works in the server end, developing stored procedures in both T-SQL and CLR, scripts, designing tables and views, and other tasks not centered on the day to day activities around the actual running of the Server itself. In many organizations these two areas are covered by the same person.

So what has caused this new breed of IT professional to emerge? Two reasons as I see it. First is the introduction of SQL Server 2005 itself. It brought along a new flood of tools, many outside the experiences of the typical DBA. The ability to write CLR inside the database is very new to DBAs, most of whom have no experience with .Net coding. Note this is in no way any sort of knock against DBAs, I would not expect one to have any experience with it. Likewise with many of the other tools.

The bigger reason though is Sarbanes Oxley. For a complete background see the Wikipedia article on Sarbanes Oxley, but in brief “SOX” is a US law that makes the leaders of publically held companies accountable for the financial dealings in their company. Auditors are responsible for ensuring compliance. As a result, most corporations have put in place rules in IT that place a wall between production systems and the developers who created those systems. In my own company’s environment, and those of many others I speak with, this means the DBAs are no longer allowed to develop code. No table designs, to stored procedures, etc. They are able to develop scripts if they are used in maintaining the health of the server; those are OK because financial decisions are not being made based on those scripts.

Somebody then, had to step in and fill the gap. In many companies since these were considered development tasks the coding fell to the development group. In other organizations DBAs were divided into production DBAs and development DBAs. In either case these folks are responsible for developing solutions to business issues, and are not responsible (at least not directly) for the day to day running of the server.

Now that you understand what a SQL Server Developer is and why they came into existence, you may be asking what the point of this article is? Well, I suppose it’s a plea of sorts. I see a lot of activities / training for both the DBA and the .Net pro, but little for the SS Dev. Even Tech-Ed this year demonstrated the schizophrenia when it split the event in two. There were just as many events in the Dev week as there were in the IT Pro week that applied to the SS Dev. Don’t get me wrong, I have seen training videos, mostly from Microsoft, that cover the technologies involved. But little that talk about the overall experiences that a SS Dev. In addition, almost every book I read assumes the reader comes from a DBA background. Doing so only covers half of the target audience; keep in mind there’s a lot of us who came from a .Net background.

So what would I like to see? Well to begin with, books that don’t assume everyone has the same background. Next I’d like to see more events targeted at the SQL Server Developer. Here in Birmingham we’re planning on a SQL Saturday next spring, I’d like to see many sessions devoted to the SS Dev. Finally, there seems to be very little software, outside the tools that ship from Microsoft, to assist the SS Dev. RedGate has some nice tools, and I’ve just started investigating the ApexSQL tools, most tools seem to target the DBA primarily though. It’d be nice to see collections and offerings more targeted at development.

What can you do? Well if you recognize yourself as a SQL Server Developer, start referring to yourself as such. Talk to Microsoft and vendors, start bringing the gap to them, ask them to start providing tools and events to cover our needs. Finally, evangelize! Do presentations, blog, whatever it takes to let the world know there’s a new breed of IT Professional out there.

Arcane Code, MVP

Just a few minutes ago I received an e-mail. “Dear Robert Cain,” it began, “Congratulations! We are pleased to present you with the 2008 Microsoft MVP Award! The MVP Award is our way to say thank you for promoting the spirit of community and improving people’s lives and the industry’s success every day.”


I admit it’s a goal I’ve had for the last year and a half, and have worked hard to achieve, but I still have a hard time believing it’s finally happened. For those who are unfamiliar with the award, MVP stands for Most Valuable Professional. Microsoft gives the award for work in the user group communities. My award was given in the SQL area. I am humbled to be joining an elite crowd, worldwide the website shows only 223 people in this category. Even though the award is for my efforts, those efforts were in the community and I had a lot of help from the community. Thus there are some folks I’d like to publicly thank.

The first is Doug Turnure, who up until Monday was the Developer Evangelist (DE) for AL/MS/GA. Doug mentored me, and gave me a lot of practical, valuable advice. I’d also like to thank the new DE for the area, Glen Gordon, who also gave me aid. Two other DE’s, Joe Healy and Brian Hitney also deserve a word of thanks. Even though I lived out of their normal operating areas they still took time to answer my questions and let me know of speaking opportunities.

There are also some 2007 MVPs who took time to give me advice and guidance. Todd Miranda, Jeff Barnes, Wally McClure, Kevin Boles and Keith Elder deserve a big thank you.

Next I’d like to thank all my co-workers, too numerous to mention, who tolerated my constant e-mails about user group meetings, events, and suffered as I practiced my presentations on them.

I would also be neglectful if I failed to say thanks to everyone in the various user groups I attend. BSDA, BUG.Net, Steel City SQL, SOA Society, TechBirmingham and others opened their doors to me and gave me chances to give back to the community. I should also say thanks to the various user groups across the south east, such as Atlanta, Orlando, Tallahassee, and Huntsville (to name a few) who opened their doors to me.

To all the readers of my blog I also need to give thanks. Your participation via comments and e-mail feedback helped keep my blog alive as a source of ongoing information for the community.

Next I want to thank my daughters, Raven and Anna, for putting up with Daddy being gone weekly to user groups, having his nose constantly in a book or laptop, or having to travel and spend time in hotel rooms while Daddy was in code camps. (Don’t worry, they didn’t suffer too much, they invented popcorn and “chick flick” night to compensate, and with Mommy’s help easily found the shopping malls.)

Finally, and most importantly I need to thank my wonderful wife ‘Ammie’, for taking care of the household while I was giving presentations, for bringing me dinner at my computer while I worked on blog posts, and for putting up with all the late nights I’d crawl in bed after getting immersed with some fascinating new technology and losing all track of time. Thanks honey!

TechEd 2008 Wrap Up

Whew. I’m finally home from TechEd 2008. It was an incredible week. First off, it was quite lucky for me in terms of swag. I came home with: XBox 360 Elite; Office 2007 Ultimate; Book on Sharepoint Web Part Programming; 2 games for the XBox; 8 Gig Zune; and more extra large t-shirts than I could carry.

I also got to meet a lot of great people, and find some speakers to add to my favorites list. Having heard them on Dot Net Rocks I knew Kimberly Trip and Paul Randall were good speakers, and just as friendly off stage as on. Matthew Roche, Buck Woody, Dan Jones, Donald Farmer, Peter Ward, Allen White, Maciej Pilecki, well I could go on with the list of great speakers but these were among the ones that stand out.

The InBetween weekend event was outstanding. The user groups really did a great job in a short amount of time putting together an awesome weekend. In addition to presenting my own session I also enjoyed attending ones by Barry Ralston, Andy Warren, Brian Knight, well there I go again. It is well worth staying over, or arriving early and getting in on the weekend event if you are going to TechEd.

By far though, the most important thing I came home with was knowledge. I learned an incredible amount. That knowledge will make me more valuable to my employer, who invested their money to send me. It will also make me more valuable to my coworkers, as I share the knowledge and have more answers to their questions. I’m also more valuable to the community, as I go back to user groups and share what I’ve learned there in presentations.

All in all I’d say TechEd was a great investment of time, money, and brain power.

The TechEd Day 1 Report

Wow, what a day. It was go go go all day long. I even attended sessions during lunch, so as to get every last bit of knowledge I could. I went to a lot of good sessions today, but by far my favorite was the session Kimberly Tripp did on Indexing Strategies. She was able to take a boring subject like indexing and not only make it understandable but entertaining. When you find yourself excited about the thought of spending time looking at your indexes, you know you’ve been trained by a master!

After the session she stayed and answered questions, and again from the floor she and her husband Paul were there again sharing their brain power. I enjoyed the session so much I’ve just spent 20 minutes juggling my schedule for the rest of the week so I can squeeze in another session they are doing later in the week. If you ever get a chance to see them speak, I would highly recommend it. If you cannot in person, at least check out their blogs at SQL Skills. She also did a series of webcasts, you can find links at

Enough fun for today, need some rest for tomorrow is another day of geeking out.

I went to the Inbetween TechEd Conference and All I Got Was This Lousy XBox 360 Elite!

As you know from my previous entries, I am in Orlando attending TechEd, at the IT Pro week. In the weekend between the Dev and Pro conferences Microsoft turned over the Orange County Convention Center to the Florida User Groups. Spearheaded by the ONETUG group, this event was made possible through the cooperation of many user groups. I attended the SQL Saturday sessions that were held on both Saturday and Sunday, and they even let me hog the stage for an hour on Saturday and give my presentation on Full Text Searching in SQL Server 2005 and 2008.

I had a blast, and met a lot of great people. I have to admit I was surprised at how many folks were there just for the Inbetween conference and not TechEd. Out of the 45 folks who were in my session, all but 2 said they were local folks there for just the Inbetween conference.

As you can tell from the title of this post, I did indeed win something. Bear with me, as it’s a great story. At the Saturday night party they were giving away 3 XBoxes, two of which were randomly drawn for. Well the young lady who won one of them did not wish to keep it for whatever reason, and asked if she could draw another name, which she did.

Well the guy who won that night had his name drawn during Sunday’s giveaway of 7 XBoxes. He came up and told the story, and said he wanted to do the same thing, even though no one would have said a word had he decided to keep it. Well he drew and it was my name he pulled out of the box! I wish I could remember his name so I could say thanks again.

I’ve always wanted an XBox, but could never quite justify the expenditure. Now I have a new toy, and my kids are very excited over the prospect of playing some games with daddy. I think this will be a great gizmo for some daddy/kids together time.

Let me get serious for one moment, and give a big thanks to all the groups who came together at the last minute, and to Joe Healy, Florida Developer Evangelist, for giving the user groups the chance to show what they can do. It seems almost fashionable to bash Microsoft these days, but how many other companies would bear the expense of something as costly as the convention center and give it away to the user community?

Thanks to all for a great time, I hope the Inbetween conference becomes a regular feature at all future TechEd.

I’m Speaking At the TechEd ]InBetwen[ SQL Saturday Conference

TechEd is Microsoft’s annual developer conference, the really big one. This year it returns to the Orlando Convention Center, only this year they have decided to split it into two weeks. The first week is for developers, the second week is for the IT Professionals. My manager is generously sending two of us this year, my co-worker will be there the first week, I’ll be attending the second week to focus on the SQL Server information.

The two week split left Microsoft in an odd position, what to do with the convention center over the weekend? In their long standing tradition of working closely with the developer community, Microsoft turned the place over to the Florida user groups. They are hosting the first “]InBetween[“ conference. There is an incredible amount of content being offered, for free: .Net Code Camps, Day of Agile, Day of Silverlight, .Net University, DotNetNuke University, Exam Crams, IT Pro Camps, Office Communication Server, The ToolShed, Train the Trainer, VSTS University, and SQL Saturday and SQL University (on Sunday).

You can find out more, including links and a complete schedule at:

Of special interest to me though, and the reason for this post is SQL Saturday. Either through divine intervention or a cosmic prank, I will be presenting at the SQL Saturday doing a session on Full Text Searching. You can register and get more info here:

And see the full schedule here:

It’s quite an honor, there are some big names speaking there such as Andy Warren and Brian Knight. I also see that another Birminghamian, Barry Ralston will be speaking.

So if you will be in Orlando for TechEd, plan on staying late or arriving early and attend one of the many InBetween conferences. This promises to be a great event, and best of all it’s FREE. That’s right, you don’t even have to be a TechEd attendee to come, just show up and pick your event. (Of course, the event organizers would appreciate it if you would register!)

Microhoo not to be

Seems like Steve Ballmer doesn’t mind working weekends. Microsoft has withdrawn it’s offer to buy Yahoo. Check out the Marketwatch column:{3A657B77-2EDE-4B6A-96E9-DD197C07850C}

If you want to pass it along, I’ve also shrinksterized it in what coincidentally is one of the coolest Shrinkster links I’ve seen:

Ultimately I think this is probably good for Microsoft. It would have been a huge uphill struggle getting this deal approved, especially in the European Union. For Yahoo it would have been a mixed bag, I think it would have been good for the shareholders, but I don’t think their IT arm would have been overly happy about it.

In other interesting news that I think is uber cool but has nothing to do with Microhoo, Gizmodo is reporting a MacGyver movie is in the works.

Thanks to the Twitterverse for the news, @dewaldp and @sweekly.

See, I TOLD you Apple is the Evil Empire

Some time back, I wrote a blog post describing Apple as “The Evil Empire”. Now a nationally known figure is adding her voice to the chorus. In this CNet Buzz Report, Molly Wood describes Apple as her “bad boyfriend”. They The guy who forces her to look good, tell her what cell phone carrier to use, etc without caring about her.

I thought that was a pretty apt description, and it really helps delineate the differences between the Apple philosophy and everyone else. Apple keeps tight control over their domain. Who cares if the new Air only has 1 USB, no firewire, no internet, no optical drive, no media card reader, and no expansion slots? Hey it LOOKS good. And those pretty new i-Phones? Oh, you can only use the carrier THEY pick out for you. Third party apps? Only if they give their blessing, which they still haven’t done. But hey, it LOOKS good.

Contrast that with both Windows and Linux. You can run the OS on any machine you wish. Windows Mobile? sure, any company who wants to license it for their device or carrier great with them. Heck Microsoft was even so open they let the i-Phone work with Exchange. But people complain that Microsoft isn’t open enough? And after Apple’s latest stunt of trying to force Safari down everyone’s throats via the iTunes update, I’d better not hear any Mac-Head deride the Windows Update process as “sneaky”.

It’s no wonder people are resorting to installing Windows on their MacBooks, it’s the only way they can get the freedom to get any work done!

Happy Birthday Visual Studio

According to this article in Platinum Bay, today March 19th 2008 is Visual Studio’s 11th birthday. I have used many IDE’s over the years for development, but I would argue all day long that Visual Studio is the best, period. Everyone who contributed to that original1997 product and put their sweat into it since deserves a round of applause and a hearty thank you from the development community.

Happy Birthday Visual Studio!

Doug Turnure MS Developer Evangelist To Speak at BSDA on Silverlight 2.0

Just thought I’d share some exciting news, Doug Turnure the Microsoft Developer Evangelist for our South East area will be in Birmingham on Thursday, March 13th. He will be at the Birmingham Software Developers Association and will be telling us about Silverlight 2.0 and other cool stuff that was announced at Mix 08 this week. Afterward we’ll be having a geek dinner at Jim and Nicks on Oxmoor.

The BSDA meeting will take place at New Horizons in Homewood, beginning at 6:30 pm. I’d suggest getting there a bit early to get a good seat, then be sure to join us afterward for food and more geekery at Jim and Nicks.


Get every new post delivered to your Inbox.

Join 100 other followers