Tag: sql server

  • How Long Before You Upgrade?

    It’s 2014. SQL Server 2000 is 14 years old, but there are still quite of you managing instances. SQL Server 2005 is 9 years old, and I’m sure more of you still deal with that version. I know because I work for a software vendor and I’m constantly asked if our software will run against those two versions.
    For many of you, however, if you’re managing a SQL Server 2000 instance, it might only be 9 or 10 years old. Your company might still have been installing SQL Server 2000 in 2005. The same is true for SQL Serve 2008. I wouldn’t be surprised to find companies still setting up 2005 instances in 2008 or even 2009.
    Companies don’t care much about versions. They tend to mostly care about databases getting the job done, and sometimes, support. Many organizations don’t see value in upgrading too often because of the overhead. I suspect many managers would prefer to get many years usage out of a platform before they change in order to minimize work that doesn’t add value to their business.
    The question this week asks you about the longevity of your database instances. Think about the average instance, or even the majority of your applications and how long they will remain on a particular version.
    How many years will you run a platform before you upgrade it?
    Years ago I heard someone at a large Fortune 100 company say their stated policy was to get 10 years of service out of a database server. At the time I thought that was a long time, but the more I think about it, the more I think that might be a minimum amount of time I’d want from a platform.
    Let us know this week what you experience, and perhaps what you’d prefer.
    Steve Jones
  • T-SQL Tuesday #53–Why So Serious?

    tsqltuesdayIt’s an interesting topic this month for T-SQL Tuesday #53. When I read Matt Velic’s invitation, I became intrigued. I like jokes. I like messing with people, and I was thinking about the recent April Fool’s jokes I’d written and those in the past that have been fun. I’m going to enjoy this.

    You can participate as well on any month. Just write a blog post and publish it on the second Tuesday of the month, linking back to that month’s invitation. Follow the #tsql2sday tag on Twitter or set a reminder and Google on the first Tuesday of the month.

    If you hurry, you can participate this month.

    Not So Serious

    The number one rule is know your audience. I’d be very careful who I might play this joke on. Note that this is also a bit of a abuse of privileged accounts.

    There are a few utilities from Sysinternals (owned by Microsoft) that are very useful for administrators. However they have also been very handy for practical jokes as well. Specifically I’ve used the PsExec and PSKill to amuse myself.

    I once worked in a group that had four administrators to run our systems. We lost one of our people to a better job and the corporate management decided to "promote" an internal employee to replace him. This new person was a "paper MCSE", who had studied for the exams. He was making an effort to grow his career and that was something to admire.

    However he was a jerk.

    He had the mistaken impression, as many people that have achieved something they set out to do, that they know more than they do. In this case, much of his "book learning" and boot camp work wasn’t appropriate for the real world. What’s more, when we would work with him to teach him how things worked differently for us, or explain why the book recommendation wouldn’t work, he was arrogant and dismissive of us.

    After suffering through a few months of his dismissive attitude and desire to avoid learning more in the real world, we decided to play a few jokes on him. We downloaded the sysinternals tools and also wrote a few scripts to command line launch tools with specific scripts or settings.

    One day when he picked up the phone to work on a call, we watched him start to connect to a server. Using PSList and PSKill, we’d kill his connection. Then we’d quickly use PSExec to launch another connection to a different server. At times we could be creative and redirect him to a development server instead of a production server. He’d swear he was fixing something for a user, but since he was on the wrong server, the user didn’t see the item working correctly.

    We were sporadic in our efforts, only causing issues a few times a day when we felt the problem wasn’t too critical. Eventually my manager realized what a few of us were doing and had us stop.

    It was a bit mean, and not something we should have done maliciously. I was young, and let myself get irritated. In later years, I out grew some of this childishness and limited jokes to people that I genuinely liked, changing settings, altering wall paper, creating aliases that pointed to different systems, and even unplugging people mice and connecting my own in an adjacent cube.

    Joking around at work can be fun, but remember that it shouldn’t be malicious and it can’t prevent people from getting work done. We certainly don’t want to get someone fired, as much as we might like to at times.

  • Lobbying for Change

    I ran across a note recently on Twitter from Adam Machanic. He wrote:  Just spent most of the day working through a subtle PK issue – 1 bad row out of 18M. Would have killed for this. The item in question was a Connect item, one with almost 500 votes. It’s a good one, and I’d encourage you to vote for it. I know that it seems many of these items are never worked on, but some changes make it into the product, so I’d ask you to continue to vote for change.

    When Connect was first introduced, Andy Warren and I debated the value of the platform. On one hand it made good sense to directly feed information back to developers, but on the other hand, it was likely that those items that got more notoriety or votes might get fixed, even if they weren’t necessarily good ideas. The popularity of an item doesn’t necessarily mean it’s one that should be fixed in the product first. We also worried about one of the big problems of the platform and that is that a tremendous amount of noise of entered and it becomes hard to triage the submissions.

    As I watch Connect evolve, I can’t help but think that it’s been mostly a failure from my perspective, with a few notable successes, like Service Pack 3 for SQL Server 2005. There’s too much noise and too many items ignored. However I also do think that those items that get lots of vots do get more consideration from Microsoft. More votes doesn’t mean that the feature will get fixed, but I do believe the item gets talked about. (As an aside, please vote for more, final Service Packs)

    Personally, I think that raising awareness of possible suggestions or problems is a good idea. I’d love to see a top 10 list of Connect items from MS for consideration every month. Having them highliht some items they’re considering from the list might help focus attention from customers. I don’t think that’s likely, but I wonder if highly debated suggestions might be worth highlighting at SQLServerCentral. Would you like to see a Connect item of the week? Something you could vote on or even debate as a good idea? I would, and I’d consider adding them as a way to help improve the platform that I enjoy working on the most.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 3.0MB) podcast or subscribe to the feed at iTunes and Mevio . 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.

  • Oracle, MySQL, and MongoDB Come to SQLServerCentral

    We’re in for a name change. As of May 1, we’ll be welcoming the Oracle and MySQL communities to SQLServerCentral. Our daily content will grow to include articles and questions about these platforms as we look to become more inclusive to the large numbers of data professionals that work on other platforms.

    At Red Gate Software, my employer and owner of SQLServerCentral, we’ve built a number of tools for other platforms. We have our Compare product working on Oracle and MySQL, and we are actively working to extend this technology to MongoDB and other platforms. With so many professionals wearing multiple hats at their employers, we’ve decided to also consolidate our community sites.

    As a result, we are going to change the name of the site to

    DataCentral

     

    That’s the new site and don’t worry, all your old URLs will redirect. We’ve been working hard to ensure that everything still works as planned, and we have some new tags coming that will allow you to easily filter information to the specific platform you need.

    We think this is a great move forward, to include other platforms and give you the opportunity to learn more about other technologies, even if your company doesn’t use them. This is also an April Fool joke, so if you’ve read this far, hopefully you’re smiling with relief.

    I do like Oracle and MySQL as technologies and they work fine. I just think in many cases SQL Server works better and I like using it. That being said, the site isn’t changing, but I would encourage you to learn more about other platforms if you have an interest, or your company uses them. Having additional skills can help your career, even if it’s a safety net.