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
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
Next value in a sequence.

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

May 26, 2012
Pinal Dave
SQL Puzzle

Part 2 of fun with SEQUENCE: the same script as before, but without MINVALUE. Now guess the next value SQL Server 2012 returns after the cycle.

Read More
SQL SERVER - A Puzzle - Fun with SEQUENCE in SQL Server 2012 - Guess the Next Value

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

May 25, 2012
Pinal Dave
SQL Puzzle
SQL Scripts

A fun puzzle on SEQUENCE in SQL Server 2012: a sequence starts at 3 and cycles with a maximum of 5. Can you guess the next value it returns?

Read More
SQL SERVER - A Puzzle - Fun with NULL - Fix Error 8117

SQL SERVER – A Puzzle – Fun with NULL – Fix Error 8117

May 24, 2012
Pinal Dave
SQL Puzzle
SQL NULL, SQL Scripts, SQL Server

NULL is fun to ask about in interviews, since every answer I get is different. A short puzzle on NULL that raises Error 8117, and how to fix it.

Read More
Gouache painting of a database character beside a stopwatch

Standard Reports in SSMS: SQL in Sixty Seconds #016

May 23, 2012
Pinal Dave
SQL Video
SQL DMV, SQL in Sixty Seconds, SQL Reports, SQL Server Management Studio

Standard Reports in SSMS put activity, space and performance information a few clicks away. This post adds T-SQL queries for the same questions, tested on SQL Server 2025, and shows the permission error a reader without VIEW SERVER PERFORMANCE STATE receives.

Read More
SQL SERVER - SmallDateTime and Precision - A Continuous Confusion

SQL SERVER – SmallDateTime and Precision – A Continuous Confusion

May 22, 2012
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Training

SmallDateTime and precision confuse a lot of people. I explain what the precision really is, using a Facebook question from Raghavendra.

Read More
SQL SERVER - Renaming Index - Index Naming Conventions

SQL SERVER – Renaming Index – Index Naming Conventions

May 21, 2012
Pinal Dave
SQL Tips and Tricks
SQL Index

Tables got renamed to a new standard, but what about the indexes? Tell me which index naming conventions you follow when renaming an index.

Read More
Previous 1 … 376 377 378 379 380 381 382 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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