About

Hello There,

My name is Vishal Harishbhai Gajjar, I am DATEDIFF(MONTH,'1984-07-13',GETDATE())/12 years old as of right now. I am currently employed by Hewlett-Packard GlobalSoft Limited, I have been working here since January 2008. This is my first Job after completing my Master’s in Computer Application from Nirma University, Ahmedabad.

[UPDATE] 25-April-2013 – Joined CHR Solutions

I wrote my first SELECT statement in 2006, for an academic project.. :). I have been working professionally with SQL Server since 2008, the year not the edition.. :). So, I am a new kid on the block. I have also bagged some certifications in SQL Server last year, which includes – Database Administrator, Database Developer and Business Intelligence Developer.

MCITP-2008

 

Professional Qualifications:

Bachelor of Commerce, Gujarat University
(cleared in two attempts, I failed in 4 out of 7 subjects the first time)

Master of Computer Applications, Nirma University
(no problems here :) )

MCTS – SQL Server® 2005, Implementation and Maintenance

MCITP – Database Administrator 2008
MCTS – SQL Server® 2008, Implementation and Maintenance

MCITP – Business Intelligence Developer 2008
MCTS – SQL Server® 2008, Business Intelligence Development and Maintenance

MCITP – Database Developer 2008
MCTS – SQL Server® 2008, Database Development

MCITP – Enterprise Administrator on Windows Server® 2008
MCTS – Windows Server® 2008 Applications Infrastructure, Configuration
MCTS – Microsoft Windows Vista®, Configuration

MCITP – Server Administrator on Windows Server® 2008
MCTS – Windows Server® 2008 Active Directory, Configuration
MCTS – Windows Server® 2008 Network Infrastructure, Configuration

 

SQL Server Awards:

Received the Microsoft Community Contributor (MCC) award in June, 2011
MCC

 

Through this blog I share my learnings and experiences with SQL Server. I hope you enjoy this blog as much as I do writing it. I would love to hear your questions, thoughts, comments or complaints about the blog or anything else you might want to say. My contact information is below:

 

How to Contact Me:

Email Me at – Vishal@SqlAndMe.com

Twitter – @SqlAndMe

Find me on LinkedIn – Vishal Gajjar

Find me on Google+

Check out my Facebook Page – SqlAndMe

 

Where else you can find me:

I regularly contribute and answer queries at :
SQL Server MSDN Forums

I syndicate my posts to SQLServerPedia,  beyondrelational.com, SQLServerCentral.com
Logos_All

 

Thanks for your visit.

- Vishal

  1. August 13, 2012 at 7:22 pm

    Great … to know .. thanks for sharing ..

  2. vikas
    September 8, 2012 at 4:27 pm

    I think u r DATEDIFF(year,’1984-07-13′,GETDATE()) year old

  3. padmaja
    October 8, 2012 at 11:19 am

    good to know .. and inspiring too…

    • February 13, 2013 at 12:11 am

      Wrong. Need to do it by month, otherwise what if his birthday has not occurred yet in the current year?

      • Subhradeep Bhowmik
        April 2, 2014 at 9:12 pm

        I think even by month, there is some inaccuracy when measuring age when the measurement is taken in the same month as the birthday and on a day before the birthday…

        Here is an idea for measuring age down to the day…

        –Test Age Calc
        DECLARE @birthdate as DATETIME,
        @measuredate AS DATETIME;

        SELECT @birthdate = ‘7/13/1984′;

        SELECT @measuredate = ‘7/10/2014′;

        –> Inacurate way if we are measuring in the birthday month, before the birthday
        SELECT DATEDIFF(MONTH, @birthdate,@measuredate)/12 AS YearsOld;
        –> He is not yet 30 until the 13th…this one gets the wrong answer.

        –> date sliding technique…slide to the first of the month to enable accurate DateDiff with MM…divide by 12 to get years
        SELECT DATEDIFF(mm, DATEADD(dd, -DAY(@birthdate)+1, @birthdate), DATEADD(dd, -DAY(@birthdate)+1, @measuredate))/12 AS YearsOld;
        –> He is still 29. This one gets the correct answer.

  4. Rahul
    December 20, 2012 at 6:56 pm

    Good one….Truly inspiring…

  5. Jason
    January 17, 2013 at 2:52 am

    Posted on: http://sqlandme.com/tag/eventdata-xml/

    Wanted to share my Add_extended_ properties

    CREATE TRIGGER [DB_Add_extended_properties]

    ON DATABASE

    FOR CREATE_TABLE,CREATE_VIEW, CREATE_PROCEDURE
    AS

    SET NOCOUNT ON
    DECLARE @eventInfo XML
    SET @eventInfo = EVENTDATA()

    DECLARE @timestamp DATETIME, @user VARCHAR(100), @ObjectType VARCHAR(50), @ObjectName VARCHAR(50)

    SELECT @timestamp=GETDATE()
    SELECT @user=SYSTEM_USER
    SET @ObjectType=CONVERT(VARCHAR(50),@eventInfo.query(‘data(/EVENT_INSTANCE/ObjectType)’))
    SET @ObjectName=CONVERT(VARCHAR(50),@eventInfo.query(‘data(/EVENT_INSTANCE/ObjectName)’))

    EXEC sys.sp_addextendedproperty @name=N’Created by’, @value=@user , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=@ObjectType ,@level1name=@ObjectName

    EXEC sys.sp_addextendedproperty @name=N’Purpose’, @value=N” , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=@ObjectType ,@level1name=@ObjectName

    EXEC sys.sp_addextendedproperty @name=N’Created on’, @value=@timestamp, @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=@ObjectType ,@level1name=@ObjectName
    GO

  6. Anil
    March 13, 2013 at 12:03 pm

    Hi i am a new DBA , in sql server 2005 ,in event viewer have show error continuously. i am not understand how to resolved please tell me.

    Error1:

    SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 10.10.10.114]

  7. Paul
    March 20, 2013 at 2:19 am

    http://bit.ly/10em0HZ

    Anil :
    Hi i am a new DBA , in sql server 2005 ,in event viewer have show error continuously. i am not understand how to resolved please tell me.
    Error1:
    SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 10.10.10.114]

  8. Graeme
    April 25, 2013 at 12:26 am

    Hi, Vishal–
    A picture of you in the About would be a nice touch!

  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

Follow

Get every new post delivered to your Inbox.

Join 273 other followers

%d bloggers like this: