Follow

MS SQL Server Cell/Column Level Encryption & Decryption

Posted on February 15, 2017 by in SQL

Introduction

Database is a wonderful tool to store information and to look at the data in different ways to make decisions, present an opinion etc. However, the same data can pose a big problem should it fall in the hands of unscrupulous people and the impact can be more devastating if it has sensitive information such as Credit Card/Bank Account numbers, personal Telephone/Email details. For some organizations, it is mandatory to meet stringent data security regulations such as PCI-DSS, HIPAA/HITECH, or GLBA/FFIEC. Hence all such sensitive information must be encrypted in order to protect the customers and avoid data loss in the event of data breach.

This article focuses on how to do data encryption in Microsoft SQL Server by looking at the available options.

Common mistakes while working with CakePHP index page views

Posted on February 3, 2017 by in PHP Solutions

At some point of time as developers, we all go through a situation where we have a short deadline and a hand-full of work. In such situations if we are working with CakePHP index views, this blog may help you avoid some common mistakes. For this tutorial, we are targetting CakePHP 2 and CakePHP 3.

Prerequisite

  • Knowledge on CakePHP views

Dynamics 365 - Add Icons to Entity Views

Posted on January 21, 2017 by in CRM Solutions

1.   Introduction

Microsoft Dynamics 365 has a new feature added for customizing entity views, where-in we can add custom icons with tool-tip text to display in a column depending on the column value; we can also specify localized tool-tip text.

This can be done by using JavaScript web resource and icons as image web resource. Below are the steps to add icons and tool-tips to entity view.

Dynamics 365 - Backup/Restore online CRM instance

Posted on January 6, 2017 by in CRM Solutions

Maintaining backup of CRM is always suggestible to save organization(s) from unforeseen errors. Microsoft introduced on demand backups for online CRM instances. Backups can be,

Prevent iOS from zooming in on input fields

Posted on January 5, 2017 by in General, iOS, Mobile Technologies

Developing a responsive website that works well across various browsers and devices is tough. The difficulty is compounded by the fact that browser vendors keep adding distinct behaviors to improve user experience. We recently faced an issue with the auto zoom-in feature in Safari on iOS. 

Dynamics 365 - App & Site Map Designer

Posted on December 29, 2016 by in CRM Solutions

Continuing from our previous post of Dynamics 365 features, today we will go through the App Designer and Site map editor.

App Designer:

Apps are solution-aware components which are designed to simplify the work experience of the users. Based on the CRM license apps like Sales, Marketing, Customer Service, Project Service apps are given OOB.

App designer gives a CRM customizer ability to design apps tailored to their users/needs easily. Site map editor is integrated with app designer and simplifies the process of creating navigation and site maps with WYSIWYG designer.

Push Notification using APNS

Posted on December 12, 2016 by in iOS, Mobile Technologies

1.  Introduction

Apple Push Notification service (APNs), which was launched with iOS 3.0 on June 17, 2009, facilitates sending small sized information to mobile devices remotely. Such information is called a notification and can include:

  • Badge
  • Sound
  • Custom title text alerts
  • Payload

However, delivery of the messages to the intended devices is not guaranteed even though the APN server has accepted the messages. One must pay attention to the below constraints while sending a message:

Dynamics 365 - Editable Grids in CRM

Posted on November 24, 2016 by in CRM Solutions

The much-awaited feature of full-fledged inline editing in grids is now an OOB feature in Dynamics 365. As a company, which has been working in MSCRM for a decade and knowing requirements of various clients of ours-we were delighted to see this in action.

Few tips from our Ionic & Angular JS experience

Posted on October 28, 2016 by in Mobile Technologies

1. Screen Resize

IONIC allows to adjust the screen height whenever the current view is updated, either by loading a new screen or by inducing dynamic HTML. If the screen height adjustment is not handled properly, user will perceive a long delay before they can scroll to the end of the view. It is observed that; such height adjustment can take up to 10 to 15 seconds which is bad UX. To handle this gracefully, snippet similar to the below can be used, where ‘.element’ has to be replaced with the actual Id/CSS class name of the UI element.

Auto-clearing browser cache after deployments

Posted on July 13, 2016 by in General

Majority of web developers have had to, one time or the other, ask their users or the test engineer to clear their cache before validating a change. Browsers’ cache static resources like JavaScript and CSS, and load them from their cache to improve page load speed. Hence your latest modifications won’t apply until the end user clears their browser’s cache. We’ve been using a technique that allows us to refresh the browser cache automatically without asking our users to do so.