April 2017
M T W T F S S
« May    
 12
3456789
10111213141516
17181920212223
24252627282930

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

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 [...]

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;

LINQ here, LINQ there, LINQ everywhere

Tuesday, April 22nd, 2008

According to DA GURU (that’s Scott Guthrie), on his article LINQ to SQL (Part 5 – Binding UI using the ASP:LinqDataSource Control)
We will also take advantage of the built-in paging/sorting support within LINQ to SQL to ensure that features like the product listing paging/sorting are performed not in the middle-tier, but rather in the [...]