In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement.
The MERGE statement allows you to join a data source with a target table or view, and then perform multiple actions against the target object based on the results of that…
This Week on Channel 9, Dan and Brian are joined by Clint Rutkas and we discuss:
Clint talks about MS 101 (0 - 1:00) SQL Server 2008 RC0 is now available (and we don't know why some teams start with a zero based array and others don't) (1:00 - 2:30)
The Information Security Consolidated Event Management (ICE) system is a more than 30-terabyte data warehouse used by the Microsoft Information Security team to analyze network utilization events captured by various sources, including
over 100 proxy servers, mail servers, Net logon servers, etc.…
This Week on Channel 9, Brian and Dan cover:
- Brian Keller back this week (0 - 0:50)
- Microsoft withdraws proposal from Yahoo (0:50 - 1:24)
- Expression Studio 2 now available (1:24 - 2:40)
XNA Game Studio CTP now available so you can build Zune game (2:40 - 4:00)
Windows XP SP3 now…
Here's a very practical geekSpeak that's loaded with tips on how to incorporate LINQ into existing architectures and applications. Our guest Jim Wooley has a longtime background with databases, coming out of the Access and Foxpro world. He shares his insights
about how the advent of LINQ brings…
This Week on Channel 9, we have special guest host Jacqueline Russell talking about Popfly Game Creator.
- Intro to Popfly Game Creator (0 - 3:14)
- Clip of Adam Nathan from the Popfly team
building a 2D side scroller (3:14 - 5:39)
- Jacqueline builds a custom Channel 9 game…
We recently posted a very interesting conversation with Technical Fellow and database guru Dave Campbell
covering some of the new innovative work going on over in SQL Server World. Paul touched on SQL Server Data Services and database services in the sky, generally.
Here, SQL Server Technical…
Michael Scherotter just visited
CrystalTech a web hosting provider in Scottsdale, Arizona. President Bob Cichon took Michael on a tour of the data center.
At $2.95 per month for an ASP.Net 3.5 developer account Michael is also a customer of CrystalTech with his
Kirk Evans interviews Mark Kashman, the Product Manager for Interactive Media Manager. IMM is a Digital Asset Management (DAM) system built on top of SharePoint 2007. In this episode, we take a look at the architecture of IMM, see it in action, and we
even see a sneak preview of a…