Bob Beauchemin rss

  • XML in Yukon: New Version Showcases Native XML Type and Advanced Data Handling
    The next version of Microsoft SQL Server, code-named "Yukon," represents quite a few steps forward in the evolution of XML integration. Yukon supports native storage of XML data using the XML data type, which makes it possible to run native queries on XML data using the emerging industry standard XQuery language. Data integrity of the XML data type can be enforced through schema validation and XML-based check constraints, and special indexes can be defined that help speed up queries. In addition, Yukon has the built-in ability to expose its data through Web services. This article discusses these and other XML features of Yukon.
    Bob Beauchemin - February 2004
  • ADO.NET: Building a Custom Data Provider for Use with the .NET Data Access Framework
    The System.Data.dll assembly in the .NET Framework contains namespaces whose base classes can be used to create custom data providers. These namespaces also define a number of data access interfaces and base classes that let developers create data providers that will interoperate with other custom providers. Using the ADO.NET classes Connection, Command, DataReader, and DataAdapter, writing a provider is easier than writing one for OLE DB. This article explains these classes and their implementation, and how they can be used to write a variety of different kinds of data providers.
    Bob Beauchemin - December 2001
  • Under the Table: How Data Access Code Affects Database Performance
    In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.
    Bob Beauchemin - August 2009
  • Under the Table: Programming with FileStreams in SQL Server 2008
    There's always been disagreement about whether large blobs, such as document and multimedia items, should be stored in the database or file system. In SQL Server 2008 you don't have to choose; filestream storage provides the best of both approaches.
    Bob Beauchemin - May 2009
  • Under The Table: Spatial Data Support In SQL Server 2008
    New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.
    Bob Beauchemin - February 2009