http://www.sqlservercentral.com/Content tagged SQL Server 2005 Express posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)This article is a brief overview of Service Broker's core features, which are available (in a somewhat limited capacity) in SQL Server 2005 Express Edition. The next installment will describe a sample application illustrating its operations and discuss its management, security, and routing characteristics.http://www.sqlservercentral.com/redirect/articles/63697/2008/07/17http://www.sqlservercentral.com/redirect/articles/63697/In the previous installment of our series, we presented a variety of reasons that might influence your decision to upgrade a full-fledged member of the SQL Server 2005 family. This article discusses the actual implementation of this process, pointing out additional factors that might affect its complexity.http://www.sqlservercentral.com/redirect/articles/63524/2008/07/07http://www.sqlservercentral.com/redirect/articles/63524/Recent installments of this series have demonstrated SQL Server 2005 Express Edition's replication characteristics by taking advantage of replication-specific executables and T-SQL code combined with Windows Synchronization Manager and Web Synchronization technologies. This article explores another method of reaching the same goal, which involves Replication Management Objects (RMO).http://www.sqlservercentral.com/redirect/articles/62901/2008/04/30http://www.sqlservercentral.com/redirect/articles/62901/http://www.sqlservercentral.com/questions/SQL+Server+2005+Express/62651/2008/04/24http://www.sqlservercentral.com/questions/SQL+Server+2005+Express/62651/We have been discussing SQL Server 2005 Express Edition replication-specific features, investigating authentication mechanisms that are available in order to accommodate connection attempts from remote clients interacting with SQL Server-based distributor via Internet Information Services. We will continue coverage of this topic here.http://www.sqlservercentral.com/redirect/articles/62834/2008/04/21http://www.sqlservercentral.com/redirect/articles/62834/Part 18 of this series explores several scenarios in which the Merge Web Synchronization can be applied and describes their implementation details.http://www.sqlservercentral.com/redirect/articles/62544/2008/03/20http://www.sqlservercentral.com/redirect/articles/62544/ In this article, we will explore another variation of this mechanism, called Web Synchronization, with SQL Server 2005 Express Edition instances operating as merge replication subscribers connecting to a publisher via HTTPS protocol.http://www.sqlservercentral.com/redirect/articles/62543/2008/03/17http://www.sqlservercentral.com/redirect/articles/62543/Marcin Policht provides a step-through sample implementation of transactional and merge replication.http://www.sqlservercentral.com/redirect/articles/62295/2008/03/04http://www.sqlservercentral.com/redirect/articles/62295/SQL Server 2005 Express Edition's small footprint and free-of-charge use has some negative implications, imposing restrictions on functionality available in the Standard or Enterprise editions. This is especially conspicuous in the case of replication, which we will explore starting with this installment.http://www.sqlservercentral.com/redirect/articles/61920/2008/01/16http://www.sqlservercentral.com/redirect/articles/61920/Part 11 of this series presented the publishing options of ClickOnce-capable applications that involve User Instance-based databases. This article takes a closer look at the deployment process, demonstrating the impact of your selections on its characteristics.http://www.sqlservercentral.com/redirect/articles/61725/2007/12/21http://www.sqlservercentral.com/redirect/articles/61725/Part 11 of the series focuses on the process of deploying and maintaining user instance-based applications that employ ClickOnce technology.http://www.sqlservercentral.com/redirect/articles/61555/2007/11/23http://www.sqlservercentral.com/redirect/articles/61555/SQL Server 2005 Express Edition's unique functionality allows you to distribute and implement single-user databases, without the dependency of having administrative privileges or the need for a cumbersome configuration. This article illustrates the practical use of this feature, known as XCopy deployment.http://www.sqlservercentral.com/redirect/articles/61377/2007/10/30http://www.sqlservercentral.com/redirect/articles/61377/Part 8 of our series provides an overview of User Instance model (also known as “Run As Normal User” or simply RANU) and automatic database connectivity, which serve as two primary enablers for XCopy deployment, facilitating distribution of single-user databases.http://www.sqlservercentral.com/redirect/articles/61379/2007/10/25http://www.sqlservercentral.com/redirect/articles/61379/In our new article, we will continue coverage of this topic by describing other activities that alter default connectivity settings applied during standard installation, focusing in particular on encryption.http://www.sqlservercentral.com/redirect/articles/61188/2007/10/18http://www.sqlservercentral.com/redirect/articles/61188/In this article, we will continue exploring other post-setup tasks, focusing on network specific tasks.http://www.sqlservercentral.com/redirect/articles/61187/2007/10/10http://www.sqlservercentral.com/redirect/articles/61187/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. http://www.sqlservercentral.com/redirect/articles/3230/2007/09/13http://www.sqlservercentral.com/redirect/articles/3230/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.http://www.sqlservercentral.com/redirect/articles/3183/2007/08/27http://www.sqlservercentral.com/redirect/articles/3183/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!http://www.sqlservercentral.com/redirect/articles/3172/2007/08/24http://www.sqlservercentral.com/redirect/articles/3172/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. http://www.sqlservercentral.com/redirect/articles/3129/2007/08/08http://www.sqlservercentral.com/redirect/articles/3129/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.http://www.sqlservercentral.com/redirect/articles/3109/2007/07/24http://www.sqlservercentral.com/redirect/articles/3109/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.http://www.sqlservercentral.com/redirect/articles/3067/2007/07/09http://www.sqlservercentral.com/redirect/articles/3067/