A New Look

I was browsing around the Internet recently, collecting links for Database Weekly when I came to Michael J Swart’s blog. I love Michael’s writing and drawing. On a whim, I asked if he’d do an avatar.

He agreed, and sent me some costs. He’s creating art, and I was happy to pay for a new image. We went back and forth a bit and ended up with this:


I like it. It captures me life in sunny, outdoor Colorado and has a nice Hawaiian shirt in it. Plus, it has my colors. I’m a Virginia grad and Broncos fan, and like the blue/orange look.

Photo Feb 26, 11 32 19 AM (1)

If you want an avatar, I’m sure you can contact Michael. I know it’s not for everyone, but it was fun for me. It might make a great gift for someone in your life as well.

Long Term Pebble Classic Review

I got a Pebble Classic watch for Christmas a few years ago, in Dec 2014 to be clear. That’s (as of now) about 18 months of use. I haven’t used it every day, but I’ve used it often, and here are a few things that I wanted to put down as a long term look at this device.

This is the first smartwatch I’ve owned. I’ve been a Timex Ironman (or some variation) person for most of my life. I went about two years with just my cell phone when my last watch died and decided I didn’t like that, so I got the Pebble.

tl;dr – I have really enjoyed the watch, but I’m not sure I want a (nother) device that lasts a year or two.

Current Status

The watch still works, though I have found that I need to charge it every 3-4 days. This seems in contrast to when I originally got it and the battery would last 6-7 days. In fact, early on I forgot my cord and went to the UK. I left Monday, returned Saturday, and the Pebble made it.

The big issue, for me, is that I have screen tearing. There are times I can’t read anything, though changing watch faces usually corrects things. However, when you’re doing something and want to check the time and can’t see it, you don’t always want to do this. For example, I’ve been out working in the field, with dirty hands, and I couldn’t get the time without getting grease all over the watch.

Looking Back at First Impressions

I wrote about the watch when I got it. For the most part, things still work for me. I use the watch to change music when I’m traveling, and I get text messages on it. However, sometimes I get too many messages, and need to go through menus to turn off notifications from the phone. It’s annoying, but that’s somehow what happens with apps that notify you.

I haven’t done much with timing on the watch, but I’ve usually found the phone to be more useful here.

In terms of running, I wasn’t running a ton when I got the watch, but I run daily now. Perhaps that’s why the battery doesn’t last. Each time to flick your wrist, the backlight comes on, which is a lot when I run. I’ve noticed it on the treadmill. Perhaps the backlight doesn’t happen outside? Hard to tell.

I do love the MapMyRun integration to see my time/pace. I use the audio coaching for motivation, but it’s nice to glance down and see my pace as I go. I wish this allowed me to change music and go back to the tracking, but I haven’t seen that work.


One thing I’ve done a few times is use the alarms on the Pebble to wake me. The vibration is quieter and better when I need to get up at 5am for a flight, and this doesn’t wake my wife. It’s kind of nice. It’s also a great second alarm in hotels.

However. I do forget to turn it off and the default is to repeat the alarm the next day. Good when I travel, bad when I come home and set it on the nightstand to charge. The vibration on wood is loud enough to wake my wife.


There are a few things that bug me. I have the phone sync sometimes fail, and I’ve struggled to get my Pebble reconnected without forgetting the device and doing a new phone pairing. It’s been simple sometimes, frustrating other times.

The screen tearing is really annoying, as is the lack of battery life. It’s still better than daily charging for something like an Apple Watch or Samsung Watch.

There isn’t good support for step tracking unless I have an app on the phone all the time. Not what I want and I miss this a bit since my Fitbit was lost.

The band isn’t great, though that’s on me. I should get an aftermarket band that I like.

How Long Should This Last?

That’s a good question. The Pebble warranty is one year. I’m obviously past that. As a comparison, Timex provides a year as well. 30 days replacement online, then warranty replacement.

However, I’ve usually had Timex watches last for 4-5 years. This seemed flaky at 14 months, which feels a bit like too short a period.

What would I want? If this lasted two years, do I think that’s OK?  I think crossing a year mark has psychological significance. Now it feels like a one year old watch, but if it made it to December, that would be two.

Ultimately I’m not sure. I know some people have had these last a couple years, so maybe that was just my luck.

The Verdict

The Pebble does most of what I need and want, and it’s been a good watch. I’m disappointed in the screen tearing, but it’s not unusable at this point. I can’t think of much more I’d want other than constant step tracking.

I’ll need a replacement this year, I’m guessing. There is a Kickstarter for the newer Pebble 2, which will have heart rate monitoring. That interests me, as does the Core. The idea of not needing a phone and just carrying the Core is nice.

I’m not into color or a lot of other features, and don’t like charging. The Apple Watch is out for that reason (and likely other Android wear). Pebble 2 is interesting, as is the Microsoft Band, but I’ll have to think a bit. Maybe I’ll go steel and see if that’s more durable?

At the end of the day, I think Pebble is a good device for your wrist, if you want one.

What’s Your Area of Expertise?

I ran across a great quote that made me laugh, but also struck me as being quite true. The quote is from Scott Curie’s post on the PASS Summit Speaker’s Contract and goes like this: “You would laugh at a lawyer who tried to build their own data warehouse, so why would you try to write your own legal agreement?” Having used lawyers for a few contracts, I am well aware that I’m not remotely qualified to putting together a detailed contract. I know if I need a business agreement, I need to either use a lawyer, or make it really simple. “I’ll cut your grass and you’ll give me $25” is probably the last well written contract I wrote.

We all have strengths and useful skills, things we are really good at performing. We often improve those skills over time and may develop some level of expertise in our field. However, even if we were the best T-SQL coder in the world, or the hands-down, acknowledged world-renowned expert on replication, that wouldn’t mean that we necessarily had any skill in some other area of the SQL Server platform, such as Integration Services. We might know something, we could learn, and certainly be competent quickly, but would a company that had a mission critical, multi-TB import or export of data want us to patch their ETL process today? Probably not.

Usually when we have a problem with a specific technology, we want someone that knows that technology well to guide us or do the work. The same thing is true in business. If an inventory specialist questions the way some system works, or a financial guru wonders about the calculations in an application, we should defer to them and ensure that we can explain how the code works, double checking the accuracy. After all, specifications could contain bugs as easily as code, and an expert in the end user of software might have a better idea of whether a system is working properly than the developer.

We should remember that when we venture outside of our own area of specialization. Many technology professionals are quite intelligent, but they aren’t going to be experts in all problem domains, and they shouldn’t present themselves as such.

Steve Jones

The Voice of the DBA Podcast

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

The Coffee Routine

My daughter had a birthday recently, and one of the things she asked for as a present was a French Press. She loves coffee and is willing to wake up 15 minutes early each day to grind beans and make a nice cup of coffee each morning before high school. This has been a routine for her this past year, one that has generated requests for me to return home from my trips with new coffees for her.

In a chat with Andy Warren recently, he mentioned that his new company has a few different coffee machines, with different choices available for employees. Some simple machines, some French Press, and other ways that employees can get their morning coffee fix. This is a small perk, but one that often goes a long way in the technology world as many developers I know aren’t morning people. They appreciate getting coffee provided by their workplace.

This is in contrast to the situations I encountered early in my career. Back then there was no Starbucks available during my commutes, in fact, with few choices for coffee shops. I started in a large company where each department was in charge of their own coffee. We pooled money together to buy a cheap Mr. Coffee (replacing it ever year or so) and each of us contributed to fund to buy a large tin of Maxwell House every few weeks. I’m sure quite a few of you couldn’t imagine that scenario: cheap, bad coffee every day. In other companies, the same Mr. Coffee was provided, along with the buckets of ground coffee. After a decade and a half in this business, I finally worked at a company where we had a better machine.

I was thinking about this on my recent trip to the Redgate office( after a quick stop in Copenhagen where I was instructed to be sure to get a bag of coffee for my daughter). The Redgate coffee machines (4 of them) are all located on the ground floor, in the atrium. This means that anyone wanting a cup gets to leave their desk, or make a trip before a meeting, to the open area. Lots of conversations start here, and certainly there are interactions between departments that might not otherwise occur. Plus, we have great machines, as you can see in my video.

Despite the hassles, I visit the machines a bit too often while I’m there. At least 4 or 5 times a day, which means it’s probably good I’m not in the office full time. Now if I could only get them to put soy milk in one of the machines…

Steve Jones

The Voice of the DBA Podcast

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

The Lighter Side–Morning at the Redgate Office

I was chatting recently with someone about the coffee machines at Redgate Software. We have 4 of them, all located in the downstairs lobby, which provide a way for people to take a break from their desk or between meetings, and wander down for a cup.

They are great machines, and I show some video recently to share with a few friends,

I visit this machine often when I’m in the office, going between lattes and black coffee throughout the day.

High DPI Test

On my new machine, running at a high DPI, I have some DPI issues.

2016-03-17 11_52_25-Settings

One is that I can’t seem to change the font for Open Live Writer. I see this:

2016-03-17 11_52_56-High DPI Test - Open Live Writer

Which isn’t what I want. This is a test to see how things render on the web when posted.

The Dangers of Algorithms

I ran across an interesting piece in Wired recently that talks about algorithms and the power they hold in the modern world. I don’t think it’s a great piece, and it starts to mix code, data, algorithms and other aspects of modern software in a way that seems disjointed to someone that works on software. I think there is come confusion about how data and software differ.

I don’t deny that there are potential negative impacts of the ways in which we process data. Certainly we have bugs in software that cause issues, but we also end up with implementations of specifications that may not quite match up with the expectations of our clients. Even in simple applications, if I’m not constantly interacting with a client in a detailed way, I find that the software can operate in a subtlety different manner than others expect. Of course, there are certainly people that deliberately program systems to intentionally help, or hurt, others, but I think we have just as many issues from small communication mistakes. That’s one reason why DevOps, CI/CD, and frequent releases are valuable. We get feedback quicker on the implementaiton of the design.

Does it make sense to disclose algorithms? Make source code available for examination? I definitely think there are intellectual property issues to consider, but when there are legal challenges or arbitration, I would expect that the actual code of a system can be examined. We definitely need to ensure that code examined in these cases is not part of the public record. However there needs to be open examination in such a way that the groups involved, and perhaps even other interested parties, have confidence that the algorithm performs as expected.

This becomes easier in databases, since our code is often easily accessible, but more complex in applications. Many of us realize that subtle changes in application code can cause issues for data, which is part of the reason we like declared referential integrity in our databases. That way we’re not affected if an application makes a mistake in enforcing our data integrity rules.

Steve Jones

The Voice of the DBA Podcast

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

A Bit of History

This is a bit off topic, away from the world of databases, but it certainly does touch on the power of computers.

I had a great 2015 holiday season, taking not one, but two vacations. Our family had their annual ski trip to Steamboat Springs, which is always enjoyable. However before Christmas, I took my 17 year old on a birthday trip to Florida. We’ve gotten away from parties and gifts, instead trying to give kids memories.

In this case, we journeyed to Cape Canaveral, spending a few days at the Kennedy Space Center viewing exhibits and going on tours. My son was thrilled to see real rockets, especially the Saturn 5, and also tour one of the launch control rooms. In fact, we could see the countdown clock active for the launch of a SpaceX Falcon 9 rocket on our tour of the Launch Control Center.

That was exciting to see. I’d tried to schedule the trip near a launch but couldn’t get away during the launch dates with school and work commitments. However the day we left, I saw the announcement that the previously TBD SpaceX launch had been scheduled during our trip. After a scrub one night with wind and rain, the launch took place our last night in town.

The official video is better than mine, which I recorded from the Cape Canaveral causeway, about 5-6 miles away. It’s an amazing piece of history. Other than my wedding day and the births of my children, this was the most amazing thing I’d seen, even from a distance. I’m interested in space and technology, but not a big space geek. However I was definitely giddy at seeing this bit of history.

Computing technology has helped us achieve some amazing things, and in conjunction with incredible engineering, as humans, we’ve managed to accomplish some amazing feats with rockets and space travel. I look forward to seeing what will happen across the next few decades as more companies and countries tackle new challenges in space.

And if you ever have any doubt about the power of the computers we use, it appears the Falcon rocket uses x86 processors, like so many of us.

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.

The End of 2015

I’m off on vacation, so I won’t be able to respond, but I decided to take a few minutes and look back at 2015 before leaving for the year.

This was a year that seems to have been marked by lots of data loss and breaches. Certainly these were on my mind as I worked on the SQL in the City keynote, but as I’ve been following Troy Hunt, it seems that every week or two he’s uploading more data to HaveIBeenPwned.com. We had some larger ones, with tens or hundreds of millions of account records released. Despite all the press from the Sony hack over a year ago, it seems that few companies have bothered to update their security. In fact, it seems that until they’re hacked, no one bothers to fix fundamental security issues in their systems. Perhaps some companies are doing so in the background, and aren’t being attacked, but I’m not so sure.

We didn’t have any SQL Server releases this year, but we had lots of news, and an unexpected Service Pack. Service Pack 3 for SQL Server 2012 appeared out of the blue for me. I hadn’t seen much news on it, and had given up on bothering Microsoft about new SPs for versions. Perhaps they’ll continue to build these yearly for supported versions, which is what I hope, but we will see. It does seem that Cumulative Updates have been appearing regularly, with relatively few issues in them, but I’m still wary of using those as the main patching mechanism for critical servers.

We did have a lot of growth in the SQL Server space, with many features being announced and starting to take shape. If you’re looking to get up to speed, check out our collection of Learning SQL Server 2016 topics, where we try to keep a growing collection of links to help you learn.  I am excited to see some of the growth of SQL Server to include newer features that people want in their data platform. I’m also glad that things like Stretch Database can be used to help manage the ever growing amount of data we have. Of course, encryption is big on my list, and Always Encrypted is something I am hoping gets lots of adoption.

We’ve also seen Microsoft really pushing the envelope in terms of data analysis. There is a constant set of articles and blogs written about data scientists, and some of us are moving to learn more about how to better analyze data. Microsoft continues to help, with their forays into Machine Learning, the expansion of the Power set of products (Power BI, Power Query, Power View, Power Pivot, etc.), R language integration, and more. I suspect that more and more of us will get the chance to play with some interesting data analysis tools if we want to. Even if you don’t use those to help your business, I have already seen these tools being used to perform index analysis, DBA monitoring, and more. I’d urge you to let your imagination run wild and see what things you might build.

It does also seem that more companies are starting to realize that their data and its integrity and management are important. Data professionals are becoming more valued, but the skills required are growing. There are more and more services and tools to help us manage systems that I do think the simple DBA that administers backups and security is really on the decline. At some point, our employers will demand more.

It’s been a good year, and I look forward to 2016. If there are things you want us to help you learn about, leave a comment here, and I’ll review them when I get back from vacation. Have a safe, Happy New Year, and I’ll see you in 2016.

Steve Jones

The Voice of the DBA Podcast

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

A Few Days Off in Space Country

The new Star Wars film opens today, and while I won’t see it then, perhaps I’ll get to it early next week in the shadow of the US space program.

My middle son is in his last year of high school before he goes off to college and as his birthday present in 2015, I’m taking him down to Florida and Cape Canaveral for 4 days. We leave early tommorrow, not returning to Denver until late Tuesday.

A couple days of vacation for me, and hopefully some memories for my son. He was there a long time ago, at 2, so he doesn’t remember much. However he’s interested in flight and space, and looking to study aeronautical engineering in college, so this is a treat for him. In fact, when we were talking about where to take him, his eyes lit up when I suggested this trip.

It will be an interesting trip, with the chance to visit the Kennedy Space Center, meet an astronaut, and study some of the history of US space travel in person.

I’m also excited to go. Not that I want to go into space, at least not until they get artificial gravity, but I find the subject fascinating and I felt rushed the last time I visited. It will be nice to be able to spend time and not hurry around as we get the chance to vacation together.

Enjoy your weekend, and I’ll see you briefly next week before I close down for the year.