Voice of the DBA

Category: Editorial

  • The Express Choice

    There are a number of editions of SQL Server, each of which has different capabilities, features, and restrictions. Over the years, the mix has changed, and it can get confusing for customers trying to decide what to purchase and use. Fortunately things seem to have become simpler the last few years, but you still have to make a few choices.

    The Express Edition has the most restrictions, including a database size restriction, but in many ways, it’s a very capable database server. It’s the evolution of the “desktop database”, MSDE, that was designed to take the place of Access for desktop software that needed a database.

    Recently I ran across a discussion on using Express in production, and I was surprised that many people didn’t think it was  a version capable of acting as a production server. It’s the same code base as the other versions of SQL Server, with more restrictions. This week, I wanted to see how most of you feel.

    Would you use Express Edition for a production database?

    I would. In fact, given the way licensing costs have soared for SQL Server, I’d be tempted to use Express in many places, especially for departmental sized applications. I wouldn’t care whether they were web based or client/server. As long as the database would remain below the 10GB limit and the 1GB RAM limitation didn’t kill performance, I think Express is a fine choice.

    Of course, outgrowing Express can be quite expensive and a shock for someone using it, but if you need a more powerful server, you need one. I just prefer to defer that cost if I can.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 1.9MB) podcast or subscribe to the feed at iTunes and LibSyn.

  • Building Small Habits

    I was reading Kenneth Fisher’s piece on constraints recently and was struck by the fact that this is one of those small changes you make to your coding that has big benefits. In essence, rather than being lazy and writing this:

    CREATE TABLE mytable ( myID INT PRIMARY KEY, MyCol ....

    You decide to explicitly add a few more characters. You note this is a constraint and you type this:

    CREATE TABLE mytable ( myID INT CONSTRAINT PK_MyTable_MyID PRIMARY KEY, myCol

    It’s a small change, but it takes you from an object named PK__mytable__783FBF31F8293E74 to one named PK_MyTable_MyID, which is way easier to understand and debug when you have issues. More importantly, this is a DevOps move, where a developer can make it easier for operations people to understand the constructs and organization of a system that has moved to a production environment.

    There are all sorts of little coding changes you can make that improve the way you write code, and perhaps make it perform better. Aaron Bertrand has a whole series of bad coding habits, and at SQLServerCentral, we’ve published a number of pieces on different ways to code better, such as removing cursors from your code.

    By making some small improvements in your coding habits, changing to better techniques over time, you’ll slowly improve your entire codebase and help yourself and other developers code more efficiently in the future. I’d even recommend as a team that you choose a single change to make, and begin implementing it across the next month or two. Then repeat the cycle again. In a year, you’ll be amazed where you are.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 2.0MB) podcast or subscribe to the feed at iTunes and LibSyn.

  • Small Leadership

    I ran across Richard Branson’s top quotes on leadership. From a man who’s been quite a success in many areas, and has influenced many others, it was interesting to see what he considers good advice. He lists ten quotes from various others, some of which I’ve heard before. It’s an interesting mix, and these are certainly items that come from someone that could be considered a leader in business. I don’t know if that’s true, but certainly Mr. Branson is in charge of his company, and I believe that it is important for the management of a company to display leadership if they want to be successful.

    Most of us, however, aren’t in management positions. Most of us might not want to ever be in management positions. Plenty of technical people prefer to remain in their roles as developers, DBAs, analysts and more. However, that desire doesn’t mean that better leadership skills wouldn’t make our jobs easier, or make us more successful.

    The first quote in the story is this: “A lot of people have gone further than they thought they could because someone else thought they could.” That’s the quote of leadership that inspires, that helps others gain confidence and do more than they might otherwise. That’s the quote that shows a person who helps others is a great employee, not only because they get work done, but because they help others perform better.

    Far too many managers don’t believe in their staff, and make the clear constantly. Those managers aren’t helping themselves or their company, as they’ll ensure most of their employees don’t do the best work they can. I’d encourage all of you to think about how you treat others. Think about what you say or do to encourage others to become better at their jobs. Perhaps there’s a little more you can to do lead others, and get more work done, while celebrating the success you can have together as a group of professionals.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 2.1MB) podcast or subscribe to the feed at iTunes and LibSyn.

  • Making Plans

    I write regularly about career topics, hoping that I can help many of you think about your career more, learn more, and move in a direction that’s important to you. I’ve had a great career, one I’ve enjoyed most of the time, and think that pressing myself to become a better professional in many ways has been a large part of that. However I haven’t always had a formal plan, and don’t really have any long term goals in any detail.

    I thought about this a bit in reading Kenneth Fisher’s interview of Tom LaRock. There’s a point where Ken asks Tom about his future plans and Tom paraphrases John Lennon to say he takes opportunities as they come and isn’t afraid to change directions in life.

    As important as I think it is to continue to learn, and to move your career forward actively, I don’t think you need to do it all the time. I don’t think it’s a constant, every day effort that you make. There are times when you’re busy with life, or busy with work, and you may not have the extra energy or desire to pick up a book or write some T-SQL. That’s fine. Relax and enjoy your life.

    Just don’t let those times stretch so far that your career stagnates. Make regular progress, not constant progress. Make plans, but live life as it passes. Make goals, but make them realistic, and pace yourself. Above all, don’t be afraid to change if that’s what’s right for you.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 2MB) podcast or subscribe to the feed at iTunes and LibSyn.