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 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
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 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
Two small wooden storage boxes of different sizes stand together on a quiet workbench.

SQL Server Express Limits: What the 10 GB Cap Really Means

December 23, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Check SQL Server Express limits by version, separate data files from logs, and identify the memory, CPU, and scheduling limits that affect you.

Read More
A small wooden bridge model and a separate wooden block rest on a quiet workbench.

What Breaks When You Upgrade, and How to Find It First

December 18, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Prepare for a SQL Server upgrade by checking deprecated features, compatibility, collation, plans, and application behavior before moving.

Read More
SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial

SQL SERVER – 2008 – Install SQL Server 2008 – How to Upgrade to SQL Server 2008 – Installation Tutorial

December 2, 2008
Pinal Dave
SQL Tips and Tricks
Database, SQL Server, SQL Server Installation

Install SQL Server 2008 RTM step by step, with images for every screen. Most of the steps still apply to newer versions, so the guide is still useful.

Read More
SQL SERVER - 2008 - Step By Step Installation Guide With Images

SQL SERVER – 2008 – Step By Step Installation Guide With Images

June 12, 2008
Pinal Dave
SQL Tips and Tricks
Database, SQL Server, SQL Server Installation

A step by step SQL Server 2008 RC0 Installation guide with images for every screen, written because so many readers asked me how to install it.

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

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