Voice of the DBA

Author: way0utwest

Cool Projects

This editorial was originally published on Aug 23, 2013. It is being re-published as Steve is on vacation.

I had a conversation recently with a developer that was working on a rather neat problem. This had to do with a financial system and it involved some complex calculations and real time interactions with a variety of systems. It was important for their company, and a lot of pressure was on this developer to not only deliver this software quickly, but also to have it perform at a very high level. This particular person was using Red Gate’s ANTS Performance Profiler to dig into their code, feeling pressure to make it as efficient as possible.

However this developer was also enjoying the work. It was a challenge, and it was a cool project.

I know this community is made up of people working in all sorts of industries, in a variety of roles. We develop many different kinds of software. Some may be for employers, some may be for ourselves, some may be for a side business, but across that spectrum of work, there are some interesting applications.

What cool things are you working on?

It might not be software. Perhaps you’re working on an interesting data application, like a super collider. Maybe you work on some gaming software or a large hardware system. Perhaps you deal with a system that makes people’s lives better, easier, or even possible. I’m sure more than a few of you work on some real time systems, which have all kinds of data challenges.

Let us know this week what type of interesting work you’re doing.

Steve Jones

July 14, 2017
T-SQL Tuesday #92–Hard Lessons

A quick post, written last week as I’m relaxing in the mountains.

This month the topic is lessons learned the hard way, from Raul Gonzalez. It’s interesting, and certainly one where I have experience. I make mistakes regularly, though I tend to fix them.

You can read more about T-SQL Tuesday and learn how to participate, or even respond to old prompts at tsqltuesday.com.

A Hard Lesson in Preparation

I worked for a financial services company at one point, managing the live systems as well as performing database development. I had a few people working for me, some in each area, and we had contracts with a number of clients. Quite a few of these contracts specified a yearly DR test at a remote facility.

The first year I was there, we packed up tapes and documentation, carpooled for 4 or 5 of us as if this were a disaster, and started rebuilding systems. Our contractor supplied xx servers as per our contract, and we had to start from scratch.

We didn’t do well, and couldn’t get our web app or client server apps running completely. The db restored, but the system and docs were out of date. I knew this, and we updated some things, but we didn’t take the process seriously.

A few months later our largest client was unhappy. Since we couldn’t get the website running, they wanted another test. At their site.

Myself and another were chosen to fly to their site, shipping out spare servers and software. We had to wipe the drives and rebuild the system from scratch. Since the two of us had been at the DR test, we assumed we’d learned enough to do this in two days, sure we could rectify all the mistakes from the test team.

We couldn’t. After two days, we didn’t have everything running, with too many dependencies and issues from various web components. Our developers had been running wild, with admin access to the webserver and database server, resulting in wonderful unique, snowflake servers that were hard to reproduce.

Inadequate preparation, as well as poor security for years, contributed to the failure. I did get the database working, but that didn’t matter since this client used web access only. I had to take a large portion of the blame since I managed systems, and our company paid a penalty.

It was embarrassing for me, personally and professionally. I hadn’t done a good enough job being ready for a disaster. This did server to motivate me to start cleaning up the systems and ensuring we could rebuild a new web server if needed, but it was a hard, and expensive lesson, to learn.

July 11, 2017
Taking a Break

No blogging this week. I’m taking a much needed break in the Colorado mountains with my family.

I’ll likely be unwired for the most part, so not responding to email, tweets, texts, comments, etc.

Enjoy the week everyone.

July 10, 2017
Bash on Windows

With SQL Server coming on Linux, some people will want to learn a bit of Linux. Or perhaps they need to get re-acquainted with the OS, which is my situation. I grew up on DOS, but moved to Unix in university. I’ve dabbled in Linux over the years, but with no real use for it over Windows, I abandoned it a decade ago.

Now, I’m trying to re-learn some things as I play with SQL Server on Linux.

Recently I saw a quick video from Scott Hanselman on the Bash subsystem in Windows. I actually first saw this live at the Build 2016 announcement, but when it was added in Beta to Windows 10, I didn’t add it. I’ve been meaning to, but hadn’t.

Until today.

The video shows, but there are two things to do, well, really 3.

First, enable developer mode. In the W10 Control Panel, type “developer” and you’ll find under Update and Security, a “For Developers” option. I’d enabled “developer mode” before, so that was done for me, but check that box (shown below).

Next, hit the Windows key and type “Windows features”. You’ll get this:

Click that, and in the dialog, scroll down. You’ll find the Windows Subsystem for Bash. Check it.

Then Windows will tell you to reboot, so do that. After you reboot, type “bash”.

The command “bash” will open the shell. Once you do that, you have bash running.

There are options here, though I’m sad this doesn’t integrate into my ConEmu terminal. Maybe soon. The first thing I did was raise the font, because, well, I’m old.

I’ll have to play around, and get familiar with bash again. I won’t use it a lot, but it could be handy when working with SSoL and needing to SSH or otherwise connect to that vm without firing up rdp or my VMWare console.

I don’t remember lots of commands, but I did manage to get to my C: drive.

July 7, 2017