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
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
A hand sharpens a plane blade on a whetstone while the empty hand plane waits nearby.

System Configuration Checker WMI Error: Fixing SQL Server Setup

April 12, 2009
Pinal Dave
SQL Tips and Tricks
Bug Fix, SQL Server Installation, SQL Setup, WMI

Setup stopped with a WMI message before installing anything? Here are the safe repair steps, in order, with a quick check at the end.

Read More
A simple hourglass rests beside a closed plain notebook on a softly lit wooden desk.

Reading the SQL Server Support Lifecycle

April 8, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Read the SQL Server support lifecycle for your exact release, distinguish mainstream and extended support, and plan before coverage ends.

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

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