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
Express Size

SQL Express Size Limit for Data File

October 12, 2021
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Express

A client of mine. who is using SQL Server Express recently reached out to me to know SQL Express Size Limit for Data File?

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

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

October 31, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Express

A vendor’s installer failed because SQL Express would not install: Wait on the Database Engine recovery handle failed. Here is what the setup logs showed.

Read More
Task Scheduler tool window.

SQL SERVER – Express and SQL Server Agent – Free Alternative

March 29, 2017
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Agent, SQL Server Express

Small Express database, big performance problems? Here is a free alternative that fills the gap between SQL Server Express and SQL Server Agent jobs.

Read More
SQL SERVER - Database Size Limitation in SQL Express

SQL SERVER – Database Size Limitation in SQL Express

October 21, 2015
Pinal Dave
SQL Tips and Tricks
SQL Server Express

What is the database size limitation in SQL Express? A Q&A style post covering the size limit for each version, from SQL 2000 Desktop Engine onwards.

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

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