SphereGen

spheregen logo on transparent background

Implementing PWA behavior to ASP.NET Core 7 apps 

finger pressing pwa key on keyboard

Simplify Implementation without sacrificing data integrity Progressive Web Apps (PWAs) are Web Apps that combine the best features of Web and Native Apps. In short, it can be described as “The best of the web, plus the best of native apps”. The biggest advantage is the cost-savings in terms of app development and maintenance, because, … Read more

Update Existing Windows File Share Subscriptions to Use Common File Share Account

laptop on desk with sql server screen

Microsoft has introduced a new feature called Use file share account in Microsoft SQL Server Reporting services starting with SQL Server 2016. This new feature gives the flexibility to use a common file share account for windows file share subscriptions. To enable this new feature in the SSRS file share subscription, first, you need to … Read more

Part 2 – Issues and Challenges After Migration of Microsoft SQL

spheregen logo with tagline

Reviewed for accuracy on January 23, 2023 In Part-1, SSRS migration steps have been discussed. Many congratulations for SSRS migration but migration journey is not yet over. SSRS migration opens door for new issue and challenges due to feature update but also it welcomes new feature that comes with newer version of SSRS. Below mentioned … Read more

HIVE_BAD_DATA: Error Parsing Field Value for Field ERROR in AWS Athena

spheregen logo with tagline

Reviewed for accuracy on January 23, 2023 HIVE_BAD_DATA is generally related to bad data in source file or data type mismatch. I have experienced this error while working with JSON data read in AWS Athena. For example, I have below sample JSON data that is stored in s3 bucket {“id”:”jggdfdysf866″,”socialdata”:{“facebook”:”Facebook data details”,”twitter”:””}} {“id”:”676fdggdcdf4″,”socialdata”:”This is bad … Read more

PART 1 – Migration of Microsoft SQL Server Reporting Services to New Server

laptop on desk with sql server screen

Reviewed for accuracy on January 23, 2023 One of our clients was using SSRS2008R2 (Native Mode) and they decided to upgrade to SSRS2017. There are two methods available that can fulfil this upgrade. One by using some scripting and another one by physically moving ReportServer database to the new server. Physically moving ReportServer database to … Read more

Power Automate Desktop – Updates for Citizen Developers

power automate

Power Automate Desktop Microsoft’s Power Automate Wave 2 expansion has allowed the once niche and cost-effective RPA alternative to transform itself into a strong competitor within the process automation marketplace. Though Microsoft has implemented a number of features, functionalities, and improvements to their product, the price point is extremely competitive when compared to big players … Read more

Power Automate Desktop – Updates for Professional Developers

man using laptop to code

Power Automate Desktop Microsoft’s Power Automate Wave 2 expansion has allowed the once niche and cost-effective RPA alternative to transform itself into a strong competitor within the process automation marketplace. Though Microsoft has implemented a number of features, functionalities, and improvements to their product, the price point is extremely competitive when compared to big players … Read more

Microsoft Dynamics Guides: Best Practices

young man doing maintenance on a piece of equipment with microsoft guides on hololens 2

Training with Microsoft’s Dynamics Guides Microsoft’s Dynamics Guides is a useful tool to provide visual and audio aides for step-by-step instructions and hands-on training. Using the Hololens 2, Guides displays holograms, images, text, and video to achieve effective, interactive training manuals. Creating a Guide is easy and intuitive. Below, we talk about some of the … Read more