SQL Server 2005 Express Edition and the SQL Server Desktop Engine (MSDE) are both free and redistributable. Each product provides a medium where database administrators can work between MS Access and the full version of SQL Server. But there are key differences to consider.
2007-09-13
3,862 reads
This article demonstrates how you can use Surface Area Configuration utility in order to modify some of the security-related settings that have been applied during installation of SQL Server 2005 Express Edition.
2007-08-27
1,878 reads
An easy to use .NET solution for Job Scheduling, with pluggable actions, that runs on a Windows Service. Backup your SQL Server Express and much more!
2007-08-24
2,266 reads
Part 3 of this series describes the installation process of different versions of SQL Server 2005 Express Edition in more detail, including changes introduced in its Service Pack 2.
2007-08-08
1,991 reads
Express Edition remains the primary choice for deployments of a full-fledged database engine in less demanding environments. Part two of this series explores its features in more detail in order to better understand its unique role in SQL Server 2005 portfolio.
2007-07-24
2,562 reads
Marcin Policht offers an overview of choices offered in the SQL Server 2005 product line, as an introduction to a new series on the Express edition.
2007-07-09
3,077 reads
Most of the time, it's a permission error. Is your SQL Server service started using the Local System account or a windows user account? To use a network drive, it needs to be started using a windows user account, with the appropriate permissions granted to this account. To test if you have set it up correctly, use […]
2004-06-25
Using case statements won't work unless I can dynamically generate the number of case statements since the table width may vary.Ken- basically what i want to do is transpose row values to column values like a crosstab, but using the values not an aggregate value. So, for example, currently the values are stored as id/value […]
2004-06-22
CPU is a tough one. Profiler is a good start. Also, you might try checking to see if the app changed. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-18
2 reads
Geez. I got it wrong. However, I feel justified because I was in the majority -- misery loves company and all that. The date column threw me as I would never (say again NEVER 😉 would have created a clustered index on what I thought was a column that might change. Good question! Good debate! […]
2003-11-21
1 reads
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers