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
SQL SERVER - New features in SQL Server 2016 Setup Wizard

SQL SERVER – New features in SQL Server 2016 Setup Wizard

November 23, 2015
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server 2016, SQL Server Installation, SQL TempDB

Microsoft listened to feedback, and the SQL Server 2016 Setup Wizard shows it. Here are the new options I noticed, such as Perform Volume Maintenance Task.

Read More
SQL SERVER - Installation Failed With Error - Wait on the Database Engine Recovery Handle Failed

SQL SERVER – Installation Failed With Error – Wait on the Database Engine Recovery Handle Failed

November 14, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Installation

I ran SQL Server setup on a domain controller by mistake, and the Installation Failed at ‘Wait on the Database Engine recovery handle’. Here is what fixed it.

Read More
Four toolboxes of increasing size in a row on a workshop floor, lids open, each one holding more tools than the last.

Which SQL Server Edition Do You Need?

May 4, 2014
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Download, SQL Server, SQL Server Installation

Which SQL Server edition do you need? Express, Developer, Standard and Enterprise compared in plain terms, plus the licensing trap where a free Developer Edition quietly ends up running the business.

Read More
Small interlocking wooden blocks form a practice structure beside loose pieces on a desk.

Building a SQL Server Home Lab That Costs Nothing

April 20, 2014
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Build a SQL Server home lab with free Developer software, sample data, and a repeatable backup and restore routine on your Windows computer.

Read More
A bare evergreen tree beside an open box of saved ornaments, a red bauble on top.

Rebuilding System Databases With Setup When master Is Lost

November 2, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Server Installation, System Database

Plan rebuilding system databases with Setup when master has no usable backup, then restore logins, jobs, and configuration.

Read More
An open cottage door painted green outside, still red on the inside.

Renaming the Windows Server Under SQL Server: Fixing @@SERVERNAME

September 14, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SQL Server Configuration, SQL Server Installation, Windows

After renaming the Windows server, repair SQL Server’s local name with sp_dropserver and sp_addserver, then verify dependent services.

Read More
Plain metal counting tokens sit in separate shallow trays on a quiet wooden desk.

How to Check What SQL Server Licensing You Are Actually Using

September 8, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Check SQL Server licensing evidence with edition and CPU queries, then reconcile visible processors with host inventory and your agreement.

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

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