Welcome to AspAdvice Sign in | Join | Help

May 2006 - Posts

May BADNUG Cancelled

Posted Wednesday, May 31, 2006 2:38 PM by rjdudley
The May BADNUG meeting has been cancelled; Tony can't make it tonight. The next meeting is tentatively scheduled for June 22. Collect your favorite tips and trick for SQL Server 2000 or 2005 and be ready to share them. We'll demonstrate SQL Delta , Fuzzy Read More...
0 Comments
Filed under:

"Library Gluers" Are Having Fun, Too

Posted Wednesday, May 31, 2006 12:19 PM by rjdudley
In his " Passionate Programmers " post, Justin James makes a point I doubt anyone disagrees with--hire people who truly enjoy their job. That's not an idea exclusive to scientists or programmers--that's true in nearly every job, whether it's molecular Read More...
0 Comments

My Programming Mantra

Posted Tuesday, May 30, 2006 1:39 PM by rjdudley
I read a variety of technical blogs. Some are agile, some are pragmatic, while others are iffy, lazy, angry or corporate. Most of them have extensively documented approaches to programming, and zealots of each approach engange in long blog battles over Read More...
0 Comments
Filed under: ,

VS 2005 Speaks the Truth

Posted Tuesday, May 30, 2006 1:25 PM by rjdudley
When you have VS 2005 generate a strongly-typed dataset for you, it also adds some comments as to the date and time of generation, as well as who generated the code. Here's one line of these comments (you'll find this at the top of MyFile.Designer.vb Read More...
0 Comments
Filed under:

Stored Procedures Do Not Prevent SQL Injection

Posted Friday, May 26, 2006 9:33 AM by rjdudley
There's another sproc-or-not battle royale going on over at CodeBetter.com. Not going there, but one statement Eric Wise made isn't completely correct: First, you can be sure that no sql injection attacks will ever occur. That's part of a longer paragraph, Read More...
2 Comments
Filed under:

ASP.NET Control Gallery: Moved, not Deleted

Posted Wednesday, May 24, 2006 12:38 PM by rjdudley
The Control Gallery at ASP.NET still exists, it's just not on the menu anymore. It has been moved to the Resources Page , along with Hosts, Community Sites and Case Studies. VWDE, Starter Kits and The Sandbox are on the Downloads page. Alex Lowe has a Read More...
0 Comments

ASP Alliance Article: Getting Started with the Club Site Starter Kit

Posted Wednesday, May 24, 2006 11:27 AM by rjdudley
My latest ASP Alliance article has been published, titled Getting Started with the Club Site Starter Kit : Since the release of ASP.NET 2.0, several starter kits have been released as examples of programming practices. These kits are also good starting Read More...
0 Comments
Filed under:

Easily Create a Timestamped Filename in .NET

Posted Tuesday, May 23, 2006 3:17 PM by rjdudley
Eric says crazy filename parsing is something else you should stop doing . If you're creating output files, you probably need to timestamp the file name to keep the files separate. Step away from the keyboard before you do anything crazy--you can do this Read More...
1 Comments
Filed under:

Printing a Web Page as a PDF

Posted Tuesday, May 23, 2006 1:06 PM by rjdudley
Brendan Tompkins has a nice post on printing a web page as a PDF using webSuperGoo 's ABCPdf component. The example is written in C#, but shouldn't be too hard to translate. So what’s the solution to your website printing problems at least until you can Read More...
0 Comments
Filed under:

SQL Prompt Free until 9/1/2006!

Posted Monday, May 22, 2006 11:26 AM by rjdudley
At the last BADNUG meeting, someone mentioned they wished there was Intellisense for SQL Server. I said there was such a product; Red Gate recently purchased it, and is now giving it away until Sep. 1, 2006! Also included in the package is a 14-day trial Read More...
1 Comments
Filed under:

Treo 700w Users: Don't Automatically Upgrade SplashBlog

Posted Thursday, May 18, 2006 9:08 AM by rjdudley
If you use a Treo 700w and SplashBlog, don't perform their automatic upgrade. Their upgrader installs the wrong version of the software on your phone, and the client won't start. There are two versions for Windows Mobile devices, one for those without Read More...
2 Comments
Filed under:

Using Output Parameters With Enterprise Library 2.0

Posted Monday, May 15, 2006 9:25 PM by rjdudley
I couldn't find a quick example when I was looking for one, so here's mine. First, create your stored procedure with an output parameter: CREATE PROCEDURE [dbo].[MySproc] (@MyParameter varchar(50) OUTPUT) Then, add an output parameter to your database Read More...
1 Comments

Tracing Stored Procedures

Posted Thursday, May 11, 2006 1:53 PM by rjdudley
One of the great things about stored procedures is that you can put a whole bunch of different commands into one procedure, and call everything with a single command. Gnarly! However, if the procedureruns slowly, it's difficult to determine which command(s) Read More...
0 Comments
Filed under:

VS 2005 Projects and Solutions "Mess"

Posted Thursday, May 11, 2006 9:39 AM by rjdudley
I dislike how VS 2005 handles solutions, but I thought it was just me. Victor Garcia Aprea has a good commentary on the subject: Of course, I still think Visual Studio is totally messing up the Project and Solution terms, and that such core concepts should Read More...
0 Comments
Filed under:

Final Week to Sign Up for BITS 2006! (Edinboro, PA)

Posted Wednesday, May 10, 2006 1:32 PM by rjdudley
Hat tip: Pat Santry This is the final week to register for BITS in Edinboro, PA. There will be many presentations provided, here is an overview of the sessions: Keynote: Convergence and Cellular Data Don't Touch Any Switches: Leading IT for the Non-IT Read More...
0 Comments
Filed under:

Code Camp Pittsburgh Slides and Code Now Available

Posted Wednesday, May 10, 2006 1:21 PM by rjdudley
Get 'em while you can at http://www.pghtech.org/Networks/InformationSystems/dotnet.asp . Hat tip: Eric Kepes Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Sponsor Read More...
0 Comments
Filed under:

Monitoring DTS Packages

Posted Wednesday, May 10, 2006 9:00 AM by rjdudley
Part of my work involves a SQL Server 2000 data warehouse, updated nightly with extracts from an ERP system. I knew that the DTSs tended to run long, and I wanted to get a better idea of exactly how much data we were moving around. First thing I did was Read More...
0 Comments

Copying DTS Packages to a Different Server in SQL Server 2000

Posted Friday, May 05, 2006 10:39 AM by rjdudley
Freaky--we were just talking about this yesterday afternoon. The latest SQLServerCentral.com update came out today, and the lead story is an update to an older article titled " Copying DTS Packages to a Different Server ". The article has some code samples Read More...
0 Comments
Filed under: