Welcome to AspAdvice Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)

Orcas, Longhorn Launch Date Announced

Posted Thursday, July 19, 2007 3:07 PM by rjdudley
Mark your calendars--the launch date for Visual Studio 2008 (Orcas), SQL Server 2008 and Windows Server 2008 (Longhorn) has been announced. February 27, 2008. In LA, but expect regional events as well, probably filled with free goodies as before. More Read More...
0 Comments

SQL Prompt 3 Approaches, Pre-Order for $99

Posted Thursday, August 17, 2006 12:56 PM by rjdudley
Until September 1, the current version of SQL Prompt is free. The next version (v3) is now scheduled for release September 28th. The price for v3 will be $195, BUT, you can get a pre-order discount price of $99. You must order before v3 is released ("no 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:

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:

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:

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:

VistaDB 2.1 Released with .NET/VS 2005 Support

Posted Friday, November 04, 2005 9:54 AM by rjdudley
I have been wanting to mess around with VistaDB for a couple of projects, and have been waiting for all the .NET 2.0 associated releases. I liked some of what SQL Express had to offer (Eric Kepes gave a great presnetation at BADNUG not too long ago), Read More...
0 Comments
Filed under:

Is Dynamic SQL in Your Stored Procedures Vulnerable to SQL Injection?

Posted Thursday, June 30, 2005 11:30 PM by rjdudley
We all should be familiar with the fact that concatenating user input directly into SQL statements is an open invitation to an SQL Injection attack. Code such as MySql = "Select * from Orders where Customer ID='" & txtCustomerId & "'" should be avoided. Read More...
1 Comments
Filed under: ,

Incorrect syntax near '.'

Posted Wednesday, May 04, 2005 3:14 PM by rjdudley
We're working on tuning some index rebuilds, and I found a great DBCC INDEXDEFRAG Stored Procedure from Tara Duggan that's a great help. I modified the sproc to use the DBCC DBREINDEX statement. Part of the plan is to store this sproc in a control database, Read More...
0 Comments
Filed under: