Distilled Side-Effects

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...

To comply with the latest industry security standards for TLS and its associated cipher suites, the folks at Atlassian, an Australian software company, will be deprecating support for older, less secure cipher suites. This change will take effect on August 5, 2024. &nbsp The Impact effects mail; After August 5, 2024, some TLS cipher suites may no longer work. This could affect incoming mail connections using 'Basic' authentication. &nbsp User might see the following error message: "Remote host terminated the handshake," User of OAuth Access authentication should not be impacted. &nbsp Avoid the problem: Check Supported TLS Cipher Suites: To avoid disruptions in your incoming emails, review your email server and incoming email configurations to ensure they use one of the supported TLS cipher suites. &nbsp Most Hosted Email Services will provide support on cipher suites. Self-Hosted Email Servers: If you operate your own email serve...

Microsoft Visio and Power BI can integrate, enabling users to visualize data in Power BI dashboards using Visio diagrams. This combination allows you to present data through charts, graphs, and visually detailed diagrams mapping processes, networks, and organizational structures. 1. Why Integrate Visio and Power BI? Integrating Visio with Power BI provides visual context to your data: Enrich dashboards with process flows, system architecture diagrams, or visual layouts. Provide interactive data-driven diagrams showing real-time performance or relationships. Create holistic visual reports combining data analysis with spatial or logical diagrams. 2. How Does It Work? a. Create Your Visio Diagram Create your Visio diagram, ensuring shapes are data-linked to sources like Excel, SharePoint, or SQL Server. b. Embed Visio into Power BI In Power BI, go to the Visualizations pane and click the Visio Visual icon...

Introduction During my contract at the MTA, I had the opportunity to transform how the department of subways managed its data. Instead of relying on the standard Extract, Transform, Load (ETL) methods, I introduced the concept of Digital Twins. This innovative approach enabled us to capture and digitize the tacit knowledge of team members, allowing us to convert hidden data into actionable insights for improved departmental management. What is a Digital Twin? A Digital Twin is a virtual representation of a physical entity, system, or process that mirrors its real-time conditions, behaviors, and attributes. It acts as a bridge between the physical and digital worlds, allowing for monitoring, simulation, and optimization of systems. The Process of Implementing Digital Twins at MTA Understanding the Current Landscape: Engaged with team members to understand existing processes, challenges, and hidden knowledge that was not capt...

Although I live in NYC, I'm a member of the Rocky Mountain Chapter of the Data Management Association (DAMA). DAMA is a non-profit, vendor-independent professional organization dedicated to advancing data asset management concepts. Like most associations, DAMA offers its members various events, such as monthly meetings, trainings, and social gatherings. If you're interested in data management, I highly recommend joining DAMA. If the Rocky Mountain Chapter isn't in your region, find one that is. For graduating students or retirees, it serves as a gateway to education, certification, and career advancement in the data management profession. And, of course, you might even make some new friends. Your first year of membership is free, and the study groups are a significant benefit. These groups typically meet once a month, connecting you with like-minded individuals studying for the Data Management Certification. Additionally, DAMA offers discounted trainin...

Finger Power – Tab Stash Effective Organizing Props to Josh Berry for creating Tab Stash , a powerful Firefox extension designed to help users organize their tabs efficiently. By stashing away tabs when they are not immediately needed, Tab Stash helps keep your browser window tidy and reduces memory usage. Key Features: Quick Stashing: Stash open tabs with a single click and easily restore them later. Organized Stashes: Tabs are automatically organized into groups, but you can also customize them to suit your workflow. Efficient Search: Find specific tabs quickly using the search function. Bookmark Integration: Stashed tabs are always available, even if you disable or uninstall the extension. Privacy and Efficiency: Tab Stash is lightweight and designed with user privacy in mind. With Tab Stash, you can declutter your browser and improve your productivity.

Microsoft’s Physiology -- Understanding .NET and DB Connections "Microsoft’s Physiology" isn’t a commonly used phrase in tech, but I assume you're asking for an understanding of how .NET interacts with databases (DB connections) within Microsoft’s ecosystem. I’ll break it down into key components: 1. .NET Framework Overview .NET is a software framework developed by Microsoft that provides a controlled environment for the development and execution of applications. It supports multiple languages (like C#, VB.NET, and F#) and is widely used for developing Windows applications, web applications, and cloud services. Here’s how it fits in with database connectivity: 2. ADO.NET for Database Connectivity ADO.NET is the part of the .NET framework responsible for data access. It provides a bridge between the front-end application and databases, enabling interaction with relational databases like ...

NodeJS Ambiguity — .mjs, CommonJS, and ES Modules The .mjs extension is used for JavaScript modules in the ECMAScript (ES) module format. Below are key points to help you navigate the often-confusing landscape of CommonJS vs ES Modules in Node.js. 1. Module Syntax Files with the .mjs extension allow you to use modern import and export statements, enabling modular programming in JavaScript. This provides a standardized way to manage dependencies and organize code. 2. Differentiation from .js While .js files can be used for both CommonJS ( require/module.exports ) and ES modules, .mjs explicitly indicates that the file is an ES module. This explicitness helps avoid ambiguity in environments that support both module types. 3. Browser and Node.js Support Modern browsers and Node.js support the .mjs extension. In Node.js you can alternatively set "type": "module" in pac...

Litepicker is a lightweight and easy-to-implement date picker. If you're working in a Node.js environment, simply install it via the command line with: &nbsp For a bash install use the command line: npm install litepicker &nbsp Alternatively, you can use the CDN for quick integration. &nbsp &nbsp If you're using TypeScript and encounter an error, try adding `esModuleInterop` to your `tsconfig.json` file. For more details, check the documentation. &nbsp In addition to the usual date-picking features, Litepicker offers several useful plugins, such as: &nbsp &nbsp Keyboard accessibility &nbsp &nbsp Mobile-friendly design &nbsp &nbsp Predefined date range &nbsp &nbsp Multiple date selection &nbsp Litepicker is open-source, well-documented, and works seamlessly with your custom CSS.

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?” &nbsp 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. &nbsp 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 &nbsp Additionally, just like Microsoft, Oracle provides free development databases and tools for both Windows and Linux. So, how does the magic happen? Setting up the environment using the .NET Core Command Line involves four basic steps (Note: Depending on your configuration, it's best to run the comman...

Tuning the MS SQL Server – The Easy Way, Securely SQL Server performance tuning is essential for maintaining a fast, efficient, and secure database environment. Tuning is about optimizing SQL Server to handle workloads efficiently, reducing bottlenecks, and ensuring that security is not compromised during optimization. Here’s a practical guide for tuning SQL Server the easy way, with a focus on keeping it secure. 1. Index Optimization Indexes improve query execution speed but poorly designed or fragmented indexes can degrade performance. Rebuild or Reorganize Indexes: Use SQL Server’s Rebuild and Reorganize index options to fix fragmentation. Rebuild for heavily fragmented indexes (>30%). Reorganize for less fragmented indexes (5-30%). Schedule during low-traffic periods. Use DMVs to monitor index usage: SELECT db_name(database_id) AS DatabaseName, object_name(i...

The Gram Cracker Effect – Open Source Security Assessment There are approximately 150 key security terms defined by the SANS Institute. How many of them focus on the use of open-source code? Surprisingly, none are directly related to code risk assessment. How Can You Consistently Assess the Risks of Open Source Code? To start, tap into your knowledge of security assessment. Yes, this will require research. From your research, you'll be able to identify gaps in your understanding and areas where you need to focus. Step 1: Recognize the Risks of Using Open Source Code One of the highest risks in coding comes from using someone else’s code. Why is this a big risk? Some code is deliberately written to be malicious. Even non-malicious code can contain vulnerabilities that create security holes. Open-source code is often not updated regularly with the latest security patches. Step 2: Develop a Risk...

Prompt engineering is an essential aspect of working with AI models, particularly those based on natural language processing (NLP) like GPT-4. &nbsp The quality of the prompts directly impacts the quality of the AI's responses. Well-crafted prompts can elicit more accurate, relevant, and creative answers. In addition, precise prompts help minimize ambiguity and misunderstandings, leading to more focused and useful outputs. Good prompt engineering can reduce the need for multiple iterations, saving time and computational resources. &nbsp The challenges in Prompt Engineering are wide and long including the following: Ambiguity: Even well-crafted prompts can sometimes be misinterpreted by the AI, leading to irrelevant or incorrect output Bias: Prompts can inadvertently introduce biases, affecting the fairness and objectivity of the AI's responses. Complexity: Crafting effective prompts for complex tasks or niche domains can be challenging and may require domain-...