SQL Basics

Today, I am writing this blog because I did not have a chance to conduct the SQL training with the support team yesterday before I departed for a new adventure; I feel like I owe it to them to give them something. This is part one of the training session. This part is about SQL basics. Part two is about using patterns to gain efficiencies in your day-to-day work. Let’s start with part one: SQL Basics.

Continue reading SQL Basics

A Data Architect’s Guide to Database Design and Management

Introduction

Designing and managing databases is a critical task in data architecture. This blog post aims to provide insights into various aspects of database design, hosting, security, scalability, and the use of data for machine learning or AI.

Continue reading A Data Architect’s Guide to Database Design and Management

5 Essential Elements for a Successful Software Roadmap

Creating a successful software roadmap is akin to charting a course for a ship. It guides the team toward their goals, ensuring they stay on track and reach their destination. For engineers, a well-crafted roadmap is essential to meet targets efficiently. Let’s explore the five key elements that contribute to a successful software roadmap:

Continue reading 5 Essential Elements for a Successful Software Roadmap

Running Onshore and Offshore Development Teams – A Guide for Vice Presidents of Engineering

As a Vice President of Engineering, managing both onshore and offshore development teams can be both challenging and rewarding. Balancing the benefits of cost savings and access to global talent with the complexities of communication and cultural differences requires strategic leadership. In this blog, we’ll explore best practices for successfully running onshore and offshore teams, ensuring seamless collaboration and project success.

Continue reading Running Onshore and Offshore Development Teams – A Guide for Vice Presidents of Engineering

Andrew Pallant – A Strategic Leader in Engineering

Introduction

In the dynamic landscape of technology, effective leadership is crucial for driving innovation, fostering collaboration, and achieving organizational goals. As a Vice President of Engineering, I have had the privilege of witnessing Andrew Pallant’s remarkable journey—a journey that exemplifies technical excellence, strategic vision, and unwavering commitment to customer success. In this article, we’ll explore Andrew’s impact, his role in shaping engineering teams, and the principles that guide his leadership.

Continue reading Andrew Pallant – A Strategic Leader in Engineering

Do I Need Source Control

Yes!  For the first time in my 15-year career I had experienced what it is like to not have source control, and I had hated it.  I had lost a very difficult to write SQL statement in a project.  It seemed almost impossible to rewrite the SQL for the second time.   I believe it was two of us working in the same project that had caused this loss of code.   I take the blame because I am the manager and I knew that source control was not implemented.  I should have taken the time to take all of the projects and check them into the source control system. Continue reading Do I Need Source Control

Shortcut To Creating Properties in C-Sharp – Revisited

Based on my earlier an post, a I had a question about my technique and if there was a benefit, or could you use MethodBase.GetCurrentMethod().Name. Truthfully I did not know the answer until I tried it. I found this new way works, but I also find it is a little tougher to look at style-wise. You need to use stack frames if you nest the routine like I had in my original post.

public class ErrorLogRecord
    {
        public Hashtable _hsh = new Hashtable();

        public DateTime DateOfOccurance
        {
            get { return (DateTime?)_hsh[MethodBase.GetCurrentMethod().Name.Replace("set_", "").Replace("get_", "")] ?? DateTime.Now; }
            set { _hsh[MethodBase.GetCurrentMethod().Name.Replace("set_", "").Replace("get_", "")] = value; }
        }
        public String ErrorText
        {
            get { return (String)_hsh[MethodBase.GetCurrentMethod().Name.Replace("set_", "").Replace("get_", "")]; }
            set { _hsh[MethodBase.GetCurrentMethod().Name.Replace("set_", "").Replace("get_", "")] = value; }
        }
    }

Original Referenec Shortcut To Creating Properties in C-Sharp

What is Trending – Are you listening

Do you know what is trending today?   Do you know what is new?  Do you care?

As developers we live in a crazy world where technologies and ideas fly at the speed of light.  If you are not paying attention you will miss out on the new ideas.

Hash-tags, Twitter, blogs, LinkedIn and Facebook; these are some tools of the modern world and they can help define our chosen professions.  If you have not embraced these fore mentioned tools, you will miss out.  How are you keeping up?  Are you relying on your everyday work or are you digging into the realms of social media to see what is trending?  The printed press like magazines, journals and newspapers are not cutting any more because of the pace of change.  By the time you read it, it is history.

Social media is trending the new ideas, tools and techniques at a pace that is baffling.  If you are a developer and you have not embraced social media, you are probably missing out on a lot of great stuff.  Managers are now asking you in interviews; How you are learning new things and keeping in the know?  If you are not saying social media as a tool, you would be foolish.  It is great to ramble of magazine names and school courses, but most of what is learned there I consider as historical background knowledge; you need social media to enhance your knowledge.

Are you looking for the next great idea?

Here are some interesting trends to watch:

There are a million of trends happening every second of every day.  Pick one or two a day and watch.  If you find something interesting dig for it and dig deep.  LinkedIn also has groups that could help you define who you are, what you want to do and how to do it.    There is a lot happening and you will never know what will trigger your next big idea.   Once you have watched, participate and that is the ultimate way of learning what is new.