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 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
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
A brass identification plate riveted to a machine housing, its stamped surface worn smooth and blank, lit by a torch beam from one side.

How to Check Your SQL Server Version, Edition and Patch Level

December 19, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Check your SQL Server version, edition and patch level with one query. How to read the build number, why ProductLevel still says RTM on a patched server, and the edition surprise a health check finds most often.

Read More
Several plain cardboard boxes nest inside each other on a softly lit wooden tabletop.

What a Cumulative Update Actually Contains

September 30, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Understand a SQL Server cumulative update, identify your build and servicing branch, and read fixes and known issues before planning a patch.

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

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