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
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.
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
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.
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
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!
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
“Doing nothing for others is the undoing of one's self.” - Horace Mann