.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 25

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

	Secure SQL Server from SQL injection attacks Submitted By: SearchSQLServer.com | 25 Jun 2008 TIP - SQL injection is one of the most common security risks for Internet-facing SQL Server databases. Here are precise steps to protect against attacks.

	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.

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

REFERENCE & LEARNING: 1 - 3 of 26

	FAQ: How to troubleshoot and grant SQL Server permissions Steve Cimino, Assistant Editor | 04 Sep 2008 FAQ - Permissions problems affect your users login abilities and their access to certain aspects of SQL Server. Troubleshoot permissions issues with these FAQs submitted by your peers.

	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.

	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

	Lotus Notes Migration Frequently Asked Questions Published by: UNIFY Corporation | 19 Sep 2008 WHITE PAPER - High business costs and standardizations are making it difficult for Lotus Notes/Domino environments to avoid the migration to Microsoft platforms. Although this process may not be ideal, it can be done quickly and painlessly with Composer for Lotus Notes

	Composer for Lotus Notes Brochure Published by: UNIFY Corporation | 19 Sep 2008 WHITE PAPER - Composer for Lotus Notes is a software plus services solution that delivers like-for-like, production-to-production migration of Lotus Notes applications to the Microsoft stack.

What About My Notes Applications? - Key Reasons Organizations Migrate Lotus Notes Applications to .NET and SharePoint Published by: UNIFY Corporation | 19 Sep 2008 WHITE PAPER - This paper delivers information and a solution for companies that want to transition off Lotus Notes and understand that the email and calendaring can be effectively transition to MS Exchange, but ask, \"what about my Notes applications?\"

	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#