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
Gouache painting of a tidy archive room with rows of plain wooden drawers, a brass key ring hanging on a hook and a magnifying glass resting on an open ledger with blank pages, one drawer handle painted vermilion.

Data Governance: Catalog, Lineage and Data Quality

January 14, 2014
Pinal Dave
SQL Tips and Tricks
Data Observability, Database, Duplicate Records, SQL NULL, SQL Server Security

Data Governance is how you know what data you have, where it came from, who can see it and whether it is right. This post covers the catalog, lineage, access and data quality, with T-SQL checks you can run.

Read More
A cake lifter removes one cake layer while neighboring layers remain untouched

TRUNCATE Permission: Letting a User Empty One Table

January 13, 2014
Pinal Dave
SQL Tips and Tricks
SQL Server Security, SQL Stored Procedure, SQL Table Operation

Your loader needs to empty a staging table, not redesign it. Here is a small procedure that gives it exactly that.

Read More
Auditing SQL Login (GUI)

SQL SERVER – Auditors, Passwords and Exceptions – Notes from the Field #010

January 9, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore, SQL Server Security

Weak passwords are like a key under the door mat. Brian Kelley explains what auditors look for around passwords and exceptions in database security.

Read More
Gouache painting of a person reviewing a database access checklist with a magnifying glass

Permissions I Have in SQL Server: Check Database, Server and Object Access

December 22, 2013
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

The permissions I have in SQL Server depend on my database and security context. These read-only queries, tested with a loginless user, a role and a column DENY, separate database, server and object checks and show which grant supplied each permission.

Read More
One hand passing a small red-handled peeler to another, while a full knife block stays untouched behind.

Granular Server Roles: ##MS_ServerStateReader## and Friends

September 23, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SQL DMV, SQL Login, SQL Server 2022, SQL Server Security

Assign granular server roles in SQL Server 2022, inspect membership, and give monitoring accounts the state access their queries need.

Read More
A torch beam lighting fine scratches around a brass keyhole on a front door at night, a key on the mat

Auditing Failed Logins With the Error Log and Extended Events

September 15, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SQL Audit, SQL Extended Events, SQL Login, SQL Server Security

Investigate failed logins with the SQL Server error log and a focused Extended Events session, then group attempts and decide what to do.

Read More
The back door of a small bakery with an oiled deadbolt, a fire blanket, a spare key on a hook and a broom.

Database Security Basics for a Small Business

September 2, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, SQL Backup and Restore, SQL Server Security

Database security basics for a small business cover patching, off-site backups, strong logins, limited access, and encryption that works.

Read More
Previous 1 … 29 30 31 32 33 34 35 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

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