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
Search of TRL

SQL SERVER – ​Building Technical Reference Library – Notes from the Field #048

October 2, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server Security

Brian Kelley explains how to build a technical reference library: your own notes, code, settings and bugs you have hit, so help is always close at hand.

Read More
SQL SERVER - A Practical Use of Backup Encryption

SQL SERVER – A Practical Use of Backup Encryption

October 1, 2014
Pinal Dave
SQL Tips and Tricks
Devart, SQL Backup and Restore, SQL Server Security

A backup in the wrong hands is a data leak waiting to happen. Here is a practical example of Backup Encryption in SQL Server 2014 to keep your backups safe.

Read More
Interchangeable cloth luggage handle wraps over different solid handle attachments

Reading Connection Details in Code: APP_NAME, HOST_NAME and Logins

September 21, 2014
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Login, SQL Server Security

An audit row blamed the wrong machine because a label was treated as proof. Here is which connection values you can trust, and which you cannot.

Read More
Object Created.

SQL SERVER – ​Finding Out What Changed in a Deleted Database – Notes from the Field #041

August 13, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server Security

What changed in a database that no longer exists? Brian Kelley shares a real story on finding out what changed in a deleted database.

Read More
A herd of goats on a hillside following one old lead goat wearing the only bell toward a gate

Finding Databases Owned by Personal Logins and Fixing Them

August 12, 2014
Pinal Dave
SQL Tips and Tricks
DBA, SQL Login, SQL Server, SQL Server Security

Find databases owned by personal logins, review an approved replacement owner, and test dbo mapping and execution-context effects.

Read More
Dovecote entrances with a fitted collar narrowing one opening

Block Predicates: Stopping Writes Into Another Tenant’s Rows

August 3, 2014
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Server Security, SQL Transactions

A filter predicate hides rows but does not stop a bad write. Here is how block predicates close that gap, with a demo you can run.

Read More
Gouache painting of a garden gate with a large key and a porch of three doors, one with a small red key

Login vs User in SQL Server: Who Gets In, Who Can Do What

July 16, 2014
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server Security

Login vs user is a question of authentication and authorization in SQL Server. A login lets you into the instance, and a user gives you rights inside one database. This post builds both on a demo database, shows the errors that appear when one is missing, and explains how they map.

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

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