.NET news » Database 
Beginning ASP.NET 2.0 and Databases (Wrox Beginning Guides)
Authors: John Kauffman, Bradley Millington
Average rating:
(2 reviews)
More .NET Database books
 |
Persistent Datasets 1.0.5 - Persistence Layer with Native Queries released
Persistent Datasets is a Persistence Layer for .NET 2.0 that allows using Native C# Queries for querying database. The latest release includes SQL Server 2005 support and improved Native Queries syntax.
24 Nov 2005, 02:00:00 Source: Persistent Datasets 1.0.5 - Persistence Layer with Native...
Tags: Database
New DataSet Features in Visual Studio 2005
Learn about the new features in the typed DataSet class and the new TableAdapter class that are generated by Visual Studio 2005, as well as the tools for designing these classes.
14 Nov 2005, 19:58:30 Source: New DataSet Features in Visual Studio 2005
Tags: Database
Visual Studio
SQL Server 2005: Fuzzy Lookups and Groupings Provide Powerful Data Cleansing Capabilities
SQL Server 2005 offers a completely redesigned SQL Server Integration Services engine, formerly known as Data Transformation Services. It includes many new features such as built-in support for Fuzzy Lookups and Fuzzy Groupings, which help you build powerful data-cleansing solutions. This article provides an overview of fuzzy searching techniques and a dissection of the underlying fuzzy search technology implemented in SQL Server 2005.
To SP or not to SP in SQL Server
The topic of using or not using stored procedures reaches the level of religious fervor in many quarters. Douglas Reilly, a Microsoft MVP, weighs in on the topic with an in-depth analysis.
Filtering and Sorting in ADO.NET
ADO.NET supports many ways to manage memory-resident data returned in a DataSet. This example demonstrates how to use the additional functionality exposed by ADO.NET to sort and filter data.
Hackers Beware: Keep Bad Guys at Bay with the Advanced Security Features in SQL Server 2005
Get a peek at the new security features in SQL Server 2005 from a developer's point of view. While there are lots of admin enhancements, there are also plenty of dev-specific security improvements you can take advantage of, such as endpoint authentication and support for the security context of managed code that executes on the server. Here Don Kiely elucidates.
10 May 2005, 03:00:00 Source: Hackers Beware: Keep Bad Guys at Bay with the Advanced...
Tags: Database
Security
Say What? Make Sense of Your Web Feedback using SQL Server 2005
By now, you're certainly collecting a variety of data from your Web site. But once you collect it, what do you do with it. For it to be meaningful, this data must be categorized and analyzed. The SQL Server 2005 data mining functionalities can help you get the most out of those reams of data you collect, as Peter Pyungchul Kim explains.
Mine Your Business: AMO Lets You Dig Deeper into Your Data from Your Own Applications
Analysis Management Objects (AMO) for SQL Server 2005 facilitates client-side custom programming as Decision Support Objects (DSO), the object model in SQL Server 2000 Analysis Services. With AMO, a whole range of data mining questions can be answered at the operational level. This means that sales and marketing departments get answers more quickly and thus can make informed decisions.
10 May 2005, 03:00:00 Source: Mine Your Business: AMO Lets You Dig Deeper into Your...
Tags: Database
Debug
Data Points: XML Features in SQL Server 2000
Data Points: XML Features in SQL Server 2000