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 closed walnut chest with a plain rectangular wooden bar and a short vermillion cord on the table.

Random Tokens in SQL Server: Generation, Storage and Expiry Checks

August 11, 2010
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Server, SQL Server Encryption, SQL Server Security

Random tokens in SQL Server need more than a generated value. Their stored state must define expiry, revocation and whether consumption already occurred. A guarded disposable fixture makes the boundary conditions explicit.

Read More
A hand pressing a signet ring into red sealing wax on a folded parcel, a candle and wax stick beside it

Connecting Java Applications With the JDBC Driver

March 13, 2010
Pinal Dave
SQL Tips and Tricks
Java, SQL Connection, SQL Server, SQL Server Encryption

Choose a current JDBC driver for SQL Server, verify its connection URL and encryption settings, and test integrated authentication on the app host.

Read More
Two rings of keys hang inside a cupboard door, one bright and new, the other old, tarnished and tied with string.

Rotating the TDE Certificate

October 3, 2009
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Server Encryption, SQL Server Security

Rotating the TDE certificate protects recovery only when the new private key is backed up and old backups still restore.

Read More
SQL SERVER - Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script

SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script

April 28, 2009
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Security

SQL Server Encryption keeps stolen data unreadable. Learn the three level encryption hierarchy, then follow a symmetric key encryption tutorial with the script.

Read More
Two tin-can telephones joined by a taut string across a garden fence, one held by a hand

What TDS Is and Why It Matters to You

January 17, 2009
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Connection, SQL Server, SQL Server Encryption

What TDS is becomes practical when a SQL Server connection fails: it carries login and query traffic, packet settings, and encryption negotiation.

Read More
A locked tin box is handed across a shop counter while the owner's other hand keeps its only key.

Always Encrypted in Plain Words

January 10, 2009
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server 2016, SQL Server Encryption, SQL Server Security

Explain Always Encrypted in plain words, including client-held keys, deterministic and randomized encryption, query limits, and operations.

Read More
A covered serving dish passes through a small kitchen hatch toward a hand reaching from a dark room.

Encrypting Connections to SQL Server

November 3, 2008
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Server, SQL Server Configuration, SQL Server Encryption, SQL Server Security

Encrypting connections to SQL Server requires a trusted certificate, careful Force Encryption rollout, and tests with real drivers.

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

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