SQL Saturday and Horsethroat

Professionally speaking, I’m a technical writer, but I’ve been dabbling with putting on some other career hats the last few months. I’ve been doing some BA and TA-type work and have been trying to learn T-SQL. I even took a continuing education course to learn about writing queries. But as simple as T-SQL appears, compared to my experience with older languages like C, Pascal, COBOL, FORTRAN, and BASIC, it becomes very complex, very quickly in actual usage. It involves layers and layers of thought. It’s like trying to wind a logic ball of yarn.

Fortunately, I got a copy of Itzik Ben-Gan’s Microsoft SQL Server 2012 T-SQL Fundamentals when I took the course and I’ve been working through it from the beginning, trying to pick up the syntax. But before even getting that far, I had to figure out how to install the free version of SQL Server 2012 on my netbook and how to install the database from Ben-Gan’s website.

The book is solid, though. It’s very much a light textbook and includes problems and solutions. If you want to learn T-SQL, I think it’s a good place to start.

With all this background out of the way, my interest and dabbling outside my job scope scored me the chance to take a day from work to attend SQL Saturday at LSU’s E.J. Ourso College of Business. It’s basically a free conference and workshop put on by IT professionals for IT professionals. Whether you’re a developer, a DBA, a teacher, or even a tech writer, there’s something for you. I took five 1-hour courses. Four of them were pretty good and I learned a lot of neat stuff. The fifth wasn’t really helpful. I picked up a bunch of random tips and tricks, learned some stuff about SSRS, and discovered how to check the cost of my queries. All around, it was good stuff and I was pretty worn out by the end of the day.

There was a free lunch (jambalaya, salad, and a snack) and a whole lot of raffling with some nice prizes, courtesy of the sponsors. I’m talking Xbox Ones, Surface Pro 3s, Mac Airs, Best Buy and Amazon gift cards, training classes, and a bunch of other stuff. Oh, and some Star Wars cosplayers showed up to help manage the raffle. So yeah, Darth Vader posed for pictures with the raffle winners, while a little girl dressed as Princess Leia did some of the drawing.

I didn’t win anything, though, but got some nice swag, as far as swag goes. You just can’t go wrong with a T-shirt and a flashlight.

The moral of this story: Check out SQL Saturday if and when it’s offered in your area if you’re at all involved in IT. At the very least, you’ll get a swag bag and get to do some networking.

While talking up an IT conference sounds geeky, I’m about to turn things about another notch. I’ve been playing Pathfinder Society games for about a couple of years now and have met some cool people, usually guys my age that are professionals in various fields. Now, I’m not really into role playing or combat simulation as much as I enjoy the effort of collaborative story telling. So, that’s the draw for me. I also like the think tank aspect. Here’s a problem, how can you and your party members solve it with the resources at hand. For me, that’s fun.

I haven’t stepped up to DM any games, however. The rules system is expansive, ridiculously so, with new classes and rules being offered and revised on a regular basis. And I don’t play all that often, maybe once or twice a month. Either I’ll show up for a PFS game at the local game store or I’ll sit down and continue to play the home campaign I’ve been running with some friends (Skull and Shackles). I don’t live and breathe the books and the stories, which is a problem.

Unlike D&D, everything in Pathfinder happens in the same setting. Every novel or short story someone writes and officially publishes is part of that world. The dozens of books and adventure modules are all part of it.

DMing has just seemed daunting. Period.

But I’m ready to give it a try, but with a small caveat. As I’m between books and taking a bit of a break, I’m going to work on whipping up a mini-campaign to run with my usual group. I really, really loved the Distant Worlds campaign setting that Paizo published a while back, so I wanted to do something with it.

It was actually the first of the Pathfinder books I ever purchased, because it just seemed so interesting to me. The premise of the book is, yes, there is the main earth-like world (Golarion) where all the usual stuff happens, but guess what? There are another 9 planets in this solar system loaded with ancient mysteries, aliens, and evils.

One of the worlds in particular, Aballon is the focus of my mini-campaign. It’s a Mercury like world, extremely close to the system star. But it’s populated by a race of intelligent machines left there for unknown reasons. The machines, solar powered, toil away on the surface, mining resources and building and rebuilding themselves. The planet also features deep wells of ice that are shaded from the sunlight and support limited organic life. The largest of the wells features an archway that is actually a portal of some sort. And it has brought dozens of people from the main world for also unknown reasons.

So, there’s this barely surviving town, Horsethroat, in the pit of this frozen jungle where these people are trying to survive. And only one of them, a wizard of some power, is capable of using powerful enough magic to explore the surface safely and to communicate with the machines. Some in the town suspect he’s responsible for them ending up in this frozen hell hole. Others thing he’s just a puppet of a greater power. And a few more believe themselves to be chosen to live in this refuge while the world they came from is destroyed by wrathful gods.

It’s a great little setting and it’s easy enough to drag PCs into it. I’ve been working on it on and off, developing situations and NPCs. I intend for it to be a fairly low-level affair, which is hard to do when you need to be like 9th level just to cast the magic you would need to not flash fry and/or suffocate on the surface of the planet.

I also have a few things in mind that can act as bridges to more adventures if my group enjoys the experience. I can even tie it into Iron Gods (an adventure path dealing with ancient, but highly-advanced technology).

So far, the biggest problem has been limiting the scope of what I want to do. There are so many mysteries in this solar system and even though I can devise scenarios and shocking explanations for how they came to be, I can’t just give those to my players. That would basically be just fan fiction. Instead, I need to just keep a basic framework in mind and flesh out the areas Paizo hasn’t really gotten to. But even then, I have to write the adventure so my players just get a potato chip at a time, so they’ll always be wanting more. If I hand them the bag, they’ll be sick of chips for a long time after.

1,792 Stream Processors and a Couple of Beers

 

I got the Gigabyte R9 380 4GB graphics card in the mail last Friday. The box was pretty slim and didn’t contain anything other than packing material, a quick install guide, and the card. I kind of thought there would be a disc with some Gigabyte utilities, but nope. I installed the card in the desktop with no problem. See the picture below. The “Windforce” text lights up blue when the fans come on and that’s pretty cool and fits with the blue LED fan in the front of the case.

20150722_205337

The only tricky part of the install was I didn’t uninstall the old AMD drivers, because I didn’t want to uninstall the A10-7850k’s graphics. I was hoping the Catalyst utility would have detected the new card and prompted an update, or even Windows, but both seem satisfied that the A10-7850k was installed and didn’t care about the new card that was currently running everything. So, I went to AMD’s website and manually selected the drivers and installed them.

For the price, it really is a powerful and relatively low power card. It kept prompting me to run Windows with Virtual Super Resolution turned on, but I passed. I made a few more tweaks, like capping the FPS at 60 with Frame Rate Targeting and adjusting the desktop size to get it to fit on my TV screen properly.

As far as gaming, I tried several different games, but I don’t have a benchmarking tool and the most graphically strenuous game I have is either Alien Isolation or Civilization Beyond Earth. I ran Alien at 1080p with everything I could turn up to max up to max. It looked great, but I think the character model teeth, lips, and tongues could have used some more work. And there is so much dust floating around in the air! Do none of these spaceships or space stations have dust filters on the air intakes?

Civilization Beyond Earth doesn’t look much better than when I run it on my other desktop with an old Radeon 6850, but I also didn’t play more than a few minutes. There was a lot of screen tearing whenever I panned map, too. I suspect I need to play around more with the frame rate targeting, vsync, and my TVs refresh rate.

To sum up, it’s a great card. It’s quiet, seems to run cool, has some nice power saving features, and can max out any game I currently own. If the price on this card creeps down with a holiday sale or the release of a 380x, it’ll totally be worth picking up. There are plenty of benchmarks out there now if you want to see some hard numbers.

As far as the card being bottlenecked by the APU, I haven’t experienced it, yet. And I’m not sure I would know if it did happen. With Windows 10 dropping soon, I suspect if the problem does it exist, it will be mitigated somewhat by DX12.

After installing the card, I felt the need to do a little celebrating. Below is an 18% ABV stout by Mikkeller that I got on sale at my usual pirate-themed haunt. I think it’s just called “Black,” but the site seems to indicate it’s called “Black Fist.”

Whatever it’s actual name, it does hit hard up front and finishes a little bitter and smokey on the back. It’s not an every weekend beer. I’m not sure it’s even a once a year beer. Best just to split a bottle with a friend or three.

 

20150718_205922

Since discovering Hitachino Nest’s beers, I’ve been working through their offerings as I’m able. I got to try XH and didn’t want to pass up the chance, despite putting down the above mentioned monster. While I love me some sake, this one just didn’t measure up to my expectations. I could catch a hint of the sake–the dryness of it–but not much. Just stick with the Red Rice Ale.

20150718_214324

 

Closing this one with a shout out. Check out Dirty Coast. It’s a locally-owned clothing and art store in New Orleans. They have some pretty neat stuff and also sometimes run events to benefit local charities. Check out their website or visit one of their stores in the Crescent City.

Verified by MonsterInsights