Friday, 16 October 2020

migrate sql database to azure

 

RPA & Mobile Technology

 


RPA (Robotic Process Automation) is a technology integrated with Artificial Intelligence and Digital Transformation to work on the computer system as a human interacts with it. In RPA, human UI Interaction is done using Bots. A Bot is a program which work like a human with the system in order to perform repetitive task. Automating the Repetitive task saves time and money although it provides the accuracy which human cannot maintain by himself working on the same process. These Bots are easy to develop, train, organize and maintain. RPA provides easy integrations with different kind of Platforms and work in an efficient manner. RPA is suitable for every kind of business-like Aviation, Finance & Banking, Insurance, BPO, Telecom, Retail and Manufacturing. RPA focuses more on generating revenue that’s why most of the organizations are adhering RPA and focusing on the process where they can apply it.

 

It works well with the Traditional IT Infrastructure to automate them using cutting-edge RPA Technology. It reduces the manual Back Office effort and Employees can see the progress reports generated by the Bots and continue with their stuff. RPA will continue generating profit and will be the future of work which we are doing on systems. People will be doing value work rather than just doing their repetitive work.

 

 

migrate sql database to azure

 

INTRODUCTION

Let’s consider a real-world scenario where most of the companies are facing challenges with legacy applications. Consider you are maintaining or administrating legacy applications which are hosted on your company’s infrastructure. However, the hardware is aging and requires upgrading in order to support new applications which are being deployed on it.

 


As the market evolves, you are in urgent need of upgrading your hardware in order to support your business needs. At the same time, your data is growing at a fast pace and requires latest platform and services to keep your business running.

 

You could upgrade all the hardware, but that’s not appealing for several reasons:

The servers are physically scattered all around the world in different locations. You would like to centralize the upgrade in order to minimize the staff efforts.

Adding new physical servers or services in order to support your business would be a time consuming and cumbersome activity as it involves deployment of all the services. This could be more challenging if your software has different versions of Windows and Linux and requires your deployments to be tested out to ensure everything is working fine.INTRODUCTION

Let’s consider a real-world scenario where most of the companies are facing challenges with legacy applications. Consider you are maintaining or administrating legacy applications which are hosted on your company’s infrastructure. However, the hardware is aging and requires upgrading in order to support new applications which are being deployed on it.

 

As the market evolves, you are in urgent need of upgrading your hardware in order to support your business needs. At the same time, your data is growing at a fast pace and requires latest platform and services to keep your business running.

 

You could upgrade all the hardware, but that’s not appealing for several reasons:

The servers are physically scattered all around the world in different locations. You would like to centralize the upgrade in order to minimize the staff efforts.

Adding new physical servers or services in order to support your business would be a time consuming and cumbersome activity as it involves deployment of all the services. This could be more challenging if your software has different versions of Windows and Linux and requires your deployments to be tested out to ensure everything is working fine.

https://innovativetechexperts.com/category/cloud-computing/

UIPath Process Automation

 

UIPath Process Automation

 



There are different UiPath Products and tools available to meet User requirements for Process Automation. UiPath has created it’s Licensing and Pricing as per the tools and the Market Feedback. This well structured UiPath Licensing model helps enterprises to scale Robotic Process Automation in a good manner.

UiPath has three Principle for its licensing Structure:

Simple: – As per the Customer required tools and Products.

Scale: – Focused on the Scale of Enterprises and their growth.

Savings: – Save by dividing its licenses on bases of Products and Role basis.

UiPath Platform Elements

Users/Roles: – This element compromises User-specific models where Business User and Process User.

Robots: – These elements include Unattended Robots, AI robots, and Document Processing.

Management and Monitoring: – This includes Orchestrator Service, Automation Hub, and Insights.

UiPath Users



Named User: – Every User contains a dedicated license. It is not ideal when Employees are working in shifts and if the business requires to use the same license.Multi-User: – This type of license can add 3 authorized Users to the pool. This License cost is double than Named User License.

FOR MORE INFO VISIT US- https://innovativetechexperts.com/

 

SQL Server Management studio

 

Innovative Tech Experts





Innovative Tech Experts are here to help you in your IT transformation journey. We specialize in Cloud Computing (Azure), Process Automation (RPA, UIPath and others.) and entire Microsoft Stack. As a side project, this website is also a technical blog where you can find some of the blog posts related to SQL Server, Azure Portal, Virtual Reality, RPA, Mobile Technology, Cloud computing, Mobile App Development and much more. No matter who you are and what your age is, if you are interested in technology then you always find our blogs helpful and interesting as well.

 

SQL Server Management studio

 



Lets talk about a very common but complex/tricky problem when your production SQL database starts having performance issues. Some of these are related to huge database size both mdf (data) and ldf (log).

I have recently been part of  problem where one of our dataabase had mdf file which was about 400Gb and ldf (Log file) was about 200GB. Now it was getting difficult to manage the backups, ability to quickly restore in case of need and all other associated problems.

 

The business was keen to find a workable solution as soon as possible. And after a few attempts I was able to get the database size reduced to ~200GB. Obviously there was no magic and I was able to free up a large ammount of data by deleting/archiving records from an Audit table which gets hit by record inserts for every user action in the application.

But interstingly SQL does not free up the space automatically after you delete data/records from the database. It still occupies the same disk space on the file system. But I just deleted large amount of data from my database and I know there is free space in the database. So I thought I’ll document the steps that I went through in a blog post for a ready ref. to anyone having a similar problem statement.

There are couple of ways to achive your desired outcome. But as always there are certain limitations and drawbacks of each option that you chosse.

FOR MORE INFO VISIT

https://innovativetechexperts.com/