How to Build Power Apps for Disconnected and Offline Use
Have you ever needed to use an app without internet or Wi-Fi but still wanted to save your data to a database? In this guide, I’ll explain how to design a Power Apps application that works seamlessly offline or in disconnected environments. This app stores data locally on your device and automatically syncs it to… Read More
Effective Tips for Accurate Geographic Mapping in Power BI
Mapping geographical data in Power BI can sometimes present challenges, especially when locations are incorrectly plotted on the map. In this article, I’ll share some practical strategies to help you minimize or completely avoid inaccurate map visualizations in your reports. Enhancing Geographic Accuracy in Power BI Visualizations When working with geographic data in Power BI,… Read More
Best Practices for Creating Strong Azure AD Passwords and Policies
In today’s digital landscape, securing your organization starts with strong passwords and effective password policies—especially for critical systems like Azure Active Directory (Azure AD). Given Azure AD’s central role in providing access to Azure portals, Office 365, and other cloud and on-premises applications, it’s essential to ensure that your authentication credentials are robust and well-protected.… Read More
Unlocking Informatica Solutions on Microsoft Azure
Microsoft Azure continues to expand its cloud ecosystem, offering an ever-growing range of products through the Azure Marketplace. Among the top vendors featured is Informatica, a company known for its powerful data management tools. Despite what some may consider a competitive relationship, Microsoft and Informatica are partnering to bring innovative solutions to Azure users. Informatica’s… Read More
Comprehensive Power BI Desktop and Dashboard Training
Are you looking to master Power BI? Whether you’re a beginner or already familiar with Power BI, this training course is tailored just for you! This Power BI training course is meticulously designed for a broad spectrum of learners, ranging from business professionals and data analysts to IT practitioners and decision-makers eager to harness the… Read More
Understanding Static Data Masking: A Powerful Data Protection Feature
Today, I want to introduce you to an exciting and relatively new feature called Static Data Masking. This capability is available not only for Azure SQL Database but also for on-premises SQL Server environments. After testing it myself, I’m eager to share insights on how this feature can help you protect sensitive data during development… Read More
How to Create a QR Code for Your Power BI Report
In this step-by-step tutorial, Greg Trzeciak demonstrates how to easily generate a QR code for a Power BI report using the Power BI service. This powerful feature enables users to scan the QR code with their mobile devices and instantly access the report, streamlining data sharing and boosting accessibility for teams on the go. QR… Read More
How to Configure SSIS Encryption Level Protection in Visual Studio 2012
After investing significant time building your SSIS package, you’re excited to launch a powerful tool for organizing and transforming data across your company. But instead of a smooth success, you’re met with frustrating error messages upon execution. When working with SQL Server Integration Services (SSIS) packages in Visual Studio Data Tools (SSDT), encountering build errors… Read More
Boost Your Productivity with SSIS (Microsoft SQL Server Integration Services)
In this blog post, Jason Brooks shares his experience with Microsoft SQL Server Integration Services (SSIS) and how Task Factory, a suite of components, has dramatically improved his development efficiency. His insights provide a valuable testimonial to the benefits of using Task Factory to enhance SSIS projects. Below is a reworked version of his original… Read More
Understanding Azure SQL Database Elastic Query: Key Insights
This week, our Azure Every Day posts take a slight detour from the usual format as many of our regular bloggers are engaged with the Azure Data Week virtual conference. If you haven’t registered yet, it’s a fantastic opportunity to dive into Azure’s latest features through expert sessions. Starting Monday, Oct. 15th, we’ll return to… Read More