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
Herbs growing in reused tin cans and jars on a sunny windowsill, with a spoon used as a trowel beside them.

Learning SQL Server on a Budget

January 10, 2011
Pinal Dave
SQL Tips and Tricks
SQL Sample Database, SQL Server, SQL Server Express, SQL Training, Starting SQL

Learning SQL Server on a budget is possible with free development editions, official documentation, samples, and community practice.

Read More
Three dumbbells on a rack, the smallest newly fitted with extra plates held by a red collar

SQL Server 2025 Editions: What Express and Standard Can Do Now

June 13, 2010
Pinal Dave
SQL Tips and Tricks
SQL Licensing, SQL Server, SQL Server Express, SQL Server Installation

Compare SQL Server 2025 editions, inspect Express and Standard limits, identify the installed edition, and review database portability.

Read More
A hand winding a mantel clock with a brass key

Backing Up SQL Server Express Without Agent

February 13, 2010
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Server Express, sqlcmd

Backing up SQL Server Express requires a BACKUP script, sqlcmd, Windows Task Scheduler, retention rules, and proof that restores work.

Read More
Microsoft SQL Server Express.

SQL SERVER – SQL Server Express – A Complete Reference Guide

August 26, 2009
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Express

A complete reference guide to SQL Server Express: what it costs (it is free), when to use it over the full version, and its maximum database size.

Read More
A narrow footbridge with one walker crossing and two waiting on the bank, a wider stone bridge further downstream

SQLite or SQL Server Express for a Small App

November 25, 2007
Pinal Dave
SQL Tips and Tricks
Developer, SQL Backup and Restore, SQL Server, SQL Server Express

SQLite or SQL Server Express depends on write concurrency, deployment, backup, and the growth path your small application really needs.

Read More
Previous 1 2
  • Books
  • Testimonials
  • Privacy Policy

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