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
logon

SQL SERVER – Logon Trigger Feature for Managing Data Access

March 2, 2012
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Server

This blog post is about SafePeak “Logon Trigger” Feature for Managing Data Access. Just a quick update the product is no longer available.

Read More
Hens filing up a ramp into a wooden coop at dusk while one small red hen wanders alone in the yard.

Counting Users, Roles and Orphans in Every Database

December 25, 2011
Pinal Dave
SQL Tips and Tricks
DBA, Schema, SQL Cursor, SQL Login, SQL Server Security

Audit counting users across databases, include roles and schema ownership, and distinguish orphaned SQL users from contained identities.

Read More
A houseboat leaving its canal mooring with potted herbs, a bicycle and its red front door all aboard.

Contained Database Users: Logins That Move With the Database

September 9, 2010
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Login, SQL Password, SQL Server, SQL Server Security

Use contained database users to move authentication with a database, inspect prerequisites, test connections, and review access ownership.

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
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
A nest of small speckled eggs with one larger red egg that does not belong

Hunting Suspicious Objects After a SQL Server Compromise

June 24, 2009
Pinal Dave
SQL Tips and Tricks
DBA, SQL Audit, SQL Login, SQL Server Security

Investigate a SQL Server compromise by preserving evidence and checking logins, startup procedures, Agent jobs, risky features, and changed objects.

Read More
Previous 1 … 7 8 9 10 11 12 Next
  • Books
  • Testimonials
  • Privacy Policy

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