.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

Beyond the Thin Client: Why a Smart Client CRM Solution May Be a Smarter Choice Published by: Pivotal CRM, a CDC Software solution | 11 Nov 2009 WHITE PAPER - This white paper compares and contrasts the two primary alternatives to thin clients and examines the differentiating characteristics that could impact your CRM implementation. Read on to learn why a smart client CRM solution may be a smarter choice.

Developing WS-Management Solutions for Intel® Active Management Technology Published by: Intel | 10 Nov 2009 TECHNICAL ARTICLE - This article describes how to develop flexible WS Management-based solutions for Intel® Active Management Technology using the .NET development environment. The basic ingredients and building blocks of a WSMan-based solution will be presented. We've included some coding samples (written using Windows 2008) to help illustrate this information.

	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.

	VIEW ALL WHITE PAPERS IN THIS TOPIC

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