How to run aspnet_regsql

Personally,  I prefer to use the wizard in running the executable file.

Just locate the file from C:\Windows\Microsoft.NET\Framework\[framework version]\aspnet_regsql.exe) and run the file as Administrator. Provide information as required by the wizard.

Finding special character in Excel cell

To find special character in excel cell and place a remark if found, you may use the formula below:

=IF(ISNUMBER(FIND({“!”,”@”,”’”,””””,”]”,”[“,”}”,”{“,”|”,”&”,”$”,”#”,”^”,”~”,”%”,”®”,”,”,”’”},F12)),”Found”,”None”)

Do we need to be certain for us to trust?

certainty

Here’s a short story depicting trust.

Little girl and her father were crossing a bridge. Father was kind of scared so he asked his little daughter,

‘Sweetheart, please hold my hand so that you don’t fall into the river.’

The little girl said, ‘No, Dad. You hold my hand.’

‘What’s the difference?’ Asked the puzzled father.

‘There’s a big difference,’ replied the little girl.

‘If I hold your hand and something happens to me, chances are that I may let your hand go. But if you hold my hand, I know for sure that no matter what happens, you will never let my hand go.’

In any relationship, the essence of trust is not in its bind, but in its bond. And in that bond, each one is certain that both are there for each other. Those who are strong have the bigger role to keep the bond for a relationship to prosper.

Why Customer Complains Needs to be Listened

02-orange

Customer feedback is so important because it provides marketers and business owners with insight that they can use to improve their business, products and/or overall customer experience.

The following are the top six reasons why customer feedback is important to your business.

1. It can help improve a product or service

Listening to your customers is the only way to guarantee you create a product or service that they actually want to buy. Customer feedback is commonly used throughout the product development process to ensure that the end product is something that solves a customer’s problem or fulfils a need.

The most innovative companies in the world are the best at creating products that meet their customers’ needs and exceed their expectations. Think of Apple, Virgin and Dell.

In today’s competitive business world, these companies who can intertwine product development and customer feedback will be the ones that reap strong competitive advantages, have sticky customer loyalty and earn raving customer advocates.

2. It offers the best way to measure customer satisfaction

Measuring customer satisfaction helps you determine whether your product or service meets or surpasses customer expectations. Customer feedback surveys help you measure customer satisfaction.

These can be done in person, via email, via the phone or even inside a website or mobile app. Using rating-based questions when you are measuring customer satisfaction will help you track and monitor how happy (or unhappy) your customers are over time.

3. It provides actionable insight to create a better customer experience

Improving the customer experience should be the primary reason you gather customer feedback. The process of winning new business and retaining existing customers is getting harder and harder. Offering an amazing experience that keeps your customers coming back and referring their friends to you is the best way you can stand out from your competition.

To create an amazing experience, you need to ask your customers what they want and use the insight to create a consistent, personalized experience. If you can create an experience that is better than your competitors, your customers will remain loyal and ignore tempting competitive offers.
4. It can help improve customer retention

Customer feedback offers a direct line of communication with your customer so you can determine if they are not happy with the product or service you are delivering before you lose their business.

A happy customer is a retained customer. By requesting customer feedback surveys regularly, you can ensure that you keep the finger on the pulse. If a customer becomes frustrated or perceives a competitive offer to be better, they will start exploring their options and may cancel their contract or stop doing business with you. By listening to your unhappy customers, you can use the feedback to ensure all of customers have a better experience and continue wanting to do business with you.
5. It delivers tangible data that can be used to make better business decisions

The best business decisions are based off data, not hunches. Too many times business owners and marketers make big calls based off inaccurate data. Customer feedback is the holy grail of tangible data. You can gather real insight into how your customers really feel about the product or service you deliver.

Use this feedback to guide your business and marketing decisions. If a large percentage of customers suggest a product feature or want an additional customer service channel, listen to them! Your customers are your livelihood.

6. It can be used to identify customer advocates

Customer advocates are your best marketing campaigns. They offer tremendous value at very little cost. But how do you identify advocates?

Customer feedback. When you gather feedback from your customers, advocates are the ones who give you high scores. Contact these customers and build stronger, mutually-beneficial relationships.

Don’t be afraid to ask for a testimonial or referral– more times than not, these advocates want to help you.

Article Source: http://blog.clientheartbeat.com/why-customer-feedback-is-important/

Changing the data source of Form Authentication

I created my web application using the Web Form template in VS 2013. It was a quick installation setup where sample pages and the login module were already included.
The login uses the Default connection string which is sourced on the created .mdf file located the App_Data folder. It worked well without extra coding and configuration.
A week later, I decided to change my data source so that I can use my SQL Server membership database. It is not so complicated, just need to know where to do the changes in the application. Below are the steps I did:

1. Change the connection string in the web.config file from

<add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;
AttachDbFilename=|DataDirectory|\aspnet-MindwebUniversity-20141127075146.mdf;Initial 
Catalog=aspnet-MindwebUniversity-20141127075146;Integrated Security=True"
 providerName="System.Data.SqlClient" />

to

<add name="ApplicationServices" connectionString="Data Source=Mindweb;Initial Catalog=MindwebUniversity; Persist Security Info=True; User ID=Username;Password=1234" providerName="System.Data.SqlClient"/>

2. Provide values on the Membership, Providers and Role Managers sections

  <membership>
 <providers>
 <clear/>
 <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/"/>
 </providers>
 </membership>
 <profile>
 <providers>
 <clear/>
 <add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/"/>
 </providers>
 </profile>
 <roleManager enabled="true">
 <providers>
 <clear/>
 <add connectionStringName="ApplicationServices" applicationName="/" name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider"/>
 <add applicationName="/" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider"/>
 </providers>
 </roleManager>

3. View the project properties and ensure to change the value in the fields as shown in the image below.

settings