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 museum display case with an untouched porcelain teacup inside and a clear set of fingerprints on the glass.

Auditing SELECT Statements on Sensitive Tables

October 18, 2009
Pinal Dave
SQL Tips and Tricks
DBA, SQL Audit, SQL Compliance, SQL Server Security

Auditing SELECT statements on sensitive tables needs a narrow database audit, protected files, volume checks, and active review.

Read More
A child's hand fitting a star-shaped block into the matching hole of a wooden shape-sorter box

Connecting PHP to SQL Server

October 11, 2009
Pinal Dave
SQL Tips and Tricks
Developer, SQL Connection, SQL Server, SQL Server Security

Connecting PHP to SQL Server means choosing SQLSRV or PDO_SQLSRV, binding parameters, validating TLS, and keeping web queries efficient.

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
A single book waiting on a library counter, with tall shelves behind a latched brass gate

Giving Web Developers Safe Database Access

September 28, 2009
Pinal Dave
SQL Tips and Tricks
Developer, SQL Login, SQL Server, SQL Server Security, SQL View

Give web developers safe database access with narrow roles and views, a reporting replica where useful, and audit that identifies real changes.

Read More
SQL SERVER - Cryptography in SQL Server 2008

SQL SERVER – Cryptography in SQL Server 2008

September 15, 2009
Pinal Dave
SQL Tips and Tricks
SQL Server Security

A brief look at cryptography in SQL Server 2005 and 2008: why encryption belongs at the engine level, its effect on performance, and authentication basics.

Read More
A crowded toothbrush cup on a bathroom shelf, most brushes old and dusty, one red brush still in use.

Finding Unused Logins and Users Before an Audit

September 11, 2009
Pinal Dave
SQL Tips and Tricks
DBA, SQL Audit, SQL Login, SQL Server Security

Review unused logins with password metadata, database mappings and activity capture, then use an owner approved disable-first plan.

Read More
Network Service permissions.

SQL SERVER – FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.

August 20, 2009
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server Security

Getting Cannot open database requested by the login for NT AUTHORITY\NETWORK SERVICE? Map that login to your database under User Mapping.

Read More
Previous 1 … 37 38 39 40 41 42 43 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

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