My Endoscopy

I have not had much hospital interaction in my life. In high school, I had minor out-patient surgery to fix ingrown toenails. Then I worked at St. Joseph’s Hospital as part of the Y2K team when I was in college.

Yesterday, I was at the William Osler Health Center in North Etobicoke for an endoscope exam. I’ve previously written about the acid reflux issues that I have had for years; this was to see what was going on.

It was a series of firsts for me. I’ve never had an intravenous needle before – alright, that one is a stretch since I used to donate blood and platelets frequently. But in my mind these are two different things for some reason. The IV was to administer the sedative Propofol. Being sedated – even mildly like this – was definitely a new experience.

Honestly, I wish there was more that I could write about it. I was laying on my side on the gurney. The nurse provided a mouthpiece for me to bite on that would allow the doctor to insert the endoscope. Then I was suddenly in the recovery room. Just like that; light switch off, light switch back on.

Propofol definitely lives up to its nickname, “milk of amnesia.”

I did not feel the least bit groggy or dazed. My mother had accompanied me to assist with the trip back home, but she didn’t need to. Ah well, it was nice to see her again.

There is a follow-up with the doctor in a few weeks. All I learned is that my esophagus has become inflamed.

Fortunately, I have switched to decaffeinated Tim Horton’s coffee. That has provided at least a 90% improvement with the reflux. I should still lose weight as well; but I cannot seem to get motivated in that department.

Still Struggling To Get My Creativity Back

I am on-call this week and tomorrow we start the annual business freeze. Hopefully that leads to some quiet time; because the last two weeks have been a non-stop rush of changes and updates before the freeze hits.

Except for a little bit of playing around with World Machine, I have not touched any 3D or digital art application. My camera is sitting patiently in the camera bag – unused since getting that new bag weeks back.

I’ve also been feeling a little bit bummed out creatively speaking.

I realized a terrible mistake in my bell tower model and that has taken the wind from my sails for working on it. I created three rooms inside the tower structure and the aim was to have them connected via staircases climbing to the top belfry area. A little over a month ago, I decided to start exploring the modeling of the stairs – this made the mistake painfully obvious to me.

tower_mistakeThe rooms are ridiculously large when considering human-scale.

The orange lines are the geometry for the rooms and the black lines are the geometry for the tower. The grid is 1 meter. So the tower is 8 meters on each side and the rooms are about 6.25 meters on a side. The height for each room is about 7.5 meters.

It is the height that is causing the problem. That is over 24 feet! That would be fine for a huge building; but it causes problems in this confined space.

Modeling stairs fit for human legs means coming up with a switch-back or spiral design. So far, I have not found a way to make these stairs fit nicely inside. I would have to fill the room with stairs to make this work!

Just make the rooms shorter! Add a fourth room if necessary! Yes, I thought of that too.

The problem there are the window openings. I’ve carefully lined up the tower and room geometry for that. Changing the room height would mean re-doing the window openings completely. I suppose it may yet come to that if I cannot think of a better idea.

Hopefully I can get my creative juices flowing again soon. Not just for this problem but for getting out and just making stuff – pictures, landscapes, art, anything!

Bravo Australia!

I was very pleased to learn last night that Australians overwhelmingly voted for marriage equality. Excellent!

Every state and territory with the exception of New South Wales voted more than 60% “Yes.” New South Wales was just below the 60% mark. So love wins!

As I understand it, this result still does not make any binding laws. However, hopefully it sends a clear message to politicians that their careers will be in jeopardy if they fail to pass laws in favour of equality.

Advance Australia Fair!

A Bit Of Radio Silence

I haven’t had much time to post this week.

Things are getting crazy at work as we prepare to enter the holiday shopping season – obviously an important time for payment processing. Before the annual freeze-period, we’re pushing to get updates in place.

I bought a huge 8 TB external USB drive. I’ve been very busy backing up all my assorted digital assets from the 3D machine and this laptop. That took several days to complete but I hope that future passes will complete much more quickly. I had to keep the 3D machine shutdown during this time since I ran out of power sockets to power everything!

New Lego Architecture sets are here! The new Solomon Guggenheim Museum and the Arc de Triomphe are still in their boxes. I’ll try to start working on one tomorrow.

Southern Ontario got it’s first real chill-snap of the winter this week. It will get colder of course but the first one is usually still a shock to the system.

Finally, I’ll be turning on the comments feature here after many years. The comment spam has not returned for weeks now. I’ll switch them off again if the spam returns though. Hopefully I can have some interaction with readers.

PASS Summit 2017

Last week I was back in Seattle – I love that city! – for the PASS Summit. I’ve only been to two PASS Summit’s and at the first one, I begged Microsoft to hire me as a full-time employee. Imagine my shock when they did!

This time, I am shocked for a different reason. SQL Server 2017.

There is just so much awesome-sauce packed into this release; it is a challenge to know where to begin. A new release cycle is a good beginning. Microsoft has been on a two-year-major-release cycle for a long time now. It stretches back to SQL Server 2008 R2 in 2010. Now Service Packs are going away and Cumulative Updates will be monthly. I suspect we’ll see more aggressive major releases too.

Many people are salivating that SQL Server will run on Linux now. I already stated that I am thrilled to see the best database engine on the planet start eating Oracle’s lunch. But speaking professionally, this doesn’t blow my skirt up – I am a Windows man through and through.

Two of the most exciting advances involve Adaptive Query Processing. Now a compiled execution plan can have multiple paths that change dynamically at runtime. A join could be handled by a nested loop or a hash match depending on the number of rows being processed. Memory grants that are too large or too small can also change between executions. Both of these do not require recompiling the execution plan. This is incredible.

Availability Groups can now be built without a Windows Failover Cluster. This removes the high availability feature but it allows for a hot copy of data. Reporting queries can use the copy and take pressure away from the primary replica.

Columnstore Indexes, Query Store and In-Memory OLTP keep getting better. Smaller existing features and knobs are tweaked as well. SQL Server 2017 has me really excited.

Last, but not least, I was able to meet-up with former Microsoft colleagues. Adam, Rohit, Bob, Ajay and Tejas – it was great to see all of you again.