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

	Creating Windows PowerShell scripts to manage SQL Server 2008 instances Submitted By: SearchSQLServer.com | 14 Jan 2009 TIP - Find out how Windows PowerShell snap-ins can create and run PowerShell scripts to better manage SQL Server 2008 objects, databases and other instances.

	Manipulate column names in a SQL Server table 02 Oct 2008 EXPERT ANSWER - Learn SQL Server commands to manipulate column names in a table and turn column names into variables or rename SQL columns.

	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.

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

REFERENCE & LEARNING: 1 - 3 of 17

	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 9

	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.

	What can .NET code do from within SQL Server: Safety levels Addison-Wesley | 28 Feb 2005 ARTICLE - Learn what .NET code can do from within SQL Server in this excerpt from "A First Look at SQL Server 2005 for Developers."

	SQL Server permissions and new objects Addison-Wesley | 28 Feb 2005 ARTICLE - Learn about SQL Server permissions and new objects in this excerpt from "A First Look at SQL Server 2005 for Developers."

	VIEW ALL NEWS ON .NET DEVELOPMENT FOR SQL SERVER

WHITE PAPERS

	WebUI Studio Premier 2009 R1 SP1 Published by: Intersoft Solutions | 03 Nov 2009 TRIAL SOFTWARE - WebUI Studio 2009 R1 Premier® edition is expertly designed to solve the most complex enterprise-level web development requirements. It offers the ultimate toolset for building dynamic and powerful next-generation Rich Internet Applications.

Marin County Upgrades Tax System While Reducing the Costs of the Mainframe Published by: Micro Focus UK | 27 Oct 2009 CASE STUDY - The property tax system for Marin County, California, was increasingly expensive to maintain; furthermore, it was not possible to integrate it with newer modern technologies. Read this case study to learn how they updated and modernized this critical application without losing valuable IT assets embedded in the current system.

	Butler Group Technology Audit for Blaze Advisor 6.5 Published by: FICO | 16 Jun 2009 ANALYST REPORT - Download this analyst report and discover how Blaze Advisor provides a high-performance runtime environment for .NET, Java, Service Oriented Architecture (SOA), or legacy applications and features strong change management through its rules repository.

	VIEW ALL WHITE PAPERS IN THIS TOPIC

	SEE ALSO - Topics Related to .NET Development for SQL Server:  SQL Server Database Modeling and Design, SQL Server Stored Procedures, XML in SQL Server, SQL/Transact SQL (T-SQL), SQL Server Business Intelligence (BI) and Data Warehousing