Maintenance Plans/Backup Jobs in SQL Server
Thursday, May 22nd, 2008Nice 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, 2008Update: 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, 2008For 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, 2008Optimizing 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, 2008According 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 [...]
Use the Highlighter