Contact Me

Ayyappan is a Microsoft SQL Server Database and Business Intelligence Consultant. He delivers SQL Server BI solutions using Microsoft SSIS, SSAS, SSRS, PowerPivot. He can also do SQL Server Database performance tuning, SQL Query performance tuning, SQL Server Database / BI Administration and development. He is the founder and president of Puducherry SQL Server User Group (PSSUG) – India.

if you are looking for a Database or Business Intelligence professional to help you with a particular need or project, then contact me.

I would also like to discuss any SQL Server related topic for design, develop and deployment.

yourtube

Advertisements
  1. July 20, 2011 at 11:07 am

    Your blog has some real good information. I would like to incoorporate it some how with my site http://www.sqlserverjobs.com.

    Glen

  2. April 6, 2013 at 11:29 am

    What a great peace of sharing you have done !
    Hats of for everything !

  3. Maximilian
    December 1, 2014 at 5:55 pm

    Dear Mr.Thangaraj

    I Have tried to do the pwdcompare() and it didnt work for me, I am using ASP.NET membership and the database was created using that aspnet_regsql.exe I Have tried the following syntax.

    SELECT Password
    FROM aspnet_Membership
    WHERE PWDCOMPARE(‘Password321!’, Password) = 1;

    that return nothing, but if i put i to 0 it returns some data.

    if you want a better understanding I Posted a question on stackoverflow :
    http://stackoverflow.com/questions/27221253/ms-sql-hashed-password-compare-to-plain-text

    I also Tried :

    SELECT Password,PWDCOMPARE(‘Password321!’,Password) password_match FROM aspnet_Membership, aspnet_Users WHERE UserName = ‘admin’; Password Match = 0

    but for the sa which is the login I use for the sql management it worked. if you are wondering my passwords are correct, as I can Login into my Website.

    Thanks for your time,

    Maximilian

  4. triparna ray
    November 21, 2015 at 10:01 pm

    I would like to discuss with you on one of the ssis internal process which my client is enquiring about.how can I get in touch with you.its urgent so can you mail me or provide your contact details please.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: