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
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
A practice football goal on a training pitch matching the stadium goal behind it, a red corner flag between

Standard Developer vs Enterprise Developer Edition in SQL Server 2025

August 27, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SQL Licensing, SQL Server, SQL Server Installation

Choose Standard Developer or Enterprise Developer in SQL Server 2025, inspect the edition, and test against production features.

Read More
A single brick building with four separate front doors in a row along the pavement, each with its own doormat and letter slot.

SQL Server Instance or Database: What Is the Difference?

January 27, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

A SQL Server instance is the engine and a database is one set of data inside it. What each level owns, why a login and a user are different objects, and which line to draw when you separate customers or teams.

Read More
Gouache painting of a tree stump with growth rings and one red pin in the center ring

Find SQL Server Installation Date and Time with T-SQL

July 5, 2012
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server Installation

The SQL Server Installation Date is the create date of the NT AUTHORITY\SYSTEM login, and one short query reads it. This post compares that clue with other dates that look right but aren’t, shows how to work out an Evaluation expiry date, and lists the cases where the clue is wrong.

Read More
Gouache painting of a miniature village assembled beside its compartmented storage chest and rolled plan.

Installing AdventureWorks Sample Database: SQL in Sixty Seconds #010

April 11, 2012
Pinal Dave
SQL Video
SQL Backup and Restore, SQL in Sixty Seconds, SQL Sample Database, SQL Server Installation

Installing AdventureWorks is one RESTORE statement, and a few checks before and after it prevent the common failures. The tests here read a backup header and file list, restore under a new name with MOVE, and confirm the result on SQL Server 2025.

Read More
A plain removable wooden tray fits inside a larger open storage box on a table.

Running SQL Server in a Container for Testing

September 24, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Create a SQL Server container for testing from Windows PowerShell, keep data in a named volume, and separate disposable runtime from backups.

Read More
Two identical mittens knitted from the same pattern, one still on the needles

Building a Test Server From a Script

June 5, 2011
Pinal Dave
SQL Tips and Tricks
DBA, PowerShell, SQL Server Installation, Testing

Build a test server from a script with unattended SQL Server setup, repeatable configuration, and sample data that can be reset after each run.

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

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