May 2008
M T W T F S S
« Apr   Jun »
 1234
567891011
12131415161718
19202122232425
262728293031  

Archives

Meta

Recent Posts

Tags

asp .net asp .net membership browsers computer crash Guy Burstein javascript link-o-rama LINQ office 2007 optimization outlook 2007 performance ScottGu SQL Server t-sql web servers workarounds xmlhttprequest

Archive for May, 2008

Maintenance Plans/Backup Jobs in SQL Server

Thursday, May 22nd, 2008

Nice little tutorial here:

Creating Backup Jobs in SQL Server 2005
SQL Server Tips: Shrinking Log

Will need to try.
Have gone a little crazy over current project–will be back during the next possible commercial break to blog about multiple results stored procedures and LINQ. Honest.

Click on pen to var showHover=true;

LINQ, Stored Procedures and Multiple Recordsets

Thursday, May 15th, 2008

Update: This post has a follow up here: LINQ, Stored Procedures and Multiple Recordsets: How-To
I wanted to use a LINQ with a stored procedure that would return multiple recordsets, like this:

CREATE PROCEDURE spReturnMultiple
AS
–first set
SELECT value1 FROM table1
–second set
SELECT t1.value1, t2.value2
FROM [...]

ScottGu – Da LINQ Man!

Thursday, May 15th, 2008

For my own reference, the various parts of ScottGu’s LINQ series:

Part 1: Introduction to LINQ to SQL
Part 2: Defining our Data Model Classes
Part 3: Querying our Database
Part 4: Updating our Database
Part 5: Binding UI using the ASP:LinqDataSource Control
Part 6: Retrieving Data Using Stored Procedures
Part 7: Updating our Database using Stored Procedures
Part 8: Executing Custom SQL [...]

SQL Server 2005’s Pivot…PIVOT, PIVVOOOOT – Ross Gellar, Friends

Friday, May 9th, 2008

Every time I see SQL Server’s 2005 PIVOT, I think of that episode of Friends where Ross tries to guide his friends as they bring up the couch to his apartment.

But serious, PIVOT is one of those things that I’m still trying to wrap my brain around.
I’m currently digesting this: Pivots with Dynamic Columns in [...]

Vroom, vrooom…. aka Making Pages Load Faster

Wednesday, May 7th, 2008

Optimizing Page Load Time [die.net]
Best Practicies for Speeding up your Web Site [Yahoo]
Interesting stuff, some excerpts for own reference below the more tag.

Click on pen to var showHover=true;