.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

	802.11n Drives an Architectural Evolution Published by: Hewlett-Packard Company | 23 Dec 2008 WHITE PAPER - This paper examines both centralized WLAN switch architecture and the optimized WLAN architecture, so that the wireless network choice an organization makes will protect its investment and allow it to experience the benefits of 802.11n for years.

	FAMIS Mobile for Maintenance Management Published by: FAMIS Software, Inc., An Accruent Company | 05 Dec 2008 PRODUCT LITERATURE - FAMIS Mobile for Maintenance Management delivers the next generation of mobile software for automating field workers.

	Hosted Solution Offers a Better Option for Medical Practice Management and Billing Published by: Microsoft Corporation India Pvt Ltd | 01 Dec 2008 CASE STUDY - AdvancedMD's Web-based solution facilitated centralized management and deployment, and the use of AJAX programming techniques improved application responsiveness.

	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#