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
A brass identification plate riveted to a machine housing, its stamped surface worn smooth and blank, lit by a torch beam from one side.

How to Check Your SQL Server Version, Edition and Patch Level

December 19, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Check your SQL Server version, edition and patch level with one query. How to read the build number, why ProductLevel still says RTM on a patched server, and the edition surprise a health check finds most often.

Read More
Several plain cardboard boxes nest inside each other on a softly lit wooden tabletop.

What a Cumulative Update Actually Contains

September 30, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Understand a SQL Server cumulative update, identify your build and servicing branch, and read fixes and known issues before planning a patch.

Read More
Three dumbbells on a rack, the smallest newly fitted with extra plates held by a red collar

SQL Server 2025 Editions: What Express and Standard Can Do Now

June 13, 2010
Pinal Dave
SQL Tips and Tricks
SQL Licensing, SQL Server, SQL Server Express, SQL Server Installation

Compare SQL Server 2025 editions, inspect Express and Standard limits, identify the installed edition, and review database portability.

Read More
A pottery kiln working on its own in an empty studio at night

Installing SQL Server Silently From the Command Line

April 25, 2010
Pinal Dave
SQL Tips and Tricks
Command Line, DBA, PowerShell, SQL Server Installation, SQL Setup

Installing SQL Server silently takes a reviewed ConfigurationFile.ini, required setup switches, and a check of logs and active instance settings.

Read More
A compact canvas tool roll holds several tools beside an empty fitted pocket.

Which Features You Lose When You Drop an Edition

December 27, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Review SQL Server edition features before moving down an edition, check persisted dependencies, and test maintenance and availability behavior.

Read More
Gloved hands lifting a honeycomb frame from a stacked wooden beehive in a meadow, smoke drifting nearby

What Is Installed? Finding Every SQL Server Component

November 28, 2009
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Server, SQL Server Installation, SQL Server Services

Finding every SQL Server component starts with the Setup discovery report, then checks services, engine versions, and separate client tools.

Read More
A small ladder stands beside a stable wooden platform in a quiet empty workshop.

How to Patch SQL Server Without a Bad Morning

July 25, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Before you patch SQL Server, check backups, plan replica and cluster sequencing, record builds, and prepare a tested recovery path.

Read More
Previous 1 … 7 8 9 10 11 12 Next
  • Books
  • Testimonials
  • Privacy Policy

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