Voice of the DBA

Author: way0utwest

  • Developer Deployment Frustrations

    Why don’t developers like SQL Server? Probably a few reasons, but I’m sure this is one that really frustrates them. I found a Connect Item that was titled:  Why is Deploying SQL Server 2008 R2 sooooo FRUSTRATING?!! There really is a question there, asking for guidance on  which versions of SQL Server are available and recommended for developers to include in their applications.

    When SQL Server MSDE was released, it seemed that Microsoft was looking for it to be included in small applications that might then be upsized to a Standard or Enterprise edition of SQL Server. It seems to me that this is really the market for Exsoftpress (the evolution of MSDE) and that it ought to be simple for a developer to not only deploy this with their application, but also setup basic maintenance easily.

    I sometimes think that the software developers at Microsoft get lost in their own specialty and forget just how frustrating it can be for the rest of us trying to use their product in new ways. They forget that many of us want to deploy simple solutions easily, and not spend a lot of time working out the nuances of software setup.

    I’d like to see Express not only have a very simple setup that works across multiple versions of Visual Studio, but also baic maintenance plans built in that allow full and log backups (if needed), along with index rebuilds with a simple switch set as a part of setup. A few registry keys or XML config changes could set paths or frequencies.

    Making life simpler for developers is a worthwhile investment for the SQL Server team. It makes them more likely to include it in their applications. If you can add a one-switch replication to sync to a Standard or Enterprise SQL Server, they might think Express is required in every application.

    Steve Jones

  • Virtual Labs – A Great Resource for SQL Server

    I had someone send me a note recently asking some questions about how to get set up to work with SQL Server. This was a person that had used SQL Server in the past, but had become a manager and then lost their job. So they wanted to start working with SQL Server and get a new job, however they didn’t have a server or many resources.
    My first recommendation is that you grab the SQL Server developer edition for US$50. You can get it from Microsoft, Amazon, or many other places, but this is essential. It gives you a good basic point from which to start and test features.
    However if you don’t have a spare machine, or you don’t want to put SQL Server on what you have for some reason, you have another option.
    TechNet Virtual Labs
    There are a whole variety of labs available, including a series on SQL Server 2008 and other versions. These allow you to RDP to a virtual instance of SQL Server and actually practice working on things.
    There are other labs for Windows, Exchange, etc. You can spend time working on these technologies, either guided or unguided, and get some hands on practice. You can’t necessarily save your work, but this is a great way for you to get started on some technology that you want to add to your skillset and resume.

  • Labor Day Bloopers

    Happy Labor day to everyone. A day off for me, but I’m posting a few bloopers from the past couple months. These are the raw files, and I had about 40 minutes of stuff that I just dumped out raw and uploaded in four parts to YouTube.

    Enjoy

    Bloopers Part 1

  • Six Trips

    Six trips left to close out this year. Most are very short, so that’s good, but still, it’s a bunch of packing and prepping to do.

    Here’s my list:

    Sept 25 – SQL Saturday #52, Denver Tech Center, OK, so not a real trip, but still I’ll essentially be gone for a day and a half from home with a late Fri night, all day Sat, getting home late Sat night. On the plus side, I get to hang with Jack Corbett from Orlando while his wife talks horses with my wife.

    Oct 1-3 – SQL Saturday #53, Kansas City, speaking here, and getting to a Royals game for the first time ever. *cool*

    Oct 19 – Boulder SQL Server User’s Group – It’s a day trip, but over an hour from my house to the group, so I’ll count it.

    Nov – Nov 2 – 5 am – SQL Connections and Dev Connections and the Las Vegas SQL Server User’s Group. SQLServerCentral is sponsoring a track and Jason Brimhall convinced me to make good on my promise of speaking to his group Thur night.

    Nov 7 – 8 – Heading to Seattle to take care of some admin stuff and hang out with Brent Ozar for a day.

    Nov 19 – Nov 21 – NYC. SQL Saturday #59. A last minute decision, but I want to support these groups and this will cement my Premier status for United for next year 😉

    I’ve got a couple ski trips with the family planned as well (Thanksgiving and Christmas), so it looks like a busy fall for me.