Database Podcasts
-
OnMicrosoft from InformIT: On Microsoft - SQL Server 2005 Database Administration with Buck Woody - Part 1
Join host Ted Neward as he discusses scripting with "Adminstrator's Guide to SQL Server 2005" author Buck Woody in part 1 of this series.
-
OnMicrosoft from InformIT: On Microsoft - Inside Scripting: VBScript, WMI and ADSI Unleashed with Don Jones - Part 2
Join host Ted Neward as he discusses the SQL server 2005 database administration with "VB Script, WMI, and ADSI" author Don Jones, in part 2 of this series.
-
OnMicrosoft from InformIT: On Microsoft - Inside Scripting: VBScript, WMI and ADSI Unleashed with Don Jones - Part 1
Join host Ted Neward as he discusses the SQL server 2005 database administration with "VB Script, WMI, and ADSI" author Don Jones, in part 1 of this series.
-
MSDN UK Screencasts: Transactions in LINQ to SQL
In this video we'll talk about how we can use transactions when we are working with LINQ to SQL.
-
MSDN UK Screencasts: Inheritance in LINQ to SQL
You can persist .NET types from an object hierarchy into a relational table using LINQ to SQL. In this session we'll take a look at how that's done.
-
MSDN UK Screencasts: User Defined Functions in LINQ to SQL
LINQ to SQL has facilities for exposing your own user defined functions to the framework whether those be scalar valued or table valued. In this session we'll take a look at how that works.
-
MSDN UK Screencasts: Using SQL Functions in LINQ to SQL
A large number of SQL server's standard functions (and functionality) are exposed through the functions that are callable from a LINQ to SQL query. In this session we'll look at a few examples of how this works.
-
MSDN UK Screencasts: Updating with Stored Procedures in LINQ to SQL
Take control of your inserts, updates and deletes by passing changes through your stored procedure layer on their way to the database.
-
MSDN UK Screencasts: Querying with Stored Procedures in LINQ to SQL
LINQ to SQL isn't necessarily all about generating T-SQL from your .NET code. You can also query data using stored procedures thereby gaining advantages of security and control. In this session, we'll take a look at how that works.
-
MSDN UK Screencasts: Deferred Loading of Related Entities in LINQ to SQL
LINQ to SQL has capabilities for controlling when related Entities are loaded from the database. The framework has default mechanisms but you can override those and take control. In this video we'll explore how this works.
-
MSDN UK Screencasts: When Do LINQ to SQL Queries Execute?
Defining a query and executing it are two different things in the LINQ to SQL framework and it's important to realise when queries get executed and under what conditions. Here we take a look.
-
MSDN UK Screencasts: Working with NULLs in LINQ to SQL
NULL values are common in relational databases but not so common in .NET Framework programming (especially for value types). In this video we look at how LINQ to SQL (along with CLR 2.0 and Framework V2.0) naturally uses nullable data types.
-
MSDN UK Screencasts: Joining Data with LINQ to SQL
Inner, Outer, Left, Cross - lots of different join types show up in relational databases and, in this video, we look at how we replicate that when using LINQ to SQL.
-
MSDN UK Screencasts: Updates with LINQ to SQL
The title says it all - how do we do updates when using LINQ to SQL?
-
MSDN UK Screencasts: Deletes with LINQ to SQL
The title says it all - how do we do deletes when using LINQ to SQL?
-
MSDN UK Screencasts: Inserts with LINQ to SQL
The title says it all - how do we do inserts when using LINQ to SQL?
-
MSDN UK Screencasts: Code Generation Tools in LINQ to SQL
LINQ to SQL comes with tools both inside and outside of Visual Studio for generating artefacts that we can then feed to the framework to drive the mapping process. In this video we explore those tools.
-
MSDN UK Screencasts: Mapping Schemas to Classes in LINQ to SQL
In order to use LINQ to SQL we need to let the framework know how to map between the relational schema and our .NET types. In this video we look at the mechanisms for doing this.
-
MSDN UK Screencasts: Introduction to LINQ to SQL
Here we take a quick look at what LINQ to SQL is, what it does for us and what the various aspects to the technology are.
-
MSDN UK Screencasts: Windows Workflow Foundation: Building Persistence Services
Windows Workflow Foundation comes with its own persistence service that uses SQL Server. However, it is also possible to build your own, and in this session we explore the basics of achieving that.
Featured Podcast Show
-
Rails Envy Podcast
Last episode 11 years ago on www.railsenvy.com
The Rails Envy podcast is a weekly newscast by Jason Seifer and Gregg Pollack about what's new in the Ruby and Ruby on Rails worlds.