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 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
A hand placing the last red pencil into a tin of pencils sorted by color

Choosing the Server Collation at Install Time

February 9, 2009
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Server, SQL Server Installation, SQL TempDB

Choose the server collation before installation by checking application comparisons, tempdb behavior, and the cost of changing an instance later.

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
Floured hands fold dried fruit into bread dough on a wooden board, with a warm oven waiting behind.

Slipstreaming Updates Into a New Install

October 29, 2008
Pinal Dave
SQL Tips and Tricks
Cumulative Update, SQL Patch, SQL Server, SQL Server Installation, SQL Setup

Slipstreaming Updates lets SQL Server Setup apply a selected CU during installation with UpdateSource and avoids a separate patch pass.

Read More
An old enamel teapot heating on a small camping stove in a meadow at dawn, steam starting to rise.

Installing SQL Server on Linux

February 21, 2008
Pinal Dave
SQL Tips and Tricks
Linux, SQL Server, SQL Server Installation, SQL Setup

Installing SQL Server on Linux involves supported packages, mssql-conf setup, service checks, and an understanding of Windows differences.

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

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