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 shop window beside a community board full of blank pinned notes, with one vermilion pin.

Blog vs Website: Which One Do You Actually Need?

May 20, 2013
Pinal Dave
Personal
Best Practices, Blogging, Professional Development

The blog vs website question comes down to how much your words change. This post explains who needs which, how to combine them on one address, what a blog costs in time, and why original writing still matters when AI tools answer questions.

Read More
Stepping stones crossing a stream, one missing near the far bank leaving a gap too wide to step across.

Backup Retention: How Long to Keep What

May 6, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, SQL Backup and Restore, Transaction Log

Backup retention should preserve restore chains while meeting recovery, legal, and storage needs across full, differential, and log backups.

Read More
A cutaway architectural model on a table showing identical rooms stacked on four floors inside one building.

SQL Server on a Virtual Machine: What Actually Changes

April 19, 2013
Pinal Dave
SQL Performance
Best Practices, SQL Performance, SQL Server, Virtualization

SQL Server on a virtual machine cannot see the host it is sharing. Why more virtual processors can be slower, what memory reservation buys you, why snapshots are not backups, and the four things I check first.

Read More
Two delivery trolleys stopped nose to nose in a narrow corridor, neither able to pass

What Is a Deadlock in SQL Server?

April 4, 2013
Pinal Dave
SQL Performance
Best Practices, Database, SQL Performance, SQL Server

A deadlock in SQL Server is two sessions each holding what the other needs. I caused one on purpose and read error 1205. Why it is not the same as blocking, who gets killed, and the boring fix that works.

Read More
A half-built brick wall with even mortar joints, a taut string line along the top and a trowel on the last brick.

Formatting T-SQL Consistently Across a Team

February 14, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Software Development, SQL Coding Standards, SQL Server

Formatting T-SQL consistently means choosing a few readable rules, using a formatter carefully, and keeping historical changes focused.

Read More
Gouache painting of a jumbled heap of pencils beside a neat row with a red pencil sharpener between them

Autocomplete and Code Formatting in SSMS: What Works Today

January 30, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Coding Standards, SQL Server Management Studio, SQL Shortcut

Autocomplete and code formatting save time and prevent mistakes when they are set up well. This post covers the IntelliSense features in SSMS, the reasons they stop working, a simple formatting style, and a tested look at what formatting changes in the plan cache.

Read More
A single brick building with four separate front doors in a row along the pavement, each with its own doormat and letter slot.

SQL Server Instance or Database: What Is the Difference?

January 27, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

A SQL Server instance is the engine and a database is one set of data inside it. What each level owns, why a login and a user are different objects, and which line to draw when you separate customers or teams.

Read More
Previous 1 … 17 18 19 20 21 22 23 … 54 Next
  • Books
  • Testimonials
  • Privacy Policy

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