April 2006 - John Papa [MVP C#]

John Papa [MVP C#]

The Lounge

Wicked Cool Jobs

Syndication

News

Resources

Archives

Sort by: Most Recent | Most Viewed | Most Commented

Developing with SQL Server 2005 - XML Code Samples

As promised here are the main code samples I demonstrated last week at the Toronto VSLive! conference for the Developing with SQL Server 2005 (XML Features) session. I will also post the code for the SQL Server 2005 and XML session here . Topics include: XML Data Type XML Schema Collections FOR XML Querying...

Published Sun, Apr 30 2006 9:27 PM by John Papa

Filed under: SQL, .NET
Developing with SQL Server 2005 - T-SQL Code Samples

As promised here are the main code samples I demonstrated last week at the Toronto VSLive! conference for the Developing with SQL Server 2005 (T-SQL) session. I will also post the code for the SQL Server 2005 XML session here . Topics include: Exception Handling EventData Triggers Common Table Expressions...

Published Sun, Apr 30 2006 9:19 PM by John Papa

Filed under: SQL, .NET
SQL Server 2005 XML Support, Exception Handling, DDL Triggers

My latest Data Points column dives into some of the new XML features in SQL Server 2005 including typed columns and schema collections. I also discussed the TRY/CATCH exception handing features and DDL triggers (which can access event data in an XML format)....

Published Mon, Apr 24 2006 11:31 AM by John Papa

Filed under: SQL, .NET
SQL Server and ADO.NET in Toronto

Stop by and say Hi!...

Published Mon, Apr 24 2006 11:30 AM by John Papa

Filed under: ADO.NET, SQL, .NET
Trivia - Microsoft Code Names

Are you confused by the product code names? Recently I confessed that often I am more confused by the code names than I am by the technology. Does anyone remember Cairo? Chicago? Whistler? Forgot Sphinx and Yukon already? ...

Published Mon, Apr 24 2006 11:10 AM by John Papa

Filed under: Random Stuff, .NET
Practical .NET 2 & C# 2 - First Impressions

I got my copy of Practical .NET 2 and C# 2 about a month ago and with my reading list as it is, I have bouncing around between several books. Some good, some bad and some in between. So I finally got to reading a good chunk of Practical .NET 2 and C# 2 by Patrick Smacchia (the 10 first chapters) and...

Published Mon, Apr 17 2006 11:00 AM by John Papa

Filed under: .NET, Reviews
IIS Default Web Site Won't Start!

If you use Skype and you are seeing the error message "The service could not bind instance 1" when you try to start your default web site, then read on....

Published Sun, Apr 16 2006 10:37 PM by John Papa

Filed under: Random Stuff
SCOPE_IDENTITY() and @@IDENTITY Demystified

The use of IDENTITY values has caused some confusion, specifically in how the @@IDENTITY function operates given external influences. We’ve all likely been faced with how to grab the newly generated IDENTITY value from a SQL Server database table. And there are a 2 popular techniques that accomplish this with SQL Server: the @@IDENTITY function & the SCOPE_IDENTITY() function....

Published Fri, Apr 7 2006 2:29 PM by John Papa

Filed under: SQL

About CodeBetter.Com

CodeBetter.Com FAQ
Our Mission
Advertisers should contact Brendan

Subscribe

Google Reader or Homepage
del.icio.us CodeBetter.com Latest Items
Add to My Yahoo!
Subscribe with Bloglines
Subscribe in NewsGator Online
Subscribe with myFeedster
Add to My AOL
Furl CodeBetter.com Latest Items
Subscribe in Rojo

Member Projects

Sarasota Web Design - David Hayden
Patterns & Practices - David Hayden
dotMath - Steve Hebert
Structure Map - Jeremy D. Miller
StoryTeller - Jeremy D. Miller
The Code Wiki - Karl Seguin

Friends of CodeBetter.Com

Red-Gate Tools For SQL and .NET
Telerik
ComponentArt
VistaDB
JetBrains - ReSharper
Beyond Compare
.NET Memory Profiler
NDepend
Ruby In Steel
SlickEdit
SmartInspect .NET Logging
NGEDIT: ViEmu and Codekana
LiteAccounting.Com
DevExpress
Fixx
NHibernate Profiler
AForge.NET
Unfuddle
Balsamiq Mockups
Scrumy <-- NEW Friend!

Community Server (Commercial Edition)

April 2006 - John Papa [MVP C#]

Sponsors

The Lounge

Wicked Cool Jobs

Syndication

Recent Posts

News

Resources

Archives

Advertisement

Developing with SQL Server 2005 - XML Code Samples

Developing with SQL Server 2005 - T-SQL Code Samples

SQL Server 2005 XML Support, Exception Handling, DDL Triggers

SQL Server and ADO.NET in Toronto

Trivia - Microsoft Code Names

Practical .NET 2 & C# 2 - First Impressions

IIS Default Web Site Won't Start!

SCOPE_IDENTITY() and @@IDENTITY Demystified