Screencasts by Mike Taulty

Results 11 - 15 of 156 screencasts found by Mike Taulty.   

• SQL Server 2008 - Writing data with FileStream

  SQL Server 2008 has a new extension to the varbinary(max) datatype which allows you to store arbitrary large blobs "in the database" from the perspective of data access and backup but the actual data ...

  Posted: 14/12/2007 by Mike Taulty

  Tags: c#

• SQL Server 2008 - Change Tracking

  SQL Server 2008 has two facilities for monitoring changes to a table to facilitate (e.g.) loading of a data warehousing or building an online/offline application with syncronisation capabilities.
   
  In ...

  Posted: 14/12/2007 by Mike Taulty

  Tags: SQL Server

• SQL Server 2008 - Table Valued Parameters

  SQL Server 2008 (and ADO.NET in .NET Framework V3.5) have a capability whereby you can pass a whole table of data into a stored procedure in one go. Rather than passing XML or a string, multi-valued ...

  Posted: 14/12/2007 by Mike Taulty

  Tags: ADO.NET, SQL Server

• LINQ to XML - Events and Annotations

  LINQ to XML has a way in which arbitrary objects can be used to "annotate" an XML tree. This provides a convenient way to associate a non XML data structure with data stored in an XML tree. You can ...

  Posted: 14/12/2007 by Mike Taulty

  Tags: C# Version 3.0

• LINQ to XML - Streaming Large Data Files Out of Memory

  LINQ to XML has built-in support via the XStreamingElement for avoiding the cost of creating a large tree of XML nodes in memory in situations where you are streaming that XML out to (e.g.) disk. ...

  Posted: 14/12/2007 by Mike Taulty

  Tags: C# Version 3.0