LinkedInNakul Vachhrajani

Nakul Vachhrajani

Technical Specialist at iGATE

Location
Ahmedabad Area, India
Industry
Information Technology and Services
Previous
  1. IGATE Patni,
  2. Patni Computer Systems Limited
Education
  1. Birla Institute of Technology and Science
Recommendations8 people have recommended Nakul
Websites
341connections

Join LinkedIn & access Nakul's full profile

Join LinkedIn & access Nakul's full profile. It's free!

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you know in common
  • Get introduced
  • Contact Nakul directly
341connections
Birla Institute of Technology and Science

Birla Institute of Technology and Science

Software Engineering

View full profile

Background

Summary

Nakul Vachhrajani is a Microsoft Certified Technology Specialist (SQL 2008: Implementation & Maintenance), TOGAF 9 certified Technical Specialist and systems development professional with IGATE having a total IT experience of more than 9 years. He has comprehensive grasp on Database Administration, Development and Implementation with MS SQL Server and C, C++, Visual C++/C#.

Nakul is an active blogger, can also be found on forums at SQLServerCentral and has been a guest columnist for SQLAuthority.com and SQLServerCentral.com. He has also presented a webcast in Microsoft Virtual Tech Days.

In addition to his passion about SQL Server, Nakul also contributes to the academia out of personal interest. He visits various colleges and universities as an external faculty to judge project activities being carried out by the students.

When not working occupied with work, Nakul likes to spend time with his family. His hobbies include travelling, listening to music and reading till late into the night.

Specialties: Microsoft SQL Server - administration & development
Product Development & Sustenance

Experience

Technical Specialist

iGATE
– Present (2 years 7 months)

Nakul Vachhrajani is a Microsoft Certified Technology Specialist (SQL 2008: Implementation & Maintenance), TOGAF 9 certified Technical Specialist and systems development professional with IGATE having a total IT experience of more than 9 years. He has comprehensive grasp on Database Administration, Development and Implementation with MS SQL Server and C, C++, Visual C++/C#.

Specialties: Microsoft SQL Server - administration & development
Product Development & Sustenance

Technical Lead

IGATE Patni
(2 years 10 months)

Senior Software Engineer

Patni Computer Systems Limited
(3 years)

Software Engineer

Patni Computer Systems Limited
(1 year 8 months)

Project Trainee

Patni Computer Systems Limited
(7 months)

Publications

SQL SERVER – Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server 2012 – Guest Post by Nakul Vachhrajani(Link)

SQLAuthority.com
May 2012

Those who have been following my blogs would be aware that I am recently running a series on the database engine features that have been deprecated in Microsoft SQL Server 2012. Based on the response that I have received, I was quite surprised to know that most of the audience found these to be breaking changes, when in fact, they were not! It was then that I decided to write a little piece on how to plan your database upgrade such that it works with the next version of Microsoft SQL Server.

SQL Server Interview Questions & Answers - My Views on Interviews(Link)

SQLAuthority.com
July 2011

Interviews are a reality of life, and we all have been facing them ever since we started understanding the world around us. There is always an anxiety when we, as an interviewee, are a prospective student or an employee. In this post, I present my views on evaluation of qualifications - it is important to define and understand the right qualification requirements and the expectations that the interviewer has for the job. As an interviewee, it is the prime challenge to understand what is required by the prospective employer. There are huge responsibilities on the part of the interviewer also, because the career of an prospective employee is at stake. I present, in this article, a bulleted list of some of the most important points that needs to be taken care of during an interview.

Securing TRUNCATE permissions in SQL Server(Link)

SQLAuthority.com
December 2010

There has always been some confusion around the TRUNCATE statement in SQLServer. Applying permissions around the TRUNCATE does not follow the standard security practices defined for SQL Server. In this article, I attempt to document how one can go about securing the TRUNCATE operation within Microsoft SQL Server.

Connection Strings 101(Link)

SQLServerCentral.com
December 2010

Connection strings are perhaps the least understood and most under-utilized features of SQL Server. A connection to a Microsoft SQL Server serves a lot of purposes and is much more than just a link between the application and the SQL server. A connection string controls, at a basic level, the security, performance and overall behaviour of SQL Server. In this post, I present an introduction to connection strings and attempt to draw attention to their many benefits.

Deleting large number of rows from a table and heap in a VLDB(Link)

SQLServerCentral.com
March 2011

Most enterprise class systems, with the help of their interfacing systems, tend to accumulate huge amounts of data over time. Post archiving, purging this data from the system efficiently has always been a challenge. In this post, I attempt to define strategies using which DBAs can delete large number of data rows from tables and heaps in a Very Large DataBase (VLDB).

Never update systems tables directly - a study in Agent job scheduling(Link)

SQLServerCentral.com
September 2012

The official SQL server documentation says "The system tables should not be changed directly by any user." This article is a case-in-point on why updating system tables directly is not recommended and does not work. The study is based on a real-life incident wherein changes to SQL Server Agent jobs did not take effect without requiring a restart of the SQL Server Agent service because the changes were made by directly updating the system tables - a documented bad practice.

An in-depth look at change detection in SQL Server - Part 01(Link)

SQLServerCentral.com
February 2013

All enterprise class products have at least one requirement that requires the application to be able to identify changed records for auditing, tamper protection and many other business needs. The question therefore is: What are the various change detection and tamper protection mechanisms available within SQL Server? How are they different from each other? In this in-depth study, I compare the various methods available in SQL Server - and come up with a recommendation the ideal method to achieve a given business requirement.

An in-depth look at change detection in SQL Server - Part 02(Link)

SQLServerCentral.com
February 2013

All enterprise class products have at least one requirement that requires the application to be able to identify changed records for auditing, tamper protection and many other business needs. The question therefore is: What are the various change detection and tamper protection mechanisms available within SQL Server? How are they different from each other? In this in-depth study, I compare the various methods available in SQL Server - and come up with a recommendation the ideal method to achieve a given business requirement.

HASHBYTES: Is CHECKSUM really required?(Link)

SQLServerCentral.com
March 2013

When the change detection and tamper protection mechanisms available within Microsoft SQL Server are compared, it becomes clear that the ideal mechanism is the "HASHBYTES" whereas a good "value-for-money" option is the "BINARY_CHECKSUM". This comparison raises a question as to whether the plain "CHECKSUM" is really required or not. In this article, I attempt to demonstrate the use of CHECKSUM in creating Hash-Indexes which can be helpful if the search criteria spans a large number of columns.

SQL Server Stored Procedures and SET options(Link)

SQLServerCentral.com
August 2013

Microsoft SQL Server stored procedures are traditionally described as a group of T-SQL statements compiled into a single execution plan to allow for a consistent implementation of business logic across the application and also improve performance due to plan caching.
The SET options defined for a connection influence query execution and query results. Because SQL Server needs to cache the stored procedure execution plan and reuse it across multiple connections, stored procedures exhibit slightly different behavior around SET options when compared to ad-hoc queries. Often, these differences in behavior are overlooked when developing deployment scripts and this mistake can lead to undesired behavior in the application.
In this article, I look at this special behavior with examples.

Leveraging Constraint Evaluation Sequence in SQL Server(Link)

SQLServerCentral.com
January 2014

Data quality is an important consideration for any business. Data validations help in ensuring that businesses can operate successfully, take appropriate decisions and plan for the future. In Microsoft SQL Server, data validations are generally embedded into the database design by the use of constraints.

Constraints allow us to validate business and integrity rules regarding the values allowed in columns. Because a table may have multiple constraints defined on various columns in the table, I was interested in the sequence in which various constraints are evaluated when an attempt is made to INSERT data into a table in Microsoft SQL Server. My research towards answering this question is documented in this article.

Certifications

Microsoft Certified Technology Specialist (SQL 2008: Implementation & Maintenance)

Microsoft Learning
– Present

TOGAF 9(Link)

The Open Group
– Present

Skills

  • Microsoft Servers
  • SQL Server
  • Visual Studio
  • Software Engineering
  • Software Design
  • Software Project...
  • Micro Focus COBOL
  • Crystal Reports
  • Quality Assurance
  • Database Administration
  • SDLC
  • SQL
  • Windows
  • Software Development
  • Databases
  • Application Development
  • Programming
  • Requirements Analysis
  • Testing
  • T-SQL
  • Performance Tuning
  • Database Design
  • Microsoft SQL Server
  • PL/SQL
  • .NET
  • SSRS
  • Oracle
  • Web Services
  • SSIS
  • ASP.NET
  • ETL
  • See 16+  See less

Languages

  1. English

    Full professional proficiency
  2. Hindi

    Professional working proficiency
  3. Gujarati

    Native or bilingual proficiency

Education

Birla Institute of Technology and Science

Master of Science, Software Engineering

Through Patni-BITS collaborative program.

Shree U.V. Patel College of Engineering

Bachelor of Engineering, Electronics & Communications

St. Xavier's High School, Jamnagar

Honors & Awards

- Speaker at Microsoft Virtual Tech Days on SQL Server 2008 R2 (May 06, 2011)
- Guest columnist at SQLServerCentral.com and on SQLAuthority.com
- Knowledge Management - Virtusso Award @ iGATE for H1, 2012
- Top SQL Server Maven @ iGATE for Q2, 2012

View Nakul's full profile to...

  • See who you know in common
  • Get introduced
  • Contact Nakul directly

Not the Nakul Vachhrajani you're looking for? View more

Insights


People Also Viewed

LinkedIn member directory:

  1. a
  2. b
  3. c
  4. d
  5. e
  6. f
  7. g
  8. h
  9. i
  10. j
  11. k
  12. l
  13. m
  14. n
  15. o
  16. p
  17. q
  18. r
  19. s
  20. t
  21. u
  22. v
  23. w
  24. x
  25. y
  26. z
  27. more