Distilled Side-Effects

Sugar-Coated Digital Fruits — The Bittersweet of Using Blockly from Google Blockly is a web library that allows you to add a block-based code editor to your app. The editor uses puzzle-piece-like blocks to represent coding concepts such as variables, logical expressions, loops, and more. It enables users to program without worrying about syntax or the complexities of a command-line interface. Breaking it down, Blockly can be thought of in two ways: A Fun Puzzle-Piece UI: You define the puzzle connections and input fields, and Blockly handles the rendering, dragging, and connecting. A Fancy String Builder: You define the code that each block generates, and Blockly concatenates these blocks into complete strings of code. The output can be used in a variety of ways—from solving mazes to animating characters or analyzing data. Blockly lets you focus on applying these blocks to your domain without dealing with the complexi...

Mastering Requirements – When Stakeholders Don't Know What They Want Understanding and managing requirements, especially when stakeholders are uncertain, is a critical skill for project managers and product owners. Here are strategies to effectively handle situations where stakeholders may not have a clear vision of their needs. Active Listening and Open-Ended Questions Encourage Exploration: Use open-ended questions to delve deeper into stakeholders' goals, pain points, and desired outcomes. Active Listening: Pay close attention to responses, seeking underlying needs and assumptions. User Research and Interviews Direct Feedback: Conduct user interviews, surveys, or focus groups to gather firsthand insights into user needs and preferences. Observe Behavior: Watch users interact with existing products or prototypes to identify pain points and opportunities...

The increasing pressure to meet sprint deadlines is a common source of work-related stress. Agile methodologies, while designed to improve efficiency and flexibility, can sometimes create a high-pressure environment if not managed effectively &nbsp Contributing to this stress are unrealistic expectations related to the Software Development Life Cycle (SDLC). Simple tasks often prove more complex than anticipated, leading to increased testing and problem-solving time. Additionally, scope creep, which Agile aims to manage, can still cause issues. Frequent changes can disrupt the workflow and potentially set the project back, especially when unexpected changes or side effects impact the project's and application's stability. &nbsp Furthermore, the fear of failure, often overlooked, can create anxiety and stress among team members and project sponsors. &nbsp To mitigate the negative impacts of sprint-related stress,...

Litepicker Date Picker Litepicker Date Picker Litepicker is a lightweight and easy-to-implement date picker. If you're working in a Node.js environment, you can install it via the command line: Install via npm npm install litepicker Alternatively, you can use the CDN for quick integration. If you're using TypeScript and encounter an error, try adding esModuleInterop to your tsconfig.json file. For more details, check the official documentation. Key Features and Plugins Keyboard accessibility Mobile-friendly design Predefined date range Multiple date selection Litepicker is open-source, well-documented, and works seamlessly with your custom CSS.

One method to track and enhance digital art is to use QR codes. These ubiquitous black and white squares can bridge the physical and digital worlds, offering unique opportunities for interaction and information sharing. Integrating QR Codes Generate QR Codes Use online QR code generators like QR Code Generator or Google Chart API. Customize the appearance of your QR codes to match your digital art style. Store QR Code Data Create a database table to store information related to each QR code, including: QR code ID Image file path Associated data (e.g., URL, text, or other information) Embed QR Codes into Digital Art Use image editing software to seamlessly integrate the generated QR codes into your digital art pieces. Place QR codes strategically to ensure they are easily scannable without detra...

Data Storytelling Tips Data Storytelling Challenges Raise your hand if you find telling stories with data challenging. For data analysts (or those aspiring to be), much of your day involves taking numbers and giving them meaning. If I say “150” and just leave that number hanging, what does it mean? Is it the price of a watch, a percentage increase in stock, or the distance a train has traveled? As an analyst, your job is to define numbers and give them context. For example, “150” could be the number of cars your company didn’t rent out over the weekend. That might represent 50% of your rentable vehicles, which in turn means revenue could be down by 30% compared to last weekend. While those insights can be verbalized or written down, the real challenge comes when you have to present them visually. What type of graph should you use? Which colors, data points, and legends will best convey the story behind the numbers? Why even use graphs, you might ask? One reas...

Azure, Microsoft's cloud platform, offers a comprehensive suite of tools and services designed to manage data throughout its lifecycle. As a data engineer, your role involves integrating, transforming, and consolidating data from diverse structured and unstructured sources. Azure is engineered to ensure that your data pipelines and data stores are high-performing, efficient, organized, and reliable, while meeting specific business requirements and constraints. Why Use Azure's Tools and Resources? Azure's tools simplify the data engineer's life. For instance, you can use Azure alongside Visual Studio Code to manage data pipelines, and Azure can handle much of the data analysis, provided the data is appropriately cleaned and structured. One of Azure's standout features is its ability to work seamlessly with structured, semi-structured, and unstructured data: Structured Data: Typically comes from table-based source systems. Se...

As a programmer, it’s crucial to understand the difference between passing arguments by value or by reference—this is often a common interview question. Not only can this knowledge save hours when writing clean, error-free code, but it's also fundamental for debugging and optimizing. While numerous resources (over a thousand!) explain these concepts, it’s worth noting that the behavior can differ between programming languages. The Basics When thinking about how memory works, remember this key idea: when passing arguments to a function, the distinction between by value and by reference determines whether a change made inside the function affects the original data or just a copy of the original data. When a copy of the data is passed from the first function to another function, changes inside the second function don’t affect the original data. If another function receives a reference (a pointer to the original data), then changes m...

SQL (Structured Query Language) is not just for querying data; it also has robust mathematical capabilities that allow you to perform various calculations directly within your queries. Here’s an overview of how to perform mathematical operations in SQL, along with examples. 1. Basic Arithmetic Operations SQL supports the four basic arithmetic operations: addition, subtraction, multiplication, and division. You can use these operators directly in your SQL queries. Addition (+): SELECT price, quantity, (price * quantity) AS total_cost FROM products; Subtraction (-): SELECT employee_id, salary, (salary - deductions) AS net_salary FROM employees; Multiplication (*): SELECT item, price, quantity, (price * quantity) AS total_price FROM inventory; Division (/): SELECT sales, expenses, (sales / expenses) AS profit_margin FROM financials; 2. Aggregate Functions SQL provides built-in aggregate function...

.NET Development with Oracle Databases You might wonder, “Why would I develop .NET applications with Oracle databases, knowing that Microsoft SQL Server and related services are tightly integrated with .NET, and easily accessible within Microsoft’s development tools?” As a Technology Architect designing government projects, I’ve had to work in environments where clients use various database systems, including Microsoft SQL Server, Oracle databases, and others. But hold on to your $1,000 iPhone—Oracle offers a suite of tools for .NET development: .NET Core for Visual Studio Code .NET Core for Visual Studio .NET Framework for Visual Studio .NET Core Command Line Additionally, just like Microsoft, Oracle provides free development databases and tools for both Windows and Linux. Setting Up the Environment Setting up the environment using the .NET Core Command Line involves four basic steps (Note: Depending on your configuration, it's best to run ...

Business Analyst & Software Development Business Analyst & Software Development People are often impressed when they find out that I’m a business analyst who can also develop software. My preferred tech stack includes Microsoft C#, .NET, and Blazor. For those unfamiliar: C# is Microsoft’s answer to Java (though it came after Java). .NET is Microsoft’s backend framework, offering a wide range of services designed to help applications run on any system (though that vision is still evolving). Blazor (initially developed by open-source contributors) is Microsoft’s latest attempt to create web applications that run everywhere—a dream that is still ongoing. When I talk about programming, I like to tell people, "I can teach you how to do that." Writing code is often the easier part of software development. It’s the testing and debugging that are much harder. Some tests take two seconds, while others can take two weeks—and, honestly, testin...

The Rule of Threes – Managing Client Expectations Managing client expectations is crucial for successful project delivery and maintaining strong client relationships. One effective framework for this is the Rule of Threes, which simplifies complex concepts into three key areas: communication, deliverables, and feedback. Here’s how to implement this rule effectively. 1. Communication Effective communication is the foundation for managing client expectations. Regular Updates: Provide consistent updates to clients about project progress. Set a schedule for regular check-ins (e.g., weekly or bi-weekly meetings) to discuss status, challenges, and next steps. Clear Language: Avoid jargon and technical language. Use simple terms to explain project details, timelines, and any potential issues, ensuring clients understand what to expect. Set Boundaries: Establish clear lines of communication. Define how clients can reach y...

Looking at the Obvious – Ensuring SharePoint is Accessible to Everyone Accessibility in SharePoint is crucial to ensure that all users, including those with disabilities, can navigate, interact, and consume content effectively. Microsoft provides various tools and best practices to ensure SharePoint is accessible, compliant with accessibility standards such as WCAG (Web Content Accessibility Guidelines), and usable by everyone. Let’s look at some of the tools available for making SharePoint accessible and how to use them. 1. Accessibility Checker The Accessibility Checker in Office applications (Word, Excel, PowerPoint) ensures that documents created and uploaded to SharePoint are accessible to all users. How to Use: Open the document you plan to upload to SharePoint. Go to the Review tab. Click on Check Accessibility . Review the recommendations and warnings (e.g., missing alt text, poor contr...

There are countless applications for pulling and pushing data through pipelines, many of which offer the ability to display data in various types of graphs. Microsoft’s Power BI stands out, continuously evolving as a robust tool for data visualization and reporting. Think of it as MS Excel with pivot tables for the web—though there's also a downloadable desktop version if you prefer to avoid relying solely on Office 365. &nbsp The beauty of Power BI, like many Microsoft products, lies in its seamless integration with other MS tools. Users can easily move data from MS Excel to Power BI and back again, and Power BI can also connect to the BI server or integrate with Azure, enhancing its functionality. &nbsp Now, let's get creative. Picture Power BI as an art school drop-out who later majored in mathematics with a minor in statistics. Its true strength is its ability to transform raw data into visually stunning representations, pe...