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
Gouache painting of a workshop pegboard holding many different tools in neat outlines, a hand plane, a magnifying glass, a small blank chalkboard, a ruler and a sketchbook, with one vermilion mallet standing out

Every Way to Learn, and Which One Fits You

May 31, 2012
Pinal Dave
Personal
Best Practices, Career Advice, SQL Training

There is no single best way to learn a technical craft. Courses, books, reading code, pairing, building, teaching and AI tutors each do one job well. Here is every way to learn, what each is good for and how to choose the one that fits you.

Read More
Gouache painting of two chisels on a workbench, one old with a worn handle and one brand new, tied together with a single vermilion ribbon under a warm work lamp

Employee Training Is a Promise Both Sides Keep

May 29, 2012
Pinal Dave
Personal
Best Practices, Career Advice, SQL Training

Employee training is a promise with two sides. The employer promises time, guidance and room to grow. The developer promises attention, effort and honesty, even on the way out. Here is what each side owes, and why keeping it matters.

Read More
Gouache painting of an old school satchel sprouting seedlings on a potting bench beside a small red watering can

Developer Training: The Day School Ends and Learning Begins

May 28, 2012
Pinal Dave
Personal
Best Practices, Career Advice, SQL Training

Developer training starts the day school ends. A degree opens the workshop door, but the craft is learned at the bench, with real code, real mistakes and someone beside you. Here is why companies and developers should both care.

Read More
An open blank book with a plain fabric bookmark beside a natural wooden pencil on a quiet desk.

Getting Through a Technical Book You Actually Finish

March 25, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Read a technical book with a practical question, small SQL experiments, and reusable notes that turn each useful chapter into working knowledge.

Read More
A shop window with a clean rectangular section wiped in the condensation, showing part of the display behind

What Is a View in SQL Server?

March 11, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

A view in SQL Server is a saved query, not a saved copy. Nothing is stored, the text is run every time, and that single fact explains what a view is good for and why it never makes anything faster.

Read More
An old metal key rests beside a newer unmarked key on folded plain linen.

Finding Deprecated Features Before They Bite

March 9, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Find deprecated features with SQL Server counters, event metadata, and code searches, then separate future risk from features already removed.

Read More
A shallow wooden sorting tray holding plain folded fabric beside a closed storage box on a table.

Why Staging Tables Earn Their Keep

March 5, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Data Warehousing, Database, ETL

Use staging tables to preserve raw input, validate changes, separate extraction from publication, and make failed loads easier to diagnose and replay.

Read More
Previous 1 … 21 22 23 24 25 26 27 … 54 Next
  • Books
  • Testimonials
  • Privacy Policy

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