Voice of the DBA

Category: Editorial

  • Patching Problems

    I applied the Windows 8.1 update a few weeks ago and had some issues with my machine. Windows was fine, but I lost my SQL Server service. A few other users, including some of the SQLServerCentral community also had issues and sent me ideas, but their fixes didn’t work for me. That was OK because the problems gave me a chance to use PoSh to solve a real problem. I’ll be blogging about that in the next week.

    However the 8.1 update has caused lots of issues, and Microsoft is acknowledging these problems. That’s good, but the process gives me pause, and to a large extent, I think this makes more and more people suspect about all of Microsoft’s patching processes. I bet there are companies that feel even more justified in waiting for SP1 for SQL Server 2014 before upgrading, even though there is a chance that the patch itself will cause problems.

    This is one reason I’ve been hesitant to remain current with Cumulative Updates (CUs). Microsoft doesn’t stand behind them, with the text on each CU page that users should only apply the patch if they are experiencing specific problems. Otherwise users are told to wait for the next Service Pack, which seem to be coming less and less often.

    Any patch can cause issues, and I certainly don’t like the idea of automatic updates always being applied because if there are issues, they can become much more widespread than controlled updates. There is also the issue of vendor responsiveness. Microsoft has pushed out patches that caused issues, and while they’ve try to fix issues quickly, I don’t want to have all of my desktops, or all of my SQL Servers, down because of a bad patch.

    I don’t know how we patch in a more effective manner, but I do know that I want to have some control over updates as an end user, and I also want ways to remove patches. Moving to the app model of always applying patches over patches, and never rolling back seems to be a step in the wrong direction.

    PS – If you want better servicing for SQL Server, vote for final service packs for products still under support.

    Steve Jones

    The Voice of the DBA Podcast

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

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

  • Laptop Dreams

    The Surface 3 was announced last week, and I was underwhelmed by the event, especially the presentation itself. The entire spectable didn’t seem to compare to some other companies’ announcements. I did, however, find myself thinking about replacing my laptop with a tablet that’s lighter and allows me to forgo a keyboard. As much as I use a keyboard and depend on a responsive set of keys to get work done, there are definitely times when I’d like to just have a screen, and certainly a lighter form factor.

    Today is Memorial Day in the US, and I’ll be outside in a variety of situations today. Every year my son recognizes and remembers our soldiers at a Memorial Day ceremony with his fellow Boy Scouts. I like to capture some photos and video of the occasion, as well as track which Scouts are supposed to be there and have actually shown up. I can do it on a phone, but a laptop is too cumbersome. A tablet is actually the best option. It seems funny to use a larger device, but being able to capture and playback video on a tablet for others is much nicer than using a small phone. 

    I’ll also be cooking outside in the afternoon, and while my memory is pretty good, I’d like to be able to pull up a recipe on a screen I can easily see with my aging eyes. My iPad works well for this, but for many tasks that require the creation of content, it’s not always a good choice, and the upgrade to the Surface is tempting.

    Then there’s work. I’ve been struggling with finding a powerful laptop to run the suite of products that I present on, especially when I have some of the server systems running. The best solution for a small, powerful device, might be this Gigabyte BRIX for me, but I’d still need some keyboard and display to access it. While an iPad w/ keyboard can work, I’m wondering if a Surface might be better. I’d love to not only be able to access the device, but do so while I’m walking around. If I can get that to work, maybe I’ll have found the perfect device for me.

    Have a great Memorial Day.

    Steve Jones

    The Voice of the DBA Podcast

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

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

  • The Development Backup

    Have you ever had a development server crash? Have you lost work because of this? Had delays or had to recreate code? You shouldn’t, or at least you shouldn’t lose much work or time..

    There was a time when I offered to manage backups on all development servers. This was in a large environment with hundreds of instances.  I wasn’t worried. I had scripts to do the work of setting up, running, and reporting on backups for instances. I knew how to deploy these scripts to hundreds of servers.

    My reasoning was the our development servers were really our manufacturing environment for software. Wouldn’t you ensure your machinery was well maintained and kept in top condition if you had a factory? I know I would.

    The developers passed and once in awhile they’d call and ask of we could recover a server. 

    “Do you have backups?,” I’d ask. “No” was the usual reply. I’d appligize and reiterate my offer to manage the system. They were always resistent and that was fine. They were responsible, and these were their systems. However they had a backup system already. They just didn’t use it.

    Almost all of these people were using a version control system (VCS) for their code, but not for database code. Do me a favor; put your database object code in source control. Add all your DDL for tables, views, functions, stored procedures, and anything else you use.

    As long as it’s on a different physical machine than the development server, you’ll thank me one day.

    Just as long as you also run backups of that VCS database.

    Steve Jones

    The Voice of the DBA Podcast

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

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

     

  • What are you worth?

    Each of us is reponsible for negotiating his or her own salary for a position. Often we don’t have much leverage to exact a higher salary, and even if it’s deserved, so many companies don’t have the flexibility for managers to pay higher salaries than what is set in some range by their HR group. That’s discussed a bit in this post from Chris Shaw that looks at hiring and salaries.

    I’ve always felt that the way we handle salary was developed by owners and managers, and the process benefits them, not the employees. We rarely discuss salaries at work, with disclosure sometimes forbidden. Your salary adjustments over time seem to be highly based on your current salary. That means that your starting salary often determines your future salaries at a company, regardless of your abilities relative to others or the market. Even changes in supply and demand may not affect your salary.

    A few companies have set salary ranges publicly within the company and some even disclose salaries among employees. It sounds strange to many of us, but I’ve talked with a few people that work in those environments and it’s not a big deal. You earn your salary or you don’t, and if you do a good job, no one complains. If you don’t do a good job, then many of these companies are quicker than most to ask you to take a pay cut or leave. Personally, I like that type of environment.

    I doubt we’ll have open disclosure going forward, but fortunately many of us have the ability to change employers easily with our skills if the markets change and we feel we’re underpaid. The flip side is that there can be competition for your job and companies might find it easier to let you go and choose someone else that provides the company a better value.

    The only advice I would give most people looking to negotiate salary these days is that you should ask for what you’re worth, even if it seems high to you. The worst thing that usually happens is the employer says no and offers you a lesser amount. However, if you don’t ask, you won’t get the salary you want.

    Steve Jones

    The Voice of the DBA Podcast

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

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.