Everybody knows how to call stored procedures from a .NET application. Right? But then, how often do you see stored procedures used to their full advantage in database applications? William Brewer goes through some of the basics, but uses PowerShell as the example .NET application, and avoids all mention of Northwind or AdventureWorks!
This article discusses the connectivity and usage of Teradata database servers and the .NET Framework Data Provider for Teradata with Microsoft SQL Server 2008 Reporting Services (SSRS).
Reduce both time and memory utilization when uploading bulk data to SQL Server 2008 by combining Table-Valued Parameters (TVPs) and the .Net IEnumerable interface.