Welcome to AspAdvice Sign in | Join | Help

May 2006 - Posts

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:
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...
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...
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:
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:
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...
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:
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...
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:
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:
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:
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...
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:
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:
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:
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:
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...
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: