Author: way0utwest

Letting People Go Securely
This editorial was originally published on Mar 15, 2009. It is being re-run as Steve is away on the 2013 SQL in the City tour.

The world economy appears to be in shambles, with many companies cutting back in all facets of their business. We hear regularly in the US that people are being let go from their jobs as positions are trimmed and companies look to save money.

When someone is let go, typically they are asked to leave the premises on the day. I’ve seen escorts that walked people out or watched them pack up. In some extreme cases I’ve seen people escorted out the door while another employer packed their things and brought them out. For IT workers, it’s a little different since they often have privileged access to systems. In addition to removing their personal belongings, having an IT worker leave means that passwords and possibly accounts need to be changed to ensure that the company is safe.

However when someone resigns and gives their two weeks’ notice, I often see that many people are expected to work their final two weeks, brain dump their knowledge to others, perform documentation, or even continue doing their job. In all of the positions I’ve resigned from I’ve worked out my time, even doing some last minute SQL Server development on a Friday afternoon, my final day of work, with plans to leave town the next morning for a new job.

There was only one place that I worked with a different policy. In that company, if someone with above normal privileges, which included upper management and IT administrators, they were escorted out of the building immediately if they gave notice to terminate their employment. That surprised me, but I understood it. People were paid for their two weeks notice, but management didn’t want anyone to have access to company funds or systems if they planned on leaving. I saw an article recently that provides some justification for this, with a survey showing 59% of people leaving a company steal data.

On the surface this makes sense, but does this help prevent data loss? I don’t think so. What happens is that employees that are likely to steal data will just take the data before they give their notice. You haven’t changed their behavior, but by not allowing them to work out their notice, you punish the remaining employees who have to suddenly pick up work from their ex-colleague.

There isn’t a good way to protect data from employees that want to steal it. But you can put in place auditing, and smarter systems that allow monitoring and auditing of your systems. They won’t prevent issues, but hopefully they’ll allow you to detect and respond to them.

Steve Jones

The Voice of the DBA Podcasts

The podcast feeds are now available atsqlservercentral.mevio.comto get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.

Overall RSS Feed: or now on iTunes!
- Windows Media Podcast – 25.8MB WMV
- iPod Video Podcast – 23.4MB MP4
- MP3 Audio Podcast – 4.8MB
Today’s 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.

I really appreciate and value feedback on the podcasts. Let us know what you like, don’t like, or even send in ideas for the show. If you’d like to comment, post something here. The boss will be sure to read it.
October 9, 2013

The 2013 SQL in the City Tour

The 2013 SQL in the City tour kicks off today for me. I’m flying to LA this morning, early, in order to ensure the venue is ready and perform our last 3-4 keynote practice sessions in real time. We’ve been practicing remotely, but in order to ensure things run smoothly, we want some last minute practice at the podium, with all three of the speakers together. I think we have a fun, informative, and not-too-long keynote you’ll enjoy.

Then it’s off to the pool. I’ve been swimming more this year with a sore knee, and I’ve got pools lined up for the all the stops on our tour: Pasadena, Atlanta, and Charlotte. I’ve even searched out a few places in Charleston, where I’ll be SQL Saturday #227 in between the Atlanta and Charlotte events. I’m not sure of my schedule, but if you want to put in some laps, send me a note on twitter and I’ll let you know when and where I’m going.

These events are free, one day events sponsored by Red Gate Software. Our intention with the events is to support the community, help you learn more about SQL Server, and give you some tips, tricks, and hints for using our tools. You don’t need to use our tools to learn something at the events, but we do think you’ll see that our tools make your job much, much easier. We think we provide a lot of value, and it’s worth the price of the tools to make you more productive.

This year we were much more organized than the previous years and we’ve broken up our days and sessions into DBA and developer tracks. Our goal is to teach both groups, and tailor sessions for each side of the SQL Server community to help you get better at your job. We started in London earlier this year, and with additional practice by Grant and myself at our smaller seminar events, we think we’ve got some great sessions for you to see.

If you’re in one of the cities, register and come by. We’ve heard great feedback from people and most think the information and inspiration you get is worth a day away from the office.

Steve Jones

Video and Audio versions

Today’s 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.

Follow Steve Jones on Twitter to find links and database related items and announcements.

Windows Media Video ( 16.9MB)

MP4 iPod Video ( 19.9MB)

MP3 Audio ( 4.1MB)

Feeds are available at iTunes and Mevio

To submit an article, rant or editorial,
log in to the Contribution Center

October 8, 2013

T-SQL Tuesday #47 – SWAG

It’s T-SQL Tuesday time, the second Tuesday of the month when we all coordinate our blog posts on a particular topic. This month Kendal Van Dyke has invited us to take a break from technical topics and have a bit more fun. This month’s topic is asking about the swag that you’ve gotten from an event. This seems appropriate given that there are so many events this time of year. In addition to the tremendous number of SQL Saturdays, we had DevConnections last week, SQL in the City this week, the PASS Summit next week, and SQL Intersection next week.

This happens every month, and if you want to participate, look for the invitation on twitter with the #tsql2sday hashtag. If you want to host, contact Adam Machanic.

The Best SWAG

I’ve been fortunate to attend many events in my career. I’ve been to TechEd, the PDC, SQL Connections, SQL Intersection, the PASS Summit, various TechFests, lots of SQL Saturdays, and, of course, Red Gate’s SQL in the City events. I don’t often get swag these days, but earlier in my career I would grab various gifts and goodies from the events and vendors. I’d often bring back items for co-workers and my kids, some of which I actually still have.

These days I don’t get much swag, though I do get speaker gifts from some places, which feel like swag to me. What are the best items? I’m not sure that I can pick just one, but I have a few things that stand out.

Multi-tools

During the WIT panel at SQL Saturday #222, SIOS sponsored a gift to take back to kids, boys or girls. It was a multi-tool and I grabbed two, one for each of my kids. I even checked my bag (which I never do) so I could bring the small knives to my son and daughter. They loved them, putting them in bags to use when they might need them. I saw my son actually break this out a week later to use the pliers.

Wine

The speaker gift from SQL Saturday #222 in Sacramento this year was a bottle of wine. I thought that was a great gift, and one that’s still sitting in our wine rack, but probably not for too much longer 🙂

Beer Mugs

A few years ago the crew from SQL Sentry gave away silicone beer mugs at the SQL Connections conference. I loved the insulated mug for cold beverages, and so did my kids. I found after a week that I never got to drink from them because my kids were filling them with smoothies, juices, and more. The mugs were always in the dishwasher. I mentioned this to Peter Shire and he graciously gave me 4 more at the next event. That hasn’t stopped my kids from using them at every opportunity, but with 5, I do get to use a few of them now and then.

The Keychain

I’ve gotten a few, and some of them are very nice, but the one that stands out for me was from the SQL Saturday #169 in Denver. The local user group made their own parachute cord keychains that I still have on a backpack. It’s similar to a survival bracelet, the kind of things that Boy Scouts carry, just in case. I love the keychain and while I hope I never have to use it, I have it if I need it.

Lots of Gifts

There are plenty of other things I’ve gotten that have survived. I have bags and shirts from many events. I have pens, USB drives, a couple keychains, and even a few bottle openers. I’m sure I’ve forgotten some of the other items, though to be fair, there were lots of forgettable items.

It’s hard to give out good swag. At SQLServerCentral, we’ve struggled to think of what things people would like. I’ve given away lots of shirts and books since I’ve felt people will keep those around and hopefully have fond memories of the events. I know I do when I use some of the items that I’ve gotten.

October 8, 2013

Beginner, Expert, or Both?

It seems that there’s no shortage of interviewers complaining about the lack of qualified candidates for open positions. It seems to me that the best thing you could do to get a better job is work through all the articles and lots of forum posts from SQLServerCentral, complete all the exercises in your favorite SQL Server book, and improve your skills so that you shine in an interview. If most candidates are really that bad, it can’t be that hard to make yourself stand out with a little work.

However it seems few people do that. In fact, it seems that quite often we find people that have 5 years of experience with SQL Server really have 2-4 months of experience repeated 15-30 times. What’s more disconcerting is that they don’t realize how much knowledge they lack.

This article might provide some of the reasons why people think they’re more experienced than they are. They’re expert beginners, and since they can accomplish the things they’re asked to do at their jobs, they think they’re complacent. They have success because they’re not asked to do more, perhaps because their employer only needs a small fraction of SQL Server knowledge to keep their systems running along.

I think this is a hard trend to break. Employers don’t want to pay you to learn skills that aren’t important to them, and they certainly don’t want to pay you to learn things that will move you to a new job. However that doesn’t mean you should have the same attitude.

I think you should continue to expand your skills, grow your knowledge, and try new techniques. The best people in all professions continually question their current skills and techniques, looking for better ways to accomplish tasks. It’s good to use what works and ensure stability in your systems, but always be prepared to evolve if you find something that works better.

And keep looking for ways to do better.

Steve Jones

Video and Audio versions

Today’s 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.

Follow Steve Jones on Twitter to find links and database related items and announcements.

Windows Media Video ( 18.9MB)

MP4 iPod Video ( 16.2MB)

MP3 Audio ( 3.4MB)

Feeds are available at iTunes and Mevio

To submit an article, rant or editorial,
log in to the Contribution Center

October 7, 2013