Profile

Cover photo
Pinal Dave
Works at SQLAuthority.com
Attended University of Southern California
Lives in Bangalore, India
9,814 followers|1,016,666 views
AboutPostsPhotosYouTube+1's

Stream

Pinal Dave

Shared publicly  - 
 
Learn How to install SQL Server Management Studio 2016
2
1
Add a comment...

Pinal Dave

Shared publicly  - 
 
Just create a new video of installing SQL Server 2016 in 2 minutes.
4
1
Anand Dwivedi's profile photoPinal Dave's profile photo
2 comments
 
Check the description. It has link to download full version legally 
Add a comment...

Pinal Dave

Shared publicly  - 
 
Your SQL is tuned perfectly and delivers thousands of rows in milliseconds on your test system, but your end users are complaining about slow application performance. Time is of the essence because the poor performance affects productivity and the company’s ability to make money. Everybody is looking at the database as the culprit. You know it’s not. But what do you do? Let us learn in this blog about How to Identify Application vs Network Perfor...
3
Add a comment...

Pinal Dave

Shared publicly  - 
 
Install SQL Server 2016 Sample Database WideWorldImporters
2
Add a comment...

Pinal Dave

Shared publicly  - 
 
Question of the day - Does Order of Column in WHERE Clause Matter?
Today is quick puzzle time. Let us learn about - Does the order of column used in WHERE clause matter for performance?
1
bhavik hingu's profile photo
 
Yes in case of finding newer records it is required
Add a comment...

Pinal Dave

Shared publicly  - 
 
Download SQL SERVER 2016 Developer Edition for FREE

Just a few minutes ago SQL Server 2016 is released. You can download SQL Server 2016 Developer Edition for FREE. There are many different versions of SQL Server 2016 and they are all available for download for everyone who has a valid MSDN subscription.
Just a few minutes ago SQL Server 2016 is released. You can download SQL Server 2016 Developer Edition for FREE. There are many different versions of SQL Server 2016 and they are all available for download for everyone who has a valid MSDN subscription. SQL Server 2016 is only available in 64 bit version.
11
2
Add a comment...

Pinal Dave

Shared publicly  - 
5
Geeta Davey's profile photoveeramani narayanasamy's profile photoKamal Rai's profile photo
4 comments
 
PD I just started....basically not even started but don't know from where to start and what to start...can u plse help me out in DBA
Add a comment...

Pinal Dave

Shared publicly  - 
 
Can you solve it?
Pinal Dave originally shared:
 
It has been a long time since I have asked, puzzled on this blog so let us have fun time together with ISNUMERIC function. If you get the correct answer to this question, I will give you one month free subscription to Pluralsight. The question is in the…
It has been a long time since I have asked, puzzled on this blog so let us have fun time together with ISNUMERIC function. If you get the correct answer to this question, I will give you one month ...
7
1
Add a comment...
Story
Tagline
SQL Server , SQLAuthority and Simple Words
Introduction
Pinal Dave is a Pluralsight Developer Evangelist. He has authored 9 SQL Server database books and have written over 2500 articles on the database technology on his blog at a http://blog.sqlauthority.com. Along with 9+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ. Prior to joining Microsoft he was awarded the Microsoft MVP award for three continuous years for his contribution in the community. 

Education
  • University of Southern California
    MS - Computer Networks, 2001 - 2003
  • Newcastle University
    BE - Electronics and Communication, 1997 - 2001
Basic Information
Gender
Male
Other names
pinaldave, sqlauthority, Pinal Dave, SQL Authority
Links
YouTube
Contributor to
Work
Occupation
SQL DBA, SQL Server Developer, SQL Blogger
Employment
  • SQLAuthority.com
    Independent Consultant, 2006 - present
  • Pluralsight
    Developer Evangelist, 2012 - 2015
  • Microsoft
    Technical Evangelist, 2011 - 2012
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Bangalore, India
Contact Information
Home
Email
Work
Email
Pinal Dave's +1's are the things they like, agree with, or want to recommend.
MySQL Backup and Recovery Fundamentals
pluralsight.com

Data is very important to any application and business. It is very important that every business plan for data safety. Database backup strat

MySQL Query Optimization and Performance Tuning
pluralsight.com

Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best effici

Building a High Traffic, Profitable Blog
pluralsight.com

Everybody can write, and everybody can build a blog. But not everyone can make their blog a popular point of reference for their subject mat

MySQL Fundamentals Part 2
pluralsight.com

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web applic

Building a Successful Blog
pluralsight.com

In this introductory course on blogging we will go over a few of the basics of blogging and show the way to get started with blogging immedi

MySQL Fundamentals
pluralsight.com

Fundamentals of MySQL, an essential part of the LAMP stack.

Technology « SQL Server Journey with SQL Authority
blog.sqlauthority.com

“No Guests PLEASE!” “Doesn't your Indian tradition suggest welcoming guests and treating them in the best way possible?” “Yes, but I am

Pinal Dave « SQL Server Journey with SQL Authority
blog.sqlauthority.com

SQL SERVER – Puzzle to Win Print Book – Explain Value of PERCENTILE_CONT() Using Simple Example. Posted in Pinal Dave, PostADay, SQL, SQL Au

SQL Server Performance: Indexing Basics
www.pluralsight-training.net

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

Beginning SQL Joes 2 Pros (Set Of 5 Books) - Rick A. Morelan,Pinal Dave,...
www.flipkart.com

Beginning SQL Joes 2 Pros (Set Of 5 Books) by Rick A Morelan Pinal Dave Doug Fritz Jessica Brown. Rs.2796, Save 20%. Buy Beginning SQL Joes

Pluralsight Author
www.pluralsight-training.net

I'm learning more about Pinal Dave

SQL SERVER – 2008 – Missing Index Script – Download
sqlauthority.wordpress.com

Download Missing Index Script with Unused Index Script and Duplicate Index Script Performance Tuning is quite interesting and Index plays a

SQL SERVER – 2008 – Unused Index Script – Download
sqlauthority.wordpress.com

Download Missing Index Script with Unused Index Script and Duplicate Index Script Performance Tuning is quite interesting and Index plays a

SQL Server Interview Questions and Answers for all Database Developers a...
www.flipkart.com

SQL Server Interview Questions and Answers for all Database Developers and Database Administrators by Pinal Dave Vinod Kumar Rhonda Chesley