.NET development for SQL Server

MUST READ Custom VB.Net scripting in SQL Server Integration Services TIP - Add a Script component and custom Visual Basic.Net (VB.Net) scripting to SQL Server Integration Services (SSIS) packages to get the full power of .Net. Developing CLR database objects: 10 tips, 10 minutes BOOK EXCERPT - In this book excerpt, you'll see how to create CLR database objects using any of the .NET-compatible languages, including C#, Visual Basic, and managed C++ in SQL Server 2005. Retrieve images from SQL Server and store in VB.Net EXPERT ANSWER - I'd like to know how to retrieve data from blob tables more quickly. When I retrieve data to my VB.Net application from SQL Server, it's taking too much time. What's the best way to do this? Creating basic ADO.NET data objects with SqlClient BOOK EXCERPT - Get typical Visual Basic 2005 code for defining and opening an SqlConnection object, specifying a SqlCommand object and invoking the command's ExecuteReader and ExecuteXmlReader. SQL Server freebie: DDL Archive Utility for generating scripts TIP - This free tool will help you create SQL Server 2000 DDL scripts that are Visual SourceSafe compatible.

EXPERT TECHNICAL ADVICE: 1 - 3 of 24

.NET DEVELOPMENT FOR SQL SERVER EXPERTS
			Greg Low Lead SQL Server Consultant ASK A QUESTION

	Code to restore SQL Server databases in VB.NET 20 Feb 2008 EXPERT ANSWER - Learn how to restore a SQL Server database in VB.Net using this ADO.Net code sample provided by our expert.

	Custom VB.Net scripting in SQL Server Integration Services Submitted By: Robert Sheldon | 18 Dec 2007 TIP - Add a Script component and custom Visual Basic.Net (VB.Net) scripting to SQL Server Integration Services (SSIS) packages to get the full power of .Net.

	Connect to SQL Server database with Visual Basics 15 Oct 2007 EXPERT ANSWER - Find how to connect to a SQL Server database using Visual Basics 6.0.

	VIEW ALL EXPERT TECHNICAL ADVICE ON .NET DEVELOPMENT FOR SQL SERVER

REFERENCE & LEARNING: 1 - 3 of 25

	Top 10 SQL Server development questions SearchSQLServer.com | 20 Jul 2007 FAQ - SQL Server development can put you in a crunch. Get solutions here when it comes to concurrency problems, stored procedure results and writing T-SQL.

	.NET database object security McGraw-Hill | 17 May 2007 TUTORIAL - No discussion of the new CLR features would be complete without a description of the security issues associated with using .NET assemblies and the SQL Server CLR.

	Debugging CLR database objects McGraw-Hill | 17 May 2007 TUTORIAL - One significant feature found in the integration of .NET Framework and Visual Studio 2005 is the ability to debug the CLR database objects you create. Get more in this book except.

	VIEW ALL REFERENCE & LEARNING ON .NET DEVELOPMENT FOR SQL SERVER

NEWS: 1 - 3 of 12

	Microsoft kills standalone WinFS file system SearchWinIT.com | 26 Jun 2006 ARTICLE - Microsoft has pulled the plug on one of Bill Gates' pet projects just over a week after he turned the technical mantle of his company over to Ray Ozzie.

	Visual Studio Team System adds database personality SearchVB.com | 01 Jun 2006 ARTICLE - VSTS will gain a database edition later this year, Microsoft said. Improved communication between database developers and application developers is a major goal of the product.

	Microsoft launches Visual Studio 2005, including team version and VB.NET updates SearchVB.com | 07 Nov 2005 ARTICLE - Long awaited, Microsoft's Team Server supports modeling and testing and is said to improve development team members' ability to collaborate.

	VIEW ALL NEWS ON .NET DEVELOPMENT FOR SQL SERVER

WHITE PAPERS

	Increasing Developer Efficiency: Transforming your .NET Team Published by: InnerWorkings | 24 Apr 2008 CASE STUDY - This white paper details a case study, exploring how First Data Corp was able to successfully transform their .NET developer training, creating better alignment between business strategy and company objectives.

	Seeing Clearly: The Benefits of an Intuitive Enterprise Solution Published by: Intuitive ERP | 16 Apr 2008 WHITE PAPER - The Intuitive ERP enterprise solution includes feature-rich and integrated ERP, customer relationship management, business intelligence and e-commerce modules all the tools you need to enhance the productivity and profitability.

	The impact of Microsoft .NET on the ERP market Published by: Intuitive ERP | 21 Mar 2008 WHITE PAPER - Discover the impact and benefits that .NET will provide for the manufacturing industry such as better enterprise resource planning (ERP) systems, lower costs and more.

	VIEW ALL WHITE PAPERS IN THIS TOPIC

BEST WEB LINKS: 1 - 3 of 4

	SQL Server 2000 Survival Guide http://www.akadia.com/services/sqlsrv_programming.html | 22 Jul 2005 BEST WEB LINK - Here you find step-by-step resources for architecting, administering and managing SQL Server 2000.

	Microsoft SQL Server: Programming Forum http://www.tek-tips.com/ | 22 Jul 2005 BEST WEB LINK - This active forum dedicated to SQL Server will give answers to SQL Server's most difficult questions.

	A simple VB.NET stress utility for SQL Server 2000 The Code Project | 15 Apr 2005 BEST WEB LINK - This article describes a VB.NET tool to test the performances of a Microsoft SQL Server 2000 user database.

	VIEW ALL BEST WEB LINKS ON .NET DEVELOPMENT FOR SQL SERVER

	SEE ALSO - Topics Related to .NET development for SQL Server:  Web services/SOA, SQL Server stored procedures, Visual Basic in SQL Server, XML in SQL Server, SQL/Transact SQL (T-SQL), C#