Marcin Policht

In the recent installments of our series covering features available in SQL Server 2005 Express Edition, we have been discussing functionality incorporated into asynchronous messaging framework of Service Broker. So far, we have examined its basic characteristics and presented initial steps of a sample implementation intended to demonstrate a message-based communication, which involved creation of […]

In the most recent installments of our series covering functionality included in the SQL Server 2005 Express Edition, we have started an overview of Service Broker – asynchronous communication framework incorporated into the database engine. So far, we have presented its basic concepts and features, as well as stepped through creation of database objects required […]

In the previous installment of our series dedicated to features available in the SQL Server 2005 Express Edition, we have presented basic concepts of the Service Broker by defining the primary elements of its asynchronous messaging framework built directly into the product. Now it is time to explain their interaction and describe a process of […]

One of the more interesting innovations incorporated into the SQL Server 2005 platform is Service Broker. Designed as a scalable, secure, asynchronous messaging framework, it provides infrastructure for implementing reliable data exchange, which can be easily leveraged by local and distributed database applications. Since its core features are available in the entire product line (including […]

SQL Server 2005 Express Edition – Part 25 In the previous installment of our series dedicated to SQL Server 2005 Express Edition, we presented a variety of reasons that might influence your decision to upgrade to one of the full-fledged members of the SQL Server 2005 family (Workgroup, Standard, or Enterprise). In this article, we […]

In the first installment of our series, we briefly described the main characteristics of the individual products in the SQL Server 2005 product line. As we have demonstrated since that introduction, unique features incorporated into the Express Edition (such as User Instances or ClickOnce Deployment) make it a preferred choice when deploying single-user databases embedded […]

In the previous installment of our series dedicated to topics related to SQL Server 2005 Express Edition, we have started discussion about migrating from MSDE-based installations. As we have explained, in many cases, this process can be performed by running an in-place upgrade of individual instances (either via GUI-based setup wizard or in unattended manner). […]

In the initial articles of our series dealing with topics related to SQL Server 2005 Express Edition, we have described its setup procedure and subsequent configuration tasks, presenting them (for simplicities sake) in the context of new installations. However, most of us operate in less fortunate circumstances, forcing us to deal with legacy environments and […]

In the most recent installments of our series covering new and improved features incorporated into SQL Server 2005 Express Edition, we have been discussing its replication characteristics. As we have pointed out, while there are some significant limitations in this area (when compared with its predecessor – SQL Server 2000 MSDE – as well as […]

Throughout the most recent installments of our series dedicated to SQL Server 2005 Express Edition, we have been discussing its replication-specific features, focusing in particular on its role in Merge Web Synchronization implementations. As we have demonstrated so far, despite several shortcomings in this area (such as its agentless nature or inability to take on […]

In the most recent installments of our series dealing with SQL Server 2005 Express Edition-related topics, we have provided an overview of Web Synchronization, which facilitates efficient and inexpensive implementations of merge replication with remote subscribers, separated from their publishers via (potentially insecure and unreliable) TCP/IP networks (such as the Internet). So far, we have […]

In the previous installment of our series presenting an overview of SQL Server 2005 Express Edition characteristics, we have described a scenario that can be used to utilize its limited replication capabilities. The underlying concept, called Web Synchronization, facilitates merge replication, in which remote subscribers exchange data with a publisher via HTTPS protocol (allowing implementations […]