James Davis' Blog

Partioned Tables in SQL Server 2005

James Davis — Tue, 17 Apr 2007 14:13:00 GMT

Nigel Rivett wrote an awesome blog on partitioned tables in SQL Server 2005 that provides a lot of useful information and applicable examples. If you are thinking of partitioning your tables, start here.

Information Covered

Creating a Partitioned Table
Adding and Removing Partitions
Switching a Populated Partition
Identities in a Partitioned Table
Clustered Indexes
Unique Indexes
Non-Unique Indexes
Computed Partitioned Functions
Partitioning on Multiple Columns
Sliding Date Range Partitions

WPF and Windows Live Code Examples

James Davis — Tue, 17 Apr 2007 09:27:00 GMT

The Panel - Code and Examples

Code examples and applications for WPF and Windows Live applications. The Panel is the place to collect showcases of new user experiences and provide insights on how they were implemented. WPF applications and Windows Live gadgets are featured.

Transactional SQL within a Try Catch

James Davis — Fri, 30 Mar 2007 11:13:00 GMT

BEGIN TRANSACTION TransactionName

BEGIN TRY

PRINT 'Do work here'

END TRY

BEGIN CATCH

PRINT 'ERROR: ' + CAST(ERROR_MESSAGE() AS VARCHAR(1000))

PRINT 'Aborting and Rolling Back'

ROLLBACK TRANSACTION TransactionName

END CATCH;

-- <- Use this section for unit testing -> --

PRINT 'Aborting and Rolling Back'

ROLLBACK TRANSACTION TransactionName

-- <- Use this section to commit your changes -> --

--PRINT 'Commiting Transaction'

--COMMIT TRANSACTION TransactionName

ASP.NET AJAX 1.0 Source Code Released

James Davis — Tue, 30 Jan 2007 16:11:00 GMT

The code for the server-side ASP.NET AJAX 1.0 implementation was released this morning. You can download it here. It is being released under the Microsoft Reference License (Ms-RL). Included with the source code are debugger symbols for the shipped binary, which will allow you to step from your own code into the ASP. NET AJAX library while debugging, with line number and symbol data preserved. Note that the setup installs the source code locally on your machine within the "\Program Files\Microsoft ASP.NET\ASP.NET 2.0 AJAX Extensions\v1.0.61025\Source" directory.

Check out ScottGu's Blog for more info.

The Art of Innovation by Guy Kawasaki (Video)

James Davis — Wed, 24 Jan 2007 17:22:00 GMT

Great Speech!

The Art of Innovation Video

The Art of Innovation Visually Summarized (1024 x 558 - 348k) (4075 x 2217 - 7.4mb)

p.s.: minus the bashing of consultants

Visualization Methods

James Davis — Wed, 24 Jan 2007 16:47:00 GMT

The Visual Literacy Organization put out this absolutely stunning and amazing periodic table of visualization methods. This is an amazing resource for any person trying to visualize almost anything and lets face it we are all visual learners to some degree. Just hover over one of the blocks and you should get a pop-up that gives you an example of the visualization. I don't say this much, but this is incredibly useful. WOW!

Internet Explorer Developer Toolbar Beta 3 - Now Available

James Davis — Mon, 22 Jan 2007 09:06:00 GMT

Download Here

Office 2007 Top Ten Resources for Developers and Architects

James Davis — Tue, 05 Dec 2006 22:31:00 GMT

Erika has compiled an awesome list of resources that everyone should have in their back pocket. Check it out!

2007 Microsoft Office System - Top Ten List of Resources for Developers and Architects

New Office Developer Posters

James Davis — Mon, 27 Nov 2006 15:35:00 GMT

Office 2007 Suite Road Map

InfoPath Object Model

SharePoint Services Platform

Servant Leadership Quote

James Davis — Sun, 30 Oct 2005 23:21:00 GMT

“Doing nothing for others is the undoing of one's self.” - Horace Mann