SQL Learnings

2009-06-23T05:24:00.000-07:00

SQL Server 2005 Database school
About the SQL Server 2005 School This SQL Server 2005 Database Programming school is specificaly designed to help database developers to learn the functionality available in SQL Server 2005 and plan business solutions to take advantage of this latest technology.
Prerequisites This course requires that you have experience with Microsoft SQL Server. 7.0 or SQL Server 2000 in the following areas:
Database architecture
Database security
Transact-SQL
Query engine
DDL
DML
Optimization
Schema and objects
Programming objects
UDT
UDF
Triggers
Stored procedures
SQLXML
ADO.NET Experience developing with Microsoft Visual Basic .NET or Microsoft Visual C# is useful but not essential.
Course Outline Lesson 1. SQL Server 2005 Overview Lesson 2. Overview of SQL Server 2005 Architecture Lesson 3. Installing SQL Server 2005 Lesson 4. Transact-SQL Enhancements in SQL Server 2005 Lesson 5. XML integration with SQL Server 2005 Lesson 6. Using the .NET CLR in SQL Server 2005 Lesson 7. Developing Client Applications with ADO .NET 2.0 Lesson 8. Using Service Broker Lesson 9. Using Native HTTP Support Lesson 10. Using Notification Services
Lesson's Description Lesson 1. SQL Server 2005 Overviewintroduces you to the components, services, and tools in SQL Server 2005. You will learn how to use the enhanced development features that can improve your day-to-day productivity. You will also learn about the security changes in SQL Server 2005. Lesson 2. Overview of SQL Server 2005 Architectureintroduces you to the components and services of SQL Server 2005. Although you may not be working with all of these components and services on a day-to-day basis, it is important that you are aware of their existence and functionality. Lesson 3. Installing SQL Server 2005describes how you should plan and implement a SQL Server 2005 installation. It discusses coexistence issues and procedures for adding and removing individual components of SQL Server. Lesson 4. Transact-SQL Enhancements in SQL Server 2005introduces the key enhancements to Transact-SQL in SQL Server 2005. You will learn about the improvements made to both the Data Definition Language (DDL) and the Data Manipulation Language (DML). You will also learn about the new structured exception handling techniques that you can use to improve the stability of your applications. Lesson 5. XML integration with SQL Server 2005discusses the XML enhancements in SQL Server 2005 and the new support for XML data and schemas. In addition, you will learn about the use of XQuery in a SQL Server 2005 database application. Lesson 6. Using the .NET CLR with SQL Server 2005describes how you can implement SQL Server objects such as stored procedures and triggers by using managed code, and explains the advantages that you can gain from this approach in certain scenarios. The Lesson teaches you how to write managed objects and how to use compiled managed code in a SQL Server database. Lesson 7. Developing Client Applications with ADO .NET 2.0provides an introduction to ADO.NET database client development. Lesson 8. Using Service Brokerdescribes the concepts of service-oriented architecture and explains how Service Broker lets you build service-oriented database solutions using SQL Server 2005.. Lesson 9. Using Native HTTP Supportintroduces the use of HTTP support in SQL Server 2005 to publish Web services to client applications. It describes how Web services can communicate by using the Simple Object Access Protocol (SOAP) and how this lets you expose database objects across the Internet. Lesson 10. Using Notification Servicesdiscusses how you can create Notification Services applications to automatically send information to subscribers in a specific form.for example, as an e-mail or an SMS message. You will learn how the Notification Service components work together to provide the infrastructure, and how to write applications by using these components.
About the author I dedicate all my work to my precious (my wife) and my lovely daughter Vamika . Vidya Vrat Agarwal, a Microsoft .NET Purist, and an MCT, MCSD.NET, MCAD.NET and MCSD. He is also a Life Member of Computer Society of India (CSI). He started working on Microsoft.NET with its beta release. He has been involved in software development, consultation, corporate trainings, T3 programs and technical writing for Microsoft .NET for various corporate clients. He lives with his beloved wife and lovely daughter Vamika (nick named Pearly). He believes that nothing will turn into a reality without them. In technologies the part which really fascinates him is the architecture of that particular technology. He is the follower of the concept No Pain, No Gain and believes that his wife is his greatest strength. Presently he is working with LioNBridge Technologies in Mumbai - India, where he works with Microsoft Dept. on Visual Studio 2005 (Whidbey) and SQL Server 2005 (Yukon) and his business card reads Subject Matter Expert (SME). His technical profile holds Microsoft .NET Framework, VC#, VB.NET, WebServices, Remoting, SQL Server, COM, DCOM, COM+, MTS, MSMQ. Visual Studio 2005 (Whidbey), SQL Server 2005 (Yukon) and Longhorn.
http://www.programmersheaven.com/2/SQL-server-2005-school

Visual Source Safe 6.0 Recursive Rollback

2009-06-19T06:54:00.000-07:00

http://www.codeproject.com/KB/cs/vssrecursiverollback.aspx

TigerBlog

SQL Learnings

Visual Source Safe 6.0 Recursive Rollback