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
SQL SERVER - Beginning of SQL Server Security

SQL SERVER – Beginning of SQL Server Security

August 2, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

The beginning of SQL Server security: how authentication, logins, users and permissions work together to keep your data safe from misuse.

Read More
Five pitfalls with their results: FORCESCAN read 225 pages instead of 2, @@ERROR was 0 after a PRINT, a schema GRANT reached a later table and a DENY removed it, modify() failed with Msg 2337 and Msg 5302, and recursion stopped with Msg 530 at level 100

SQL Server Pitfalls: Five Short Lessons With the Fix for Each

August 1, 2012
Pinal Dave
SQL Tips and Tricks
Query Hint, SQL Error Messages, SQL Server Security, SQL XML

SQL Server pitfalls start with a small assumption. This page shows five of them, one for each topic: query hints, errors, permissions, XML and recursive queries. Each lesson shows the mistake first and the tested fix second. Every result comes from SQL Server 2025.

Read More
A narrow fabric tape stretches between two fixed clips with cloth extending outside both ends

Time-Limited Access: Expiring Grants With a Valid-Until Column

July 21, 2012
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL DateTime, SQL Server Security, SQL View

A ValidUntil column does nothing by itself. Here is how to make the read path enforce it, with a demo you can run.

Read More
SQL Server role mappings.

SQL SERVER – Solution – User Not Able to See Any User Created Object in Tables – Security and Permissions Issue

June 19, 2012
Pinal Dave
SQL Tips and Tricks
SQL Server Security

A friend could connect to SQL Server but could not see any user created object, while his colleague could. It was a security and permissions issue.

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
Five lesson rows with their results: error 2627 caught and thrown again, a procedure that returned 11,200.00 while a direct SELECT failed with 229, tea found on slips 1 and 3, the breadcrumb Library > Garden > Herbs > Basil, and a hint that cut reads from 5,740 to 318

SQL Server Lessons: Five Short Scripts You Can Run in a Minute

May 16, 2012
Pinal Dave
SQL Tips and Tricks
CTE, Query Hint, SQL Server Security, SQL XML

SQL Server lessons stick when you can run them in a minute. This page covers errors, security, XML, hierarchies and query hints. Each lesson asks one question and answers it with a short script. Every result comes from SQL Server 2025.

Read More
A pastry crimper seals a pie edge through its fixed toothed shape beside unused decorative cutters

Dynamic ORDER BY Without Injection: Whitelisting Sort Columns

May 9, 2012
Pinal Dave
SQL Tips and Tricks
Dynamic SQL, SQL Order By, SQL Server Security, SQL Variable

Parameters cannot name a column, so grids end up gluing text into SQL. Here is the approved-list pattern that keeps the sort safe.

Read More
Previous 1 … 32 33 34 35 36 37 38 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

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