Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check
Oct16

SQLAuthority News – Pluralsight Course Review – Practices for Software Startups – Part 1 of 2

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices
3 Comments
This is first part of the two part series of Practices for Software Startup Pluralsight Course. The course is written by Stephen Forte (Blog | Twitter). Stephen Forte is the Chief Strategy Officer of the venture backed company, Telerik, a leading vendor of developer and team productivity tools. Stephen is also…
Read More
Oct15

SQL SERVER – Free Print Book on SQL Server Joes 2 Pros Kit

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQLAuthority Book Review
23 Comments
Rick Morelan and I were discussing earlier this month that what we can give back to the community. We believe our books are very much successful and very well received by the community. The five books are a journey from novice to expert. The books have changed many lives and…
Read More
Oct14

SQL SERVER – Find First Non-Numeric Character from String

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String
11 Comments
It is fun when you have to deal with simple problems and there are no out of the box solution. I am sure there are many cases when we needed the first non-numeric character from the string but there is no function available to identify that right away. Here is…
Read More
Oct13

SQL SERVER – 2012 – List All The Column With Specific Data Types in Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DMV, SQL System Table
19 Comments
5 years ago I wrote script SQL SERVER – 2005 – List All The Column With Specific Data Types, when I read it again, it is very much relevant and I liked it. This is one of the script which every developer would like to keep it handy. I have…
Read More
Oct12

SQL SERVER – Advanced Data Quality Services with Melissa Data – Azure Data Market

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
DQS, SQL Utility
6 Comments
There has been much fanfare over the new SQL Server 2012, and especially around its new companion product Data Quality Services (DQS). Among the many new features is the addition of this integrated knowledge-driven product that enables data stewards everywhere to profile, match, and cleanse data. In addition to the…
Read More
Oct11

SQLAuthority News – Amazon Gift Card Raffle for Beta Tester Feedback for NuoDB

Pinal Dave
SQL Tips and Tricks
NuoDB
2 Comments
As regular readers know I’ve been spending some time working with the NuoDB beta software. They contacted me last week and asked if I would give you a chance to try their new web-based console for their scalable, SQL-compliant database. They have just put out their final beta release, Beta…
Read More
Oct10

SQL SERVER – Find Rows and Index Count – SQL in Sixty Seconds #029 – Video

Pinal Dave
SQL Performance
Clustered Index, Database, SQL in Sixty Seconds, SQL Index, SQL Scripts, SQL Server Management Studio
12 Comments

There are a few questions I often get asked. I wonder how interesting is that in our daily life all of us have to often need the same kind of information at the same time. Here is the example of the similar questions about index count:

Read More
Previous 1 … 502 503 504 505 506 507 508 … 831 Next

SQLAuthority News – Pluralsight Course Review – Practices for Software Startups – Part 1 of 2

SQL SERVER – Free Print Book on SQL Server Joes 2 Pros Kit

SQL SERVER - Find Rows and Index Count - SQL in Sixty Seconds #029 - Video patindexexample

SQL SERVER – Find First Non-Numeric Character from String

SQL SERVER – 2012 – List All The Column With Specific Data Types in Database

SQL SERVER – Advanced Data Quality Services with Melissa Data – Azure Data Market

SQLAuthority News – Amazon Gift Card Raffle for Beta Tester Feedback for NuoDB

SQL SERVER - Find Rows and Index Count - SQL in Sixty Seconds #029 - Video 29-800x450

SQL SERVER – Find Rows and Index Count – SQL in Sixty Seconds #029 – Video

Previous 1 … 502 503 504 505 506 507 508 … 831 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 109 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

Comprehensive Database Performance Health Check

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.


SQL Server Performance Tuning Practical Workshop

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.


  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com