Database

Learn how to solve reoccurring performance problems during data migration to SQL Server.

Is some of your business logic in code and some in SQL Server? Then, just call the SQL from the .NET framework and the .NET framework from SQL with CLR integration. Here are all the steps you need to get started.

Learn to leverage the power of Dundas Charts in your next SQL Server project.

Relational databases are designed for multiple simultaneous users, and Microsoft SQL Server is no different. However, supporting multiple users requires some form of concurrency control, which in SQL Server's case means transaction isolation and locking. Read on to learn how SQL Server 2008 implements locking.

Learn to leverage the power of the cloud with your existing web applications.

Learn how to use SQL Modeling Services to hunt for interdependencies without having to access source code.

In today's column we'll demonstrate how and when to use the new TSQL MERGE statement and how this can be a helpful addition to your toolbox.

Repetitive tasks are nothing new to a developer. Writing ADO interface code is one of these tasks. In this article David R. K. DeLoveh shows us how to write code to generate code for calling stored procedures in SQL Server 7.

In the first part of his hands-on tutorial on using Visual Studio 2005 to build a complete 3-tier application, David Catherman examines how Visual Studio 2005 can be used as a great tool for designing and building SQL Server 2005 databases.

Developer Stephan Onisick shows us how to create a standalone/custom recordset and use its organizational ability to perform logical tasks with data without connecting to a database. This article uses a small application written using VBScript, ADO 2.1, and an Excel spreadsheet to record and print computer expenses for tax preparations. The standalone recordset is saved in XML format, and the file can be updated with new data simply by reopening as a recordset and using normal recordset methods.

This article was written mainly for developers who use Firebird Embedded SQL Server in .Net framework applications and want to speed up or optimize DB queries. We will describe how to create your own native Firebird extension and show some approaches how to use it in managed code applications.

Sometimes when you have all kinds of data what you really need is XML. LINQ to XML let's you employ functional construction to convert your data into XML.

Providing a drop down list in your ASP.NET Web applications help users avoid wasting time with bad data and it's a kinder, gentler thing to do.

Elevate your SQL game (a little bit) with CROSS APPLY and OUTER APPLY.

Devexpress has a commitment to providing amazing ASP.NET (and other controls), such as their latest revision of their ASPxGridView, version 8.3, which supports filtering, grouping, sorting, and much more, with little or no coding on your part.

LINQ to SQL eliminates SQL Injection Attacks and is easier to use than straight SQL to boot.

ADO.NET 3.0 and the ADO.NET Entity Framework are designed to let you spend less time writing SQL and database plumbing code and more time working in the space of the problem you are trying to solve.

Learn how to make Visual Studio Team Suite Database Edition part of your development process.

Learn how to implement a Left Outer Join with LINQ.

Manipulating data with ADO.NET can be easy. Discover the steps to creating a simple form to add, update, and delete database records using ADO.NET.

Discover a quick (and easy) introduction to using ADO.NET to read information from a database.

You can use LINQ to SQL to define an Object Relational Mapping between SQL tables and then query those tables with LINQ.

This is a fully functional sample that shows some advanced features that would be hard to do with bound controls.

Learn about local type inference in C# 3.0 and Visual Basic 9.0. Examine why it is relevant and the syntax for its use.