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
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
Maximum Rollover Files Dialog Box.

SQL SERVER – 2012 Auditing Enhancement – On Audit Log Failure Options – Maximum Rollover Files

December 16, 2011
Pinal Dave
SQL Tips and Tricks
SQL Server Security

SQL Server 2012 adds two auditing enhancements: new options on audit log failure, like fail operation or continue, and a maximum rollover files setting.

Read More
A closed egg coddler with a lifting ring beside an opened matching vessel

Certificate-Signed Procedures That Read Server DMVs Safely

October 13, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

Give a developer lock-wait data without handing over a server-wide permission. A signed procedure carries the authority, and an edit takes it away.

Read More
A cord passes through one reinforced brass opening in an intact canvas panel

EXECUTE AS OWNER in Stored Procedures: Power and Pitfalls

August 29, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

A procedure with owner rights can write to tables its caller cannot touch. Watch the identity change, and see how one careless parameter hands out too much.

Read More
Separated brush parts with a spare metal ferrule protected in a small tin

Backing Up the Service Master Key and Database Master Keys

August 25, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

A database backup does not carry the key that opens your encrypted data. Export both keys, restore one from its file, and see why the password matters.

Read More
SQL SERVER - Interview Questions and Answers - Guest Post by Rick Morelan - Day 27 of 31

SQL SERVER – Interview Questions and Answers – Guest Post by Rick Morelan – Day 27 of 31

July 27, 2011
Pinal Dave
SQL Interview Questions and Answers
SQL Order By, SQL Scripts, SQL Server, SQL Server Security

A guest post by Rick Morelan, author of the Joes 2 Pros series, on the few interview questions that come up again and again and separate good answers from great.

Read More
A hand opens one small wooden drawer of seeds in a wall of closed, unmarked drawers in an old shop.

Row-Level Security for Reports

May 22, 2011
Pinal Dave
SQL Tips and Tricks
SQL Reports, SQL Server, SQL Server 2016, SQL Server Security

Use SQL Server row-level security for reports with predicate functions and SESSION_CONTEXT, and test every identity boundary.

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

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