Voice of the DBA

Author: way0utwest

Sabbatical Day 31 – Rounding

My company, Red Gate software, has given me a 6 week sabbatical. I’m documenting the time with all the posts under a tag

Finally, it’s starting to look like a flagpole.

I was hoping my router bit would arrive early Friday, but I actually got lucky and the UPS guy brought it late Thur night as I was heading out with my daughter on an errand. With that in mind, I got up Fri morning and started to work.

A Setback

I was prepping things in the morning and realized I had a problem.

My variable speed router has these wings for a collet and they prevent a large bit, such as this one, from being used. I have another router, but it isn’t a plunge, nor variable speed, and with a bit this large, you want it spinning relatively slow.

I checked a few sites and many people have recommended just cutting these off. I’ve never used them in the 4 years I’ve had this router, so I decided to do just that.

I grabbed my Dremel tool and added a metal cutting bit. I put the plunge base in a vise and went to work. Having cut metal before, I learned to put on long pants, long sleeves, get gloves, and use a hat with eye protection. My full face plastic visor was handy. It was slow, but I cut the wings off.

Now I was ready to work.

Rounding

The idea was to take the 45 degree cuts I’d made on each side and apply the roundover bit to create a pole. I set up the router with my bit and started at the top of the pole.

I went to work, cutting down each side and back up the other.

With a couple of trips, things were looking good.

I flipped it and managed to rout all sides. One wasn’t quite a clean cut as I think I cut a little deep with the circular saw, but overall things looked good.

Wow, a pole.

I started to sand the whole thing with 80 grit on the belt sander, but weather came in with some rain drops, so I bailed.

July 12, 2014
Administering Securely

This piece was originally published on Jul 8, 2009. It is being re-run as Steve is away on sabbatical.

The other day I noticed a post where someone was asking a question that I’ve seen asked often. I still haven’t seen a great solution, and I expect this question will continue to be asked for some time to come. The poster asked how to securely set up a database to prevent administrators from accessing the data.

Prior to SQL Server 2005 this was pretty much impossible. The sysadmin group was considered to be like a god inside the SQL Server and could access most anything. With 2005 there are more restrictions you can place on the administrator, and with the addition of encryption capabilities, you can prevent casual access to certain data.

However it’s not easy, and most of the time the system administrator still has access to data for tuning, troubleshooting, disaster recovery, etc. That makes sense sometimes, and I feel that you really have to trust your administrator with a lot of responsibility and discretion. Sometimes, however, it’s just not appropriate for the person that runs the server to see other data. Salary information, among other data, sometimes just isn’t the business of the administrator.

I don’t know how you handle this. Does the administrator just get access to the database as a container, able to attach it, back it up, restore it, and perform basic functions? Are they limited to setting security for users, but unable to access the objects themselves? I’m not even sure that’s a valid way to handle things since the administrator can always set up a dummy account for themselves, or change someone’s password and access data.

To me the best solution for secure administrator access is to have a second person audit all actions performed by a sysadmin. Kind of a default trace for sysadmins that is always running, and is not accessible to the administrator. Even then, it’s probably only something that works in larger companies where you have enough people to dedicate to the task of reviewing things. Maybe policy based management (PBM) will help here at some point, limiting the access to data by administrators in an easy to understand manner that a manager of some sort can understand and audit.

There’s no good solution now other than to trust your administrators to responsibly manage data, and that means hiring responsible people for the job.

Steve Jones

July 11, 2014
Sabbatical–Day 30–Knocking off edges

My company, Red Gate software, has given me a 6 week sabbatical. I’m documenting the time with all the posts under a tag if you want to follow along.

Today is day 30, really giving me just 3 days (plus the weekend) to complete things. Actually only 2.5 days as I fly out Monday to the UK.

I started today by uncovering things and marking out lines to taper the edges. My router bit should arrive tomorrow, and I’ll continue tapering, but for now I can get started by removing some wood.

The pole isn’t perfect and has a touch of warp in it, but I guess it’s no worse than a single pole I might have bought.

The plan doesn’t talk about this part, and the video says that a 3/4” line is what was removed, but with the top being 3” wide, I didn’t want to remove 3/4” from each side. I’d like to have 2” when I’m done, so I started with 1/2” at the top, moving to 3/4” at the end of the tapered part. The bottom 49” is straight, so I marked that and then chalked my lines.

I made two lines on top, but I wasn’t thinking. The saw only tilts one way, so I used just the left one to cut a 45” angle from that side. I flipped the flagpole 90 degrees and repeated this four times. Here’s after the first cut

At the end, I had a semi-tapered pole.

As I completed each side, I also did some sanding, trying to smooth out the pole. I had mixed luck with my Harbor Freight, cheap belt sander. I’m considering buying another one tomorrow.

With all that done, I inspected my work. I found a few spots that had space in them, which bothered me.

I hemmed and hawed a bit, but decided to use some of the epoxy and fill them. I mixed some up, thinner than before and spread it. I sprinkled some filler on top and then blended it in with a brush to get it to fill gaps.

I checked it after a few hours and it wasn’t perfect, but it looked much better. Tomorrow I’ll sand again and then taper with the router.

No class tonight with other commitments for my daughter, so I’ll be pressed to work on my project when I get home from the UK.

July 10, 2014
Sabbatical – Day 29 – More Glue

My company, Red Gate software, has given me a 6 week sabbatical. I’m documenting the time with all the posts under a tag if you want to follow along.

I got started early today, not wanting the day to get away from me, as the sabbatical has. Not completely, but it looks like I’ll be struggling to finish the flagpole this week and Monday is it.

Today I started by clamping down the top boards and checking the biscuit slots. I found problems.

The mark on the left is where I marked and cut the first slot. When the top didn’t fit, I removed a number of biscuits, lined things up and clamped them down. I then managed to re-mark (the right mark) and re-cut slots.

With the lower board done, things lined up nicely. I left it clamped and did the upper board, re-cutting many more slots there. As you can see, they aren’t far off, but it’s enough to cause issues.

With that done, I decided to quickly mix more glue and then get the boards moving. Once again, no pictures of the process because I was wearing gloves and didn’t want to get the phone stuck to them. I mixed more glue (7 pumps), which was enough with a touch left over.

The clamps went back on and with an afternoon commitment, I was in a hurry. This time I wished I had bought 10 more clamps Tuesday because these boards were more twisted. Not a ton, but more. As I looked later, a few spots were high and I am debating about mixing more glue and filling in spots.

In any case, I had a completed, albeit rectangular, flagpole.

July 10, 2014