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
Sequence values displayed in SQL Server Management Studio.

SQL SERVER – A Puzzle Part 4 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value

June 2, 2012
Pinal Dave
SQL Puzzle

Part 4 of my SEQUENCE puzzles uses a DECIMAL sequence that counts down by 1 and cycles. Can you guess the next value SQL Server 2012 returns?

Read More
Gouache painting of an empty wooden stool at a workbench at dawn, with a folded letter sealed in vermilion wax resting beside a well worn tool left for a newcomer

A Letter to the Developer Starting Out

June 1, 2012
Pinal Dave
Personal
Best Practices, Career Advice, SQL Training

A letter to every developer starting out: it’s fine not to know, your hands learn slower than your head, choose people over perks, keep your promises and keep learning. One day you will be the one standing beside the bench.

Read More
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
A pepper mill holds peppercorns above its mechanism with an unsuitable pebble caught before grinding

Second-Order SQL Injection: When Stored Data Becomes Code

May 30, 2012
Pinal Dave
SQL Tips and Tricks
Dynamic SQL, SQL Server Security, SQL String, SQL Variable

A safe insert does not make the saved value safe forever. Here is how stored text turns into code later, and the plain fix.

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
SQL SERVER - A Puzzle Part 3 - Fun with SEQUENCE in SQL Server 2012 - Guess the Next Value

SQL SERVER – A Puzzle Part 3 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value

May 27, 2012
Pinal Dave
SQL Puzzle

My SEQUENCE puzzle part 3 involves some service related steps, so run it only on a test machine, never on production. Can you guess the next value?

Read More
Previous 1 … 532 533 534 535 536 537 538 … 841 Next
  • Books
  • Testimonials
  • Privacy Policy

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