Consider the following scenario. You install the Microsoft SQL Server 2005 Backward Compatibility Components on a computer where SQL Server 2000 is installed. If you uninstall the SQL Server 2005 Backward Compatibility Components from the computer and then try to open SQL Server Enterprise Manager,
Author: SSWUG Research
How to Make SQL Dependency Work Where It Doesn’t
(Sandeep Bhatia) The intent of the article is not to let one know about the internals of SQL Dependency nor it is meant to guide readers to scenarios where SQL Dependency should be used. We already have some very good content on the site that details internals and usage of query notification in SQL
SQL Server Integration Services: Simplify database maintenance
(Jeremy Kadlec) SQL Server took a leap forward in database maintenance functionality with the introduction of SSIS (SQL Server Integration Services) in SQL Server 2005. The SQL Server Development Team at Microsoft adapted SSIS to offer point-and-click database maintenance, offering vast improvements
Improve persistence with Apache Derby and iBATIS, Part 2: Data definition in Derby
(Daniel Wintschel) In this second tutorial of a three-part series, learn more about how you can improve persistence in your database-driven Java applications by combining Apache Derby’s power as a small-footprint embeddable database with the iBATIS object-relational (OR) mapping framework. In Part 2
Using SQL Anywhere Database with a Web Services Server
(Jayaram Krishnaswamy) This article explains how to create a web services server that works with the SQL Anywhere database. The entire process, from creating the database through verifying installation of the web service, will be described.
Form Authentication in ASP.NET using XML
(Pang Tat Sean) In ASP.NET, most of the tedious work of writing authentication form has been taken out. When user logs in using form authentication, a cookie is created and used to track the user throughout the site. Once user successfully logs in, you can issue an authentication cookie to save auth
How to: Debug XML Web Services in Managed Code
When you are ready to build and run your XML Web service, you must first compile the ASP.NET Web Service project. Once compiled, you can run the XML Web service.
XML for Analysis: A Sneak Peek Inside the Skunk Works
(Brian King) Imagine a world where the potentials of business intelligence are more pervasive and more accessible. Thanks to an initiative that’s steadily gathering steam, that reality may not be far off.
Comparing SQL Server 2005 and IBM DB2 v8.2 as a Database Platform
A well-known developer in the Visual Studio and Microsoft .NET community compares and contrasts SQL Server 2005 with IBM DB2 UDB 8.2, from the perspective of a Visual Studio 2005 developer. This study compares the core technologies used by both SQL Server 2005 and DB2 UDB 8.2, such as .NET Framework
Accessing data from dynamically created controls, using ASP.NET 2.0 callback
(vineyard) While developing with ASP.NET 2.0, I ran into a situation where I needed to create controls dynamically. As usual, I started looking for best practice methods by searching the websites and blogs I often turn to. Every example I found talked about the need to recreate the dynamically creat