This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Bluetooth volume control issue illustrated by a faucet whose control is separate from the main slider

Personal Technology – Bluetooth Volume Problem with Windows Volume Control

June 15, 2019
Pinal Dave
Personal
Personal Technology, Windows

Bluetooth volume stays the same from 1 to 100 in Windows? Diagnose Absolute Volume, use a reversible fix, and restore the original setting.

Read More
coffee mug

Indexes and SELECT Queries: A Coffee Mug, Tested

June 5, 2019
Pinal Dave
Personal
SQL Index, SQL Performance, SQL Scripts

Indexes and SELECT queries met on a coffee mug from my friend Harvey Powell. Its two sides say indexes slow down SELECT queries and to drop unused indexes. The tests here show when a forced index reads 46 times more pages, what the usage counters report for an unused index, and why zero reads did not mean zero purpose.

Read More
Gouache painting of a closed wooden box with a red wax seal beside an open basket on a wrapping table

Move a WordPress Site from HTTP to HTTPS: A Complete Tutorial

March 16, 2017
Pinal Dave
Personal
Blogging, Personal Technology, WordPress

Moving a WordPress site from HTTP to HTTPS is seven steps. This tutorial covers the backup, the certificate, the two WordPress addresses, the link replacement, mixed content, the 301 redirect and the follow-up in Search Console and Analytics.

Read More
CrossFit Level 1 Trainer

My Journey to CrossFit Level 1 Trainer (CF-L1) Credential

February 22, 2017
Pinal Dave
Personal
CrossFit

Yes, it is true! I Earned CrossFit Level 1 Trainer (CF-L1) Credential. Let us see my journey to CrossFit rookie to expert.

Read More
A blank planning folio gathers materials and inspection tools before work begins in the adjoining studio.

Consultant’s Life – 30 Minutes Pre Call With Customer for SQL Server Performance Tuning

September 6, 2016
Pinal Dave
Personal
Consulting, SQL Server

A Pre Call gives a performance-tuning engagement a clear starting point. I want to understand the symptom and what the customer needs.

Read More
Gouache painting of a dripping tap over a bucket, a set of unused fancy tools and a plain red wrench

Understanding Your Customer: Listen Before You Fix

July 30, 2016
Pinal Dave
Personal
Career Advice, Consulting, DBA, Life Lessons

Understanding your customer is the first step of consulting and DBA work. This post uses one plumber metaphor to show why a fix needs an explanation, why hearing is not listening, how a scoping call helps and why the plain tool beats the fancy one.

Read More
Shop counter with a service bell, a card and flowers, ready to welcome customers

Life Lessons – Are There Rules for Interacting With Customers?

July 15, 2016
Pinal Dave
Personal
Life Lessons

I personally don’t claim to know everything and most of my soft skills, learning/techniques has got seasoned over the years. Interacting With Customers

Read More
Previous 1 2 3 4 5 … 11 Next
  • Books
  • Testimonials
  • Privacy Policy

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