Sometimes I get emails from software vendors who use SQL Server as a part of their product. One of such vendor contacted me for an issue where their software install was failing because SQL Express was not getting installed. It was failing with an error. The error message which they shared was “Wait on the Database Engine recovery handle failed”.
SQL SERVER – Express and SQL Server Agent – Free Alternative
“How come my database is only a few MBs big and I am facing performance problems?” My customer asked. I replied, “Well, this is because you are not running job using SQL Server Agent to keep your indexes in the best health.”
SQL SERVER – Database Size Limitation in SQL Express
I have a tendency to write a number of interview style questions and those are quite popular in this blog. Having said that, sometimes we get asked about tricky questions on a small variety which we might know some of the basics – but sometimes it makes us think twice.…
Read MoreSQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.
Recently I had faced very interesting situation. Due to some reason we were not able to login into the production server for one of client. The reason for the same was that server was very busy, we had to login into the system and bring server to normal situation. When…
Read MoreSQLAuthority News – Download SQL Server 2008 Express Datasheet
Microsoft® SQL Server® 2008 Express is a free edition of SQL Server ideal for learning, developing and powering desktop and small server applications and for redistribution by ISVs. Download SQL Server 2008 Express Datasheet Abstract courtesy : Microsoft Reference: Pinal Dave (https://blog.sqlauthority.com)
Read More
SQL SERVER – Download FREE SQL SERVER Express Edition and Service Pack 1
Here is the quick link from where SQL Server 2008 Express Edition can be downloaded. Download SQL Server 2008 Express Edition You can download it with many additional details as described in following image. Click on above link to go to page and select desired version. Additionally, please install SQL…
Read MoreSQL SERVER – Choose Right Edition of SQL Server Express for Your Application
SQL Server Express is better alternative of MySQL. I have recently helped quite a few organizations to move to SQL Server Express recently. However, one question keep on coming up quite often regarding which is the right edition for SQL Server Express. SQL Server Express have more than one edition…
Read More