Monthly Archives: July 2008

Cool Tools and Tips

Posted on July 29, 2008 by bardev

Every time I rebuild my computer I can never remember the tools that I installed and the custom changes i make to the environemnt.  Also I added a few links to others who have similar lists.     Scott Hanselman’s 2007 Ultimate … Continue reading →

Posted in Uncategorized | Leave a comment

ASP.NET Debugging Stop Unexpectedly

Posted on July 29, 2008 by bardev

My environment: Visual Studio 2008 (VS.NET), Vista, IIS7, ASP.NET.  I have a situation when I’m debugging ASP.NET and after about 90 seconds of stepping through code the debugger suddenly stops and detaches.   Based on info from others, it seems that … Continue reading →

Posted in ASP.NET | Leave a comment

Page.ResolveUrl(“~/ClientScripts/Validation.js”) – Web Application Root Operator

Posted on July 28, 2008 by bardev

I have the situation where I need to load a JavaScript dynamically.  All the JS files are in the ClientScript directory (http://www.somewebsite.com/ClientScripts/Validation.js).  The ASPX page that references the client scripts could be anywhere, multiple folders (directories) down in the site … Continue reading →

Posted in ASP.NET | Leave a comment

ASP.NET AJAX WebServices and ScriptServices

Posted on July 25, 2008 by bardev

I’ve been working with ASP.NET AJAX for the past week and the following resources allowed me to get up to speed pretty fast.  The following two books that I list are pretty good.   Both of the them cover some different … Continue reading →

Posted in AJAX, ASP.NET, C# | Leave a comment

AJAX and JavaScript in ASP.NET & Visual Studio 2008

Posted on July 22, 2008 by bardev

I have once again started working with AJAX.  About 8 months ago I was pretty deep into ASP.NET and AJAX, but since then I’ve done little with AJAX.  I’ve been finding many good reference for AJAX and do not have a common … Continue reading →

Posted in AJAX | 1 Comment

When Leaving Page, Prompt The User That Changes Have Not Been Saved

Posted on July 21, 2008 by bardev

I’m in the process of create a few input forms in ASP.NET (Name, address, and etc).  If the user makes a change to the page and tries to navigate away from the current page without previously clicking save, the current … Continue reading →

Posted in JavaScript | Leave a comment

SQL Server Searching Object Text

Posted on July 16, 2008 by bardev

I had a situation where soft deletes were going to be implemented in the database, but for the past year hard deleted were being implemented.   On every table the IsDeleted column was created.  The newer Stored Procedures, Views, and Functions … Continue reading →

Posted in SQL Server | Leave a comment

SQL Server Custom Shortcuts

Posted on July 9, 2008 by bardev

Querying the INFORMATION_SCHEMA  (But has info about SQL Server Shortcuts) This is where I originally found info about SQL Server shortcuts. http://www.sqlservercentral.com/articles/INFORMATION_SCHEMA/61983/   Assigning shortcuts to commonly run tasks in SQL Server 2005 Management Studio http://www.mssqltips.com/tip.asp?tip=1287   SELECT * FROM, … Continue reading →

Posted in SQL Server | Leave a comment

SQL Server For Each Procedure

Posted on July 8, 2008 by bardev

I created my sp_ForEachProcedure base on Microsoft undocumented sp_msForEachTable.  It doesn’t have all the features of sp_msForEachTable, but does include a few of them.  I even added a few custom parameters (@print, @execute).   I did dynamic SQL because I was … Continue reading →

Posted in Uncategorized | Leave a comment

SQL Server System Tables and View

Posted on July 8, 2008 by bardev

SQL Server 2005 System Views Map http://cid-98b982e83e8a47af.skydrive.live.com/embedrowdetail.aspx/Public/Blog/SQL2005|_Sys|_Views.pdf (Source: http://www.microsoft.com/downloads/details.aspx?FamilyID=2ec9e842-40be-4321-9b56-92fd3860fb32&displaylang=en)  

Posted in SQL Server | Leave a comment