Marcin Policht

As part of our series dedicated to SQL Server 2005 Express Edition, we recently have focused on its replication characteristics. As we have explained, its limitations in this area (such as agentless nature or inability to function in a role other than the subscriber) necessitated development of new mechanisms facilitating its participation in snapshot, transactional, […]

In the recent installments of our series dedicated to SQL Server 2005 Express Edition, we started exploring its replication characteristics. As we have pointed out, its capabilities in this area are fairly restricted, limiting it exclusively to the role of a subscriber. Absence of SQL Server Agent has further impact on the range of available […]

In the previous installment of our series dedicated to SQL Server 2005 Express Edition, we started exploring its replication characteristics. As we pointed out, this was one of the areas where its feature set has been significantly restricted compared with both its predecessor (MSDE) as well as full-fledged counterparts (such as SQL Server 2005 Standard, […]

In our series dedicated to SQL Server 2005 Express Edition, we have been focusing mainly on characteristics that emphasize its unique capabilities, making it a preferred choice in variety of scenarios, despite the apparent superiority of its full-featured counterparts. However, it is fairly obvious that its small footprint and free-of-charge use also have negative implications, […]

In the most recent installments of our series dedicated to SQL Server 2005 Express Edition, we have been exploring one of its more distinguishing and popular features known as the user instance model. As we pointed out, this functionality is often employed by .NET applications to provide easily configurable and transferable data storage. In particular, […]

In the previous installment of our series dedicated to SQL Server 2005 Express Edition, we presented the publishing options of ClickOnce-capable applications (leveraging functionality built into .NET 2.0 Framework) that involve User Instance-based databases, by reviewing the interface exposed in the Publish section of the project Properties window in Visual Basic 2005 Express Edition. In […]

In the most recent installments of our series dedicated to SQL Server 2005 Express Edition, we have discussed the User Instance mechanism, presenting its unique characteristics and providing examples demonstrating its behavior. We have also described the role of Visual Basic 2005 Express Edition in designing and implementing applications that utilize this functionality. In this […]

Working with User Instances using Visual Basic 2005 Express Edition In the previous installment of our series dedicated to SQL Server 2005 Express Edition, we have demonstrated unique behavior of user instances by observing operational characteristics of the SSEUtil administrative utility. While our presentation was sufficient to ensure a basic understanding of their features as […]

In the previous installment of our series dedicated to SQL Server 2005 Express Edition, we have described its unique functionality that allows you to distribute and implement single-user databases (typically with applications they support) without the dependency of having administrative privileges or the need for a cumbersome configuration. As we explained, this feature, known as […]

In the previous installments of our series dedicated to SQL Server 2005 Express Edition, we have documented its installation and initial configuration process, as well as described some of its basic features. Based on the information we have presented so far, you might be tempted to conclude that this edition is simply a scaled down […]

In the most recent articles of our series dedicated to SQL Server 2005 Express Edition, we have been discussing a number of tasks that modify default settings applied during standard installation, resulting in a variety of functional improvements. Throughout this discussion, we have described activities that enable remote connectivity and enhance security through encryption of […]

In the previous installment of our series dedicated to SQL Server 2005 Express Edition, we have reviewed a number of network-based configuration tasks that are typically introduced following the initial setup process. In our new article, we will continue coverage of this topic by describing other activities that alter default connectivity settings applied during standard […]