Feb 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
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Oct19

SQLAuthority News – Storing Data and Files in Cloud – Dropbox – Personal Technology Tip

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Personal Technology
6 Comments
I thought long and hard about doing a Personal Technology Tips series for this blog.  I have so many tips I’d like to share.  I am on my computer almost all day, every day, so I have a treasure trove of interesting tidbits I like to share if given the…
Read More
Oct18

SQL SERVER – Finding Different ColumnName From Almost Identitical Tables

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL System Table
8 Comments
I have mentioned earlier on this blog that I love social media – Facebook and Twitter. I receive so many interesting questions that sometimes I wonder how come I never faced them in my real life scenario. Well, let us see one of the similar situation. Here is one of…
Read More
Oct17

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

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices
1 Comment
This is the second part of the two part series of Practices for Software Startup Pluralsight Course. Please read the first part of this series over here. The course is written by Stephen Forte (Blog | Twitter). Stephen Forte is the Chief Strategy Officer of the venture backed company, Telerik. Personal…
Read More
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
Previous 1 … 500 501 502 503 504 505 506 … 829 Next
SQL SERVER - Dedicated Database Development with SQL Source Control dtc-02

SQL SERVER – FIX: Msg 7395, Level 16, State 2 – Unable to start a nested transaction for OLE DB provider

SQL SERVER – System.IO.FileNotFoundException: Could not load file or assembly

SQL SERVER - Dedicated Database Development with SQL Source Control 111-1

SQL SERVER – Live Query Statistics in 2016 … and More! – Notes from the Field #111

SQL SERVER – Starting / Stopping SQL Server Agent Services using PowerShell

SQL SERVER – Performance counter missing! DMV sys.dm_os_performance_counters is Empty

Interview Question of the Week #054 – Retrieve User Defined Object Details from sys.objects

SQL SERVER - Dedicated Database Development with SQL Source Control link_db_to_sc

SQL SERVER – Dedicated Database Development with SQL Source Control

Previous 1 … 500 501 502 503 504 505 506 … 829 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 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 100 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.


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