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
Two hands moving a young tomato plant with its roots intact from a small pot into a prepared garden bed

Moving From LocalDB to a Real Instance

September 15, 2012
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Collation, SQL Migration, SQL Server, SQL Server Express

Moving from LocalDB to a server instance takes a tested backup and restore, new connection strings, mapped logins, and a collation check.

Read More
SQL Server SQL Server Express Edition startup parameters.

SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.

October 23, 2011
Pinal Dave
SQL Interview Questions and Answers
SQL Error Messages, SQL Server Express

Connecting to SQL Server Express failed while obtaining the dedicated administrator connection (DAC) port. Here is why it happens and how to fix it.

Read More
A small camping stove with one simmering pot on a picnic table in a quiet clearing at dusk

LocalDB: SQL Server on a Developer’s Laptop

March 12, 2011
Pinal Dave
SQL Tips and Tricks
Developer, SQL Server, SQL Server Express, sqlcmd

LocalDB runs SQL Server Express engine features in a developer-friendly local process; learn how to start, connect, and recognize its limits.

Read More
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
Previous 1 2 3 Next
  • Books
  • Testimonials
  • Privacy Policy

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