Pinal Dave

Bengaluru, Karnataka, India Contact Info
30K followers 500+ connections

Join to view profile

  • Contact Pinal for services

    IT Consulting and Database Development

About

I help organizations resolve their SQL Server Performance Tuning problems.

I work…

Contributions

Join now to see all contributions

Activity

Join now to see all activity

Experience & Education

  • Independent Consultant

View Pinal’s full experience

See their title, tenure and more.

or

By clicking Continue to join or sign in, you agree to LinkedIn’s User Agreement, Privacy Policy, and Cookie Policy.

Volunteer Experience

  • President

    Gandhinagar SQL Server User Group

    - 3 years 1 month

    Education

    Pinal Dave is actively engaged in SQL Server community through his technology blog and website. Commendable community service; Leads two usergroups - Gandhinagar SQL Server User Group and Ahmedabad SQL Server User Group. http://gandhinagar.sqlpass.org/

  • President

    Bangalore SQLPASS

    - Present 12 years 7 months

    Education

    Pinal Dave is actively engaged in SQL Server community through his technology blog and website. http://sqlbang.pass.org/

Publications

  • SQL Server Interview Questions and Answers : For All Database Developers and Database Administrators

    Nov 2011

    This book will flow in a “Question & Answer” mode from start to finish to help you grasp concepts faster and get to the point quickly. Once you understand the concepts, it gets easier to see twists using that concept within a scenario and to ultimately solve them. Though each of these chapters are geared towards convenience we highly recommend reading each of the sections irrespective of the roles you might be doing since each of the sections have some interesting trivia about working with SQL…

    This book will flow in a “Question & Answer” mode from start to finish to help you grasp concepts faster and get to the point quickly. Once you understand the concepts, it gets easier to see twists using that concept within a scenario and to ultimately solve them. Though each of these chapters are geared towards convenience we highly recommend reading each of the sections irrespective of the roles you might be doing since each of the sections have some interesting trivia about working with SQL Server. In the industry the role of accidental DBA’s (especially with SQL Server) is very common. Hence if you have performed the role of DBA for a short stint and want to brush-up your fundamentals then the upcoming sections will be a great review.

    Other authors
    See publication

  • SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues

    Joes 2 Pros

    You learn a lot when thrown into a crisis situation, where everyone is looking to you for answers. The system is down, the CEO is pleading to you for answers as the each minute cuts the company’s bottom line. When you are in a hurry, you need some new ideas right away. This book is your helpful tool. When used correctly, you can determine solutions and even related solutions to simple (yet lesser known) areas of SQL Server. Learn what causes SQL tasks to wait or site in queues. Even if your…

    You learn a lot when thrown into a crisis situation, where everyone is looking to you for answers. The system is down, the CEO is pleading to you for answers as the each minute cuts the company’s bottom line. When you are in a hurry, you need some new ideas right away. This book is your helpful tool. When used correctly, you can determine solutions and even related solutions to simple (yet lesser known) areas of SQL Server. Learn what causes SQL tasks to wait or site in queues. Even if your system is not in trouble right now, you can use what you will learn in this book to view the history of wait statistics.

    Other authors
    See publication

  • SQL Programming Joes 2 Pros: Programming & Development for Microsoft SQL Server 2008 (SQL Exam 70-433) Volume 4

    Joes 2 Pros

    The SQL developer needs to be able to create processes for the working database by using one of the many programming objects (like functions, stored procedures, constrains, or triggers). By creating objects that talk with SQL you simply the way other programs (like applications or web pages) can interconnect. These eternal programs only need to call on the names of your programming objects by name rather than needing to submit large pieces of advance code. With SQL Programming Development…

    The SQL developer needs to be able to create processes for the working database by using one of the many programming objects (like functions, stored procedures, constrains, or triggers). By creating objects that talk with SQL you simply the way other programs (like applications or web pages) can interconnect. These eternal programs only need to call on the names of your programming objects by name rather than needing to submit large pieces of advance code. With SQL Programming Development (Volume 4 of 5) in the SQL Server Joes 2 Pros development series, you learn how programming objects work in SQL Server.

    Other authors
    See publication

Projects

  • SQL Server Performance: Introduction to Query Tuning

    -

    SQL Server performance tuning is an art to master - for developers and DBAs alike. This course takes a systematic approach to planning, analyzing, debugging and troubleshooting common query-related performance problems. This includes an introduction to understanding execution plans inside SQL Server.

    Other creators
    See project

  • SQL Server Performance: Indexing Basics

    -

    SQL Server Performance: Indexing Basics
    This course teaches you how to master the art of performance tuning SQL Server by better understanding indexes.

    Other creators
    See project

  • SQL Server Questions and Answers

    -

    This course is designed to help you better understand how to use SQL Server effectively. The course presents many of the common misconceptions about SQL Server, and then carefully debunks those misconceptions with clear explanations and short but compelling demos, showing you how SQL Server really works.

    Other creators
    See project

Languages

  • Hindi

    -

  • Gujarati

    -

  • English

    -

Recommendations received

26 people have recommended Pinal

Join now to view

More activity by Pinal

View Pinal’s full profile

  • See who you know in common
  • Get introduced
  • Contact Pinal directly
Join to view full profile

Other similar profiles

Explore more posts

Explore collaborative articles

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

Explore More

Others named Pinal Dave in India

9 others named Pinal Dave in India are on LinkedIn

See others named Pinal Dave

Add new skills with these courses

See all courses