Microsoft Dynamics basics.

Dec 22, 2020 | ,

I attended a training course provided by New Horizons today on Microsoft Dynamics Fundamentals. I have been looking forward to this. Dynamics is something I have been supporting from an integration and technology perspective for years, but I have not really had any day-to-day exposure to it on the end-user side.

I was a little worried at first when I was the only person on the course, but it has turned out well. I am only a day into a two-day course, but we have already covered most of the content and a lot more that was not quite scheduled to be covered. The main revelation though is the core data schema that Dynamics uses.

First: Microsoft are moving to a new way of describing the data in Dynamics. Instead of entities, there are tables. There are also now rows and columns instead of records and fields. This makes the entire thing much easier for me to understand because it aligns it with standard database terminology.

There is also this thing called the Common Data Model. This is a crucial part in the puzzle.  It describes the data schema used in Dynamics.  It is not just Dynamics that uses this either. SAP does as well from what I understand.  But even better, the CDM Common Data Model is documented on Git hub.

There is also more Microsoft specific documentation on the CDM here.

There is also the Common Data Service. This sits on top of the Common Data Model.  I am not going to try to paraphrase the document that is written out there by people who are much more knowledgeable on this than I am.

The reason I am writing this blog post is to say that now that I have a better understanding of this core part of Dynamics, I am more confident with other parts like field security mapping, form security, views etc.

I might have come to this at a good time actually.  So much of Dynamics is now moving to Power Platform. Making a UI using Power Apps is very straight forward.  Although, I need more time to explore this. I am still stuck connecting the right entities in my site map.  Looks like I have some exploration to do over Christmas.

I am looking forward to tomorrow. The instructor on this course is very happy to move along at a much faster pace than normal and he has been able to answer most of the questions I have thrown at him.  Tomorrow we are going to look at data imports and exports. But I am hoping to send a few more questions his direction relating to custom workflows in Power Apps.  We looked at that very briefly today, but I would really like to learn more before I go off and get stuck into this independently.

Saturday night Server updates – Covid-19 passtimes.

Dec 20, 2020 | , ,

I genuinely think that being a system administrator or as I’m known now a senior system engineer isn’t a 9 to 5 job. Well, it never has been for me anyway. I remember as a young child, I couldn’t understand why my aunts and uncles had absolutely no interest in talking to me about their work when I met up with them on the odd ocasion during Christmas, family weddings or other celebrations. To me, talking about what they were working on was interesting! I wanted to know about what they did, the rewards, the challenges, what they needed to learn to get them into those positions and what I should do next. One part of my family are highly technical. They are in great jobs in companies that are recognised in areas of security, micro processors and networks. The other side of my family are involved in more hands on occupations. Funny, I have much more in common with the members of the family who are more hands on because they seem to take more pride in what they do. They also have no problems talking about their successes, their failures or jumping in at a moments notice to give a hand. Both sides of my family have always jumped in to lend a hand when they were needed so please don’t get me wrong. In fact, I got my start in computers by talking to one of my uncles during countless times where I completely messed things up with my first PC in the early 90’s.

But the point is, even on Christmas morning, when everyone gathered in my grand mothers house across the road from where I live now, I would be buzzing with anticipation of what new things I could hear about the technologies they were working on that year. Without fail, I would leave disappointed that they just weren’t interested in talking about work. I couldn’t and still can’t understand how they devoted countless hours to an occupation that they wouldn’t have an interest in talking about.

It’s for this reason that I sat here tonight updating servers. I have been watching a series on Netflix called Suits this week. I never sit down and just listen to something on the television but I have had a lot of time on my hands this week so I’ve been using it to try to actively remove myself from stress and over thinking about things. But tonight I sat down and while listening with one ear, I decided to check on a few sites that I follow. I noticed that there was a patch released that I was waiting on that fixed a few bugs in some software that I use regularly. This got me thinking so I logged into the server it is running on. I’ve spoken here before about getting lost down the rabit hole and this time is no different. I noticed that there was a new security update and several parts of it directly related to another server that I had been thinking about this week. So I decided to go ahead and apply that update. While waiting on the updates to apply, I decided that a bit of code that takes logs from the 2FA provider that I’m using could be more efficient. This is something I thought of while walking the dog one of the days during the week. The address field comes back as a complex object. But by converting it to a string earlier in the process, I can save bandwidth and make it faster for the UI components to display it. So as one of my uncles would say, I decided to “Trick around with that a bit”. I’m very happy with the results. I caught up on another few episodes of suits, a few servers have patches applied and I’ve made a function more efficient. To me, that’s the recipe for a great Saturday night in. I don’t really see this as weird. I see it as a natural extension of enjoying what you do. when you are lucky enough to enjoy your occupation, the lines between it and everything else naturally become less defined or pronounced. I’m not in a position to play much music at the moment. Technology and music are my two major passions in life second only to my family. When this crap of Covid-19 is all done and over with, I will promise that technology will take a major back seat for a while. But for the moment, it’s keeping me quite happy. There’s no where else I can go. I’m keeping my distance from people so that I can visit relations without concern of passing something on to them so if that means I log in from time to time and get a little bit of work done even during the Christmas holidays, I am absolutely fine with that.

Chair walks. – Part two.

Dec 17, 2020 |

Way more of you than I expected got back to me with chair walks. The post I wrote back in September. This part two was actually shot in October but I was way too lazy…………Busy to get to posting it until now. Thanks to all of you who left comments tweets and Emails when I posted the last post. This motivates me to do more of the same and makes this blogging thing worth doing twenty years on. Imagine that!!! This was started in 2000 when I was still in college as a simple project as part of a module and it’s still going.

  • Red brick building with an entertaining sign. Very old.
  • Picture taken from the new steps at the train station in Drogheda.
  • Looking at the Boyne from the steps at the train stations viaduct is near here but out of frame.
  • Shows St. Peter's church in the distance. Looking over the boyne. Framed by over hanging bushes.
  • Show's St. Peter's church in the background. This is zoomed out.
  • Taken from Dominique's bridge. Looking Domican church is reflected in the water.
  • Taken from the car park bridge at Scotch hall. It is shot here because it's a weird vantage point.
  • Shot at the bridge at the battle of the Boyne site.
  • Looking through the bridge at the battle of the Boyne site. This looks onto the boyne.
  • Looks along the Obelisk bridge at the battle of the Boyne site.
  • Looks along the Obelisk bridge at the battle of the Boyne site.
  • At old bridge. Looking over the water of the Boyne river.
  • Looking over the water of the river Boyne at old bridge.
  • The start of the Obelisk bridge. Looking at the old brick work.
  • Méabh and Rían sitting on the canal bridge in old bridge. Looking out over the water.
  • Rían sitting with Kaiser looking out over the canal at old bridge.
  • Méabh sitting with Kaiser looking out over the canal at old bridge.
  • Kaiser sitting on the bank of the canal
  • Light shining through the trees at Old Bridge.
  • Picture taken low over the water. There are reflections of the tree and environment showing in the water.
  • Landscape picture zoomed out. Showing the stone wall circling Old bridgeestate.
  • Emma, MéabhandRían walkingon the out sidepath of the gardens in Old Bridge Estate.
  • Emma Méabh andRíanlooking through the fence in at the gardens ofOld Bridge Estate.
  • Rían running on the path. One of many poses during this run. :)
  • Rían running on the path. One of many poses during this run. :)
  • Rían running on the path. One of many poses during this run. :)
  • Rían running on the path. One of many poses during this run. :)
  • Rían running on the path. One of many poses during this run. :) Zoomed out.
  • Me walking with Kaiser in to Old Bridge. The fence is on the left. Grass is on both side. This is a pedestrian path.
  • Ripples on the top of the water.
  • Kaiser, the dog and me walking over a very old wooden bridgeused by fishermen who travel the short distance between the Boyne and the canal
  • Kaiser looking up at me while we walk across the bridge. Probably saying that this kind of crazy work isn't in his contract!
  • Looking down into the water at the canal. The water is very calm and there is a lot of colour shown.
  • Kaiser and myself on the stone foot bridge on the walk way in Old Bridge.
  • Méabh and Rían sitting on the stone foot bridge in Old Bridge.
  • Darker picture of the water. There's more contrast in this. The water has a slight shimmer.
  • Leaves floating on top of the water in the canal.
  • Close up of a plant.

Blog problems fixed. Without a complete rebuild

Dec 17, 2020 | ,

It has definitly been a successful day.

Hard to believe that I’m already at day 3 of my annual leave for Christmas. It has still been quite busy. Although my DCU responsibilities have taken a back seat, it seems that there are plenty of people still waiting for me to do something. Of course there’s also my own stuff that I’ve neglected for quite a while so today I spent time updating more of my own servers and of course, fixing this site.

You should notice now that the blog looks a lot better. Posts are shown in full on the main blog page, Dominique requested that at the start of the year and I promised I would get to it. Also, there’s more colours to distinguish between blog content, meta details and the post title. I finally updated the spacing slightly to make it easier to read. My sisters always reminded me to leave a small margin at the left. But over 20 years on from designing my first website, I still forget to do it.

Turns out that the problem with Divi was file system permissions related. Something changed with this latest version of php7 and the permissions that worked perfectly fine up to now needed to be changed. However, I don’t mind. The site is actually running quite a bit faster with this latest version of PHP.

Let me know what you think. But, please. Stop writing me Emails. 🙂 Leave a comment! 🙂

WordPress problems

Dec 15, 2020 | ,

I have had problems with this website today. Most of them are actually server related but are now fixed. PHP has been updated, the cache has been properly configured and permissions are properly configured with a policy of leased priveledged. But I’m still having trouble with WordPress. Mainly because this site is kind of old and it has been updated a lot with new functionality over the years.

I hate to say it, but I think it’s time to start from 0. I’m going to replicate the content to a new site and reconfigure everything from the ground up.

I have the time at the moment so I might give this some consideration tomorrow after I bring the dog for a walk.

Let the holiday begin

Dec 15, 2020 | ,

Ah it’s funny.  it’s the end of my first official day of annual leave for Christmas.  I had time to take off so I decided to extend my Christmas holidays by a little.

Staying true to form though, the first part of my time off was spent putting this video together for a local group called the Loving Life Choir.  Here are two of the members singing silent night.  With social distancing etc, this is about the most we could do for the choir right now.

(12) Silent Night – Loving Life Choir – YouTube

I did everything for this video. I recorded it, edited it, I defined the shots that I roughly wanted to get.  Emma, my wife captured the videos then I edited the clips and added the previously edited audio.  It’s not perfect by any stretch. But I’m neither a videographer, editor, audio engineer or professional musician for that matter.  But For my current skills in these areas, I think it’s okay.

On the technical side of things, I decided to upgrade my wireless network controller at home in the small hours of Sunday morning.  I couldn’t sleep and it was something that I had been putting off.  I’m running Ubiquity kit here in the house and it’s been a bit about a year since I updated the controller.  Unfortunately this latest version has quite a few changes that break my config.  I have, or rather I had, different networks and SSID’s attached to different access points.  This allows me to have different firewall rules for my cameras, my smart lights and the standard wireless network.  Also my smart lights are very particular about what channels of the 2GHZ band they want to work on so by having a specific SSID that they connect to makes it much easier to troubleshoot when something goes wrong.  I have some work to do now to replicate the old config on the new version of the Unifi controller software.  I’m looking forward to it though.  Now that I’ve figured out why all my smart lights have suddenly stopped working.  Perhaps I’ll document this to make it easier for others to find the solution.

Innovation verses service excellence.

Nov 20, 2020 | ,

I was at a meeting outside work about two years ago.  This local interest group were making the point that they should get what they want because when you combined this number with this other number, The answer was bigger than any other answer in the country. What they were saying was absolutely correct and no one in the room could disagree with them. Technically, what they were saying was correct but in reality, those numbers were not permitted to be added as for the sake of this story, they were in two different datasets.  I left that meeting wishing that I had this skill. To make an argument by shaping language and facts into irrefutable shapes  that were actually quite logical even if they didn’t actually comply with rules of law or common sense.

There’s another example of this kind of conversation shaping that is actually a lot easier to explain.  I was on a sales call a week ago. It was going reasonably okay up until the Q&A at the end.  It was then that I noticed that even when a feature that was request wasn’t supported by this system, the sales person started every answer with a posative yes and also finished his answer with a yes or a posative statement.  Here’s an example: Question: Can your application support backing up specific databases. Answer: Yes!!! MSSQL is a brilliant database management system. I love that we can set the recovery model to simple and not full so that simple means circular logging so where an application such as ours doesn’t actually tell SQL that we have made a backup, the SQL transaction logs won’t grow to fill the database server volume. So yeah. That’s a great feature. I love that question!  Clearly he’s saying that he can’t support that functionality, but his answer is much more posative. Even when his answer is no, it’s still yes.

So now I get to the reason for this topic, I had a conversation yesterday where someone told me that there was a discussion necessary where the policy decision of Innovation verses service excellence needed to be made.  Did they want to be quick to innovate or did they want to provide the best possible service, up time and reliability to their end users.  Well, of course, when this question is posed, anyone in their right mind is going to say that service excellence is the most important quality.  By shaping the question in this way, the answer is already established.  But it’s a perfectly reasonable question. Innovation and service excellence aren’t mutually exclusive aspirations. It requires planning, proper resourcing, good people, a clear strategy and methods of measuring and rewarding success. Sometimes, it also requires a bit of good luck as well. Why? Because things will break. Companies that embrace devops culture seem to be attaining a build fast, break fast and fix fast philosophy. This approach makes so much sense to me.  Build repeatable scalable and fault tollerant services based on even more repeatable, scalable and fault tollerant infrastructure. Everything should be a template. If something isn’t automated it should be pushed out the door as quickly as possible.  Anything that’s absolutely business critical that can’t be automated should have a very poor SLA to encourage who ever is buying the next latest and greatest solution to think more about how it fits into this modern ecosystem. I’ve dealt with a company recently that operates this way. I was really impressed by the speed that they operated at.  Unfortunately, the person who had this conversation with me is highly intelligent. The other people he will be talking to are no slouches either. But I worry that he’s one of those brilliant people who shapes questions and statements that are perfectly logical and in the moment, anyone would be hard pressed to disagree.

To not call out my own bias here would be unfair. I am driven by innovation. It’s what gets me up in the morning and keeps me here well into the night. I am willing to acknowledge that the idea of service excellence may not hold equal weight.  However, the mantra of the first company I worked with is still with me today.  Exceed Customer Expectations. I worked with a company that instilled the principal of customer satisfaction with every encounter. So I understand it’s value. I also come from a family of small business owners so I know that the customer is the person that keeps the lights on.

Chair walks.

Oct 22, 2020 |

Emma came up with the name chair walks for these pictures that I’m taking. Speaking of Emma, she arranged all of the photo’s today. I took hundreds of them from different angles and she picked out a few that actually didn’t show my feet, or someone elses feet. :). Seriously, I modify the angle that I hold the phone at several times for each shot and she picks the shot that actually turns out right. She is really busy making things right now so I appreciate her time on this.

Come with me for another walk through Drogheda today. This morning the route was very different. I also used a different lense on the iPhone. It’s the 18 mm lens from Moment.

At the top of Mary’s street looking toward Gerard’s church
Steps to the old school house.. Someone said this could be an album cover.
The famous Millmount tower. Fondly refered to locally as the cup and saurcer. Or in Drogheda, the cup and sawsaw.
Autom is starting to show.
Going from the Dublin Road to Shop street
Looking over the Boyne toward Scotch hall.
More churches in Drogheda.
This junction is usuall packed with people. Today it’s just traffic unfortunately.
Bad timing!
The dominating land mark in Drogheda’s golden quarter mile.
It was a lot quieter here today.
Personally, I actually love all the hills in Drogheda. It makes the walk enjoyable.
Looking toward the council offices on Fair street. Where all the really really really important work get’s done.
I don’t know why I bothered taking this one. I suppose I took a picture from the other angle yesterday so I thought, why not. This is the least interesting corner / junction in the town. I don’t know what I was thinking.
ON nearly every street in Drogheda the old is mixed with the new.
Looking at Clarkes, one of the oldest pubs in Drogheda. Carberry’s is the oldest I think.
I managed to catch the dog while working again. Delighted with that.
This is a really lovely quiet area.
I think Kaiser loves this part of the walk. He knows I have no idea how to find the paths around htis area so he loves taking the initiative.
Just like that, we are out of John Paul Court and back to the busy north road.
Joe Reid runs Floor Style, a shop just to the left.
By this point, Kaiser is thinking “Ah come on dArragh! There’s no foot paths!!!”
Looking over at the Coffee box in the Fair green. I must pay this place a visit soon.
Fair green. It’s a busy spot in the centre of town but most people never go in here.
Imagine having to travel to work in the morning? I feel very fortunate at the moment.
There’s a park down there. Not like our children will get to use it much now until next year some time unfortunately.
I wasn’t really expecting this picture to work out. I’m glad it did.
Traffic around Drogheda is mad today but it’s light here for some reason.
I must find out more about this place.
I didn’t even know this path way at the bottom of the hill existed until earlier this year.
This is a really nice quiet area to walk through.
A horse lives in on the left. It regularly sticks it’s head over the gate to get some attention.
Lots of happy children in that school this morning as we walked by.
Delighted I got some pictures from Kaiser’s perspective today. I had been trying to do this for ages!
Probably thinking, “When are we finally going home?”
And just like that we are back on the main road and the tranquility is gone.
Emma said, “I didn’t know that Guide dogs came with a hinge! :). Kaiser is playing after a hard morning of work.

Come walk with me.

Oct 21, 2020 | ,

A few of my posts lately have been a bit negative maybe. So let me change things up a little. Come for a little walk with me around Drogheda. I walk about 5km every morning before work. Today took me a little further than usual. We walked just over 6.5km just because the mood took me and it was a very mild morning.

I have included pictures of most parts of this morning’s walk. I forgot to take a pictures of a few places but you will still have a few nice places to look at.

I tend to try to pick routes that take me off the main roads to areas that are a little quieter. The morning walk for me is a way of getting myself ready for the day. It’s hard to do that when the accompanying sound track si a constant din of noisy traffic.

A tranquil spot that is just a stones throw away from the middle of town.
Very steep steps into the Dale.
It’s so nice and quiet here.
Sometimes going under this, I feel like I’m playing chicken with the traffic that is queueing at either end trying to agree who is allowed to move next.
I love this part of the walk. It feels like I’m walking a path a little less traveled. Although hundreds of people going to school every day probably use it as well. 🙂
I like listening to the sound of Drogheda waking up from this vantage point. It gives me a kind of disconnected calm. Knowing that all that activity is across the river.
I went down this on a scooter before. It didn’t end well. 🙂
Visit www.musicatthegate.ie to see this come to life.
When I was very young, I lived on this road.
This was a very hard road to cross.
This part of town was always a dead spot. But over the past 10 years, it has been integrated very well.

NVDA really coming up in my opinion.

Oct 19, 2020 | , , , ,

I’m so impressed by NVDA at the moment.

  • It works really nicely with VSCode
  • It’s working really well with the new Terminal UWP app
  • It’s very responsive
  • I like the sound effects and to replace speech.
  • It’s settings interface is really efficient
  • The Plugins repository is absolutely fantastic.

There are a few things stopping me using it right now.

  • I need remote desktop access out of the box
  • I’m nervous about pressing escape to get out of forms mode / get back into browse mode. Sorry. I’m mixing my terms. I also know that I can probably re-map this but I try to use it with the default keymap.
  • This is my own fault, but when in the terminal, it seems less efficient to copy and paste text when using the review cursor. Again, this is probably down to my inexperience with the application.

There is an NVDA remote add on available. But it’s not working with my current configuration while working from home as I’m using several machines with different VPN / routing configurations and as a result, although it get’s a connection, I never hear speech. I don’t have time to investigate further.

Oh, I also wish NVDA would not give me so much information when arrowing around message lists in Outlook. But that’s probably personal preference as well.