Welcome to Sol 3 Sign in | Join | Help

ASPInsiders

Aggregation of ASPInsiders and Microsoft ASP.NET team member blogs.

Browse by Tags

All Tags » SQL   (RSS)
Try Windows Azure for Free
  Here’s a neat promotion for my readers in the U.S. If you’ve been wanting to try out Windows Azure and/or SQL Azure, but didn’t want to hassle with providing a credit card, here’s your chance. Through October 31st, 2010, the first 500 respondents Read More...
Upcoming Mid-Atlantic Events – August 30th, 2010
Here are the events listed in Community Megaphone for the next week (or so) for the Mid-Atlantic area, as well as webcasts of interest: PASS Performance VC Presents: Andy Warren - Introduction to SQL Server Statistics Tuesday, September 07, 2010 12:00 Read More...
Events This Week – August 23rd, 2010
Here are the events listed in Community Megaphone for the next week (or so) for the Mid-Atlantic area, as well as webcasts of interest…don’t miss yours truly, speaking at CapArea .NET UG in Vienna, VA tomorrow night on Visual Studio 2010: NOVA SQL User Read More...
Events This Week – August 16th, 2010
Here are the events listed in Community Megaphone for the next week (or so) for the Mid-Atlantic area, as well as webcasts of interest…this list includes events imported from the UGSS event calendar , and all events entered in Community Megaphone are Read More...
How to implement ISNULL(SUM(ColumnName),0) in Linq2SQL
I had a Linq2Sql statement like this: var q = from o in db.OrderItem                   where o.UserId == UserId                   Read More...
HOWTO: Update Records in a Database Table With Data From Another Table (MS SQL Server)
SQL's UPDATE statement makes it easy to update one or more records in a database table. The most common UPDATE statement pattern assigns static or parameterized values to one or more columns: UPDATE MyTable SET Column1 = Value1 , Column2 = Value2 , ... Read More...
Events This Week – July 12th, 2010
Here are the events listed in Community Megaphone for the next week (or so) for the Mid-Atlantic area, as well as webcasts of interest…this list includes events imported from the UGSS event calendar , and all events entered in Community Megaphone are Read More...
No-Install Databases in ASP.NET with SQL CE 4
When I asked whether Scott Guthrie might have something else up his sleeve after the announcement of IIS Express, I don’t think I quite expected another surprise this quickly. Today Scott has announced a new version of SQL Server Compact Edition which Read More...
Writing A Transact SQL (TSQL) Procedure For SQL Server 2008 To Delete Rows From Table Safely
In this post, we will show and explain a small TSQL Sql Server 2008 procedure that deletes all rows in a table that are older than some specified date.  That is, say the table has 10,000,000...

This site is a resource for asp.net web programming. It has examples by Peter Kellner of techniques for high performance programming
MSDN Roadshow in DC Today!
Just a quick reminder that today is one of the last opportunities to catch our MSDN Roadshow covering Windows Azure and SQL Azure. I will be in our Washington, DC (Chevy Chase) office with my counterpart David Isbitski , and we have lots of great information Read More...
Events this Week – March 22nd, 2010
Here are the events listed in Community Megaphone for the next week (or so) for the Mid-Atlantic area, as well as webcasts of interest…this list includes events imported from the UGSS event calendar , and all events entered in Community Megaphone are Read More...
Events This Week – January 25th, 2010
Here are the events listed in Community Megaphone for the next week (or so) for the Mid-Atlantic area, as well as webcasts of interest…this list includes events imported from the UGSS event calendar , and all events entered in Community Megaphone are Read More...
Sydney Architecture User Group – Next Meeting: Why Windows Azure is not just Generic Brand Web Hosting
The Sydney Architecture User Group is having its second meeting this month on Thursday, 26th November. Full details can be found on our new (but very simple) website located here ( http://thesaug.org ). You can subscribe to the monthly email and also Read More...
ISO 3166-1 Country Data SQL Script
I am creating a standard sign up form with one of the fields being a country drop down. So I created my Country database table and then needed to fill it with information. I found the ISO list of countries here , but then the issue was how to get that Read More...
Events this Week – September 28th, 2009
Here are the events listed in Community Megaphone for the next week (or so) for the Mid-Atlantic area, as well as webcasts of interest…this list includes events imported from the UGSS event calendar , and all events entered in Community Megaphone are Read More...
More Posts Next page »