Working with Data in ASP.NET 2.0 - Debugging Stored Procedures
Visual Studio provides a rich debugging experience. With a few keystrokes or clicks of the mouse, it’s possible to use breakpoints to stop execution of a program and examine its state and control flow. Along with debugging application code, Visual Studio offers support for debugging stored procedures from within SQL Server. Just like breakpoints can be set within the code of an ASP.NET codebehind class or Business Logic Layer class, so too can they be placed within stored procedures.
Read more
.NET Tutorial for Beginners
Welcome friends to the exciting journey of Microsoft .NET. If you are looking for information about what .NET is all about, what it can do for you or how it can help you and your customers, you have come to the right place. This section is intended to tell you about these and many more things. After covering this section you will be ready to delve into details of .NET.
Read more
Data Binding with Windows Forms
Data binding is a powerful capability that has finally matured in Windows Forms 2.0 through the capabilities in the .NET Framework classes, combined with the rich designer support provided by Visual Studio 2005. By using data binding properly, you can save yourself from writing a lot of unnecessary code, provide your users a rich interactive experience for working with data that functions well, and produce code that is easy to maintain. To get it correctly across a variety of use cases, you need to know more than how to set a few properties on controls. You need to understand what is going on under the hood, especially if you want to support complex scenarios that require going beyond the basic capabilities of the data binding components in the .NET Framework.
Read more
An Overview of SQL Server Yukon for the Database Administrator
This document provides an overview of new features for database administration as well as database availability and scalability and security. The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication. This White Paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.
Read more
IBM DB2 UDB V8.2 Oracle10g Microsoft SQL Server 2000 A technical comparison
In 2003, over 86% of the worldwide total RDBMS revenues went to only three vendors. According to a recently published study by the Gartner Group1, IBM had 35,7%, Oracle 32,6% and Microsoft 18,1% of total 2003 RDBMS new license revenue. But neither license revenue nor market share will be the dominant factor when selecting a database for enterprise applications. Prospective customers should be looking at a large range of criteria, including a great number of technological aspects, to evaluate available database products. This paper seeks to support senior technical product evaluators in comparing IBM DB2 Universal Database v8.2, Oracle10g, and Microsoft SQL Server 2000. A thorough list of technical criteria (with over a hundred detailed measures) has been grouped into 13 categories, enabling a comparison based on database technologies. Additional criteria concerning product architecture and operating system support has been researched and documented. It is important to understand that, although this paper includes information on built-in features and payable options, our evaluations have disregarded any TCO aspects and should be viewed from a technical perspective only.
Read more