A client of mine. who is using SQL Server Express recently reached out to me to know SQL Express Size Limit for Data File?
SQL SERVER – SQL Express Installation Error – Wait on the Database Engine Recovery Handle Failed
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.
SQL SERVER – Express and SQL Server Agent – Free Alternative
Small Express database, big performance problems? Here is a free alternative that fills the gap between SQL Server Express and SQL Server Agent jobs.
SQL SERVER – Database Size Limitation in SQL 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.
Moving From LocalDB to a Real Instance
Moving from LocalDB to a server instance takes a tested backup and restore, new connection strings, mapped logins, and a collation check.
SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.
Connecting to SQL Server Express failed while obtaining the dedicated administrator connection (DAC) port. Here is why it happens and how to fix it.
LocalDB: SQL Server on a Developer’s Laptop
LocalDB runs SQL Server Express engine features in a developer-friendly local process; learn how to start, connect, and recognize its limits.