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 closed brass elevator doors in a calm lobby, with a single vermilion call button beside them and a potted plant

Elevator Etiquette: Small Rules for a Very Small Room

November 24, 2013
Pinal Dave
Personal
Best Practices, Career Advice, Personal Technology

Elevator etiquette comes down to a few small habits: let people off first, give others room, keep the talk light and stay calm when you miss a door. Here are the rules I follow on conference trips, in office towers and on the way to an interview.

Read More
A wooden seed cabinet in a shed with one drawer open, plain seed packets sorted in neat rows inside.

Keeping Your Own Script Library

October 27, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, SQL Documentation, SQL Scripts

A script library stays useful when folders, names, review history, and safe headers make each SQL file understandable before it runs.

Read More
A print shop bench with one original sheet and three identical fresh prints laid out beside it to dry.

What Is Replication in SQL Server?

October 16, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Backup and Restore, SQL Server

Replication in SQL Server copies chosen tables to other servers and keeps them current. Publisher, distributor and subscriber in plain words, the three kinds, and why replication is not high availability or a backup.

Read More
standup meeting

Developer – Best Practices for Daily Stand-Up or Daily Scrum – Rules and Regulations

September 20, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices

Scrum is an Agile Software Development framework that helps teams complete projects efficiently while maintaining high quality.

Read More
Plain metal counting tokens sit in separate shallow trays on a quiet wooden desk.

How to Check What SQL Server Licensing You Are Actually Using

September 8, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Check SQL Server licensing evidence with edition and CPU queries, then reconcile visible processors with host inventory and your agreement.

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
Two small wooden blocks are joined by one simple brass latch on an oak table.

Keeping ACID Across More Than One Server

August 8, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Understand a distributed transaction through two-phase commit, uncertain outcomes, coordinator recovery, and alternative business guarantees.

Read More
Previous 1 … 14 15 16 17 18 19 20 … 54 Next
  • Books
  • Testimonials
  • Privacy Policy

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