tag:blogger.com,1999:blog-7831239019943181022010-02-07T06:15:49.766-08:00ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.comBlogger67125tag:blogger.com,1999:blog-783123901994318102.post-37533578958093619772008-12-02T07:53:00.000-08:002008-12-02T08:06:55.662-08:00

You'll learn the following 5 tricks:1. Highlighting alternative rows / columns in tables:2. Creating a quick project plan / gantt chart using conditional formatting:3. Extreme In-cell Graphs:4. Highlight mistakes / errors / omissions / repetitions using conditional formatting:5. Creating dash boards using excel conditional formatting:You can read the details and download the formula file (Excel

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-14319850585527963382008-12-01T16:46:00.000-08:002008-12-01T16:50:02.950-08:00

http://digg.com/hardware/How_to_Recover_Data_From_a_Dead_Hard_Drivehttp://www.popularmechanics.com/technology/how_to/4294038.html

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-53594650094402334952008-10-17T12:15:00.000-07:002008-10-17T12:24:38.627-07:00

Installing AJAX for ASP.NET Framework 2.01. Download the AJAX Extension 1.0 and run the file (on the server).http://www.microsoft.com/Downloads/thankyou.aspx?familyId=ca9d90fa-e8c9-42e3-aa19-08e2c027f5d6&displayLang=enorhttp://www.microsoft.com/downloads/details.aspx?FamilyID=ca9d90fa-e8c9-42e3-aa19-08e2c027f5d6&displaylang=en2. Install the toolkit controls Version 1.0.11119.0 (for the

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-49659803126048022972008-10-17T12:11:00.000-07:002008-10-17T12:14:46.270-07:00

50 Excellent AJAX Tutorialshttp://www.smashingmagazine.com/2008/10/16/50-excellent-ajax-tutorials/

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-61480840770467412242008-10-17T12:09:00.000-07:002008-10-17T12:10:19.334-07:00

How To Create a Stunning Vista Inspired Menu (in Photoshop)http://psdtuts.com/interface-tutorials/how-to-create-a-stunning-vista-inspired-menu/

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-70055132933599410012008-10-17T12:05:00.000-07:002008-10-17T12:08:48.264-07:00

23 Most Incredible Photoshop Tutorialshttp://elitebydesign.com/23-most-incredible-photoshop-tutorials/

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-52863454012972749732008-10-02T13:43:00.000-07:002008-10-02T13:53:01.944-07:00

If you ever want to copy or move one of your SQL (2000) databases from the server you can do it in a number of different ways. One of them is simply copy the files to the new location like copy another other file. However, if you try to do that just like that then you will notice that the system won't allow you to do such thing. Don't worry all you have to do is detach and attach the databases.

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-56483930536352773712008-08-22T12:51:00.000-07:002008-08-22T13:07:56.108-07:00

Want to copy data from one column to another column in the same table with a simple SQL Script? Here is how:UPDATE TableName SET destColumn = sourceColumn;For example:UPDATE Demographics SET tempFirstName = firstName;This is useful if you want to simply backup a column and modify the existing column. For example if you have a column called dose with type decimal(4,1) but later decide to change it

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-79491116752188786812008-08-15T12:14:00.001-07:002008-12-17T07:42:10.465-08:00

SQL: ALTER TABLE StatementAdding a new field to a tableSyntax:ALTER TABLE tableNameADD columnName columndefinition;Example:ALTER TABLE medicationsADD insulin decimal(4,1);Removing a field from a tableSyntax:ALTER TABLE tableNameDROP COLUMN columnName;Example:ALTER TABLE medicationsDROP COLUMN insulin;Altering an existing field in a tableSyntax:ALTER TABLE tableNameALTER COLUMN columnName

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-34704286398739702272008-08-15T09:13:00.000-07:002008-08-15T09:26:16.432-07:00

Here is how to find the service pack version installed on SQL ServerSELECT @@VERSIONGOSELECT SERVERPROPERTY('ProductLevel')GOBesides using the @@version and serverproperty try these commands as well:sp_server_infomaster..xp_msverReferences:http://vyaskn.tripod.com/sqlsps.htmhttp://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-82978438104823662082008-06-27T11:08:00.000-07:002008-06-27T11:14:27.676-07:00

Microsoft Windows services, formerly known as NT services, enable you to create long-running executable applications that run in their own Windows sessions. These services can be automatically started when the computer boots, can be paused and restarted, and do not show any user interface. These features make services ideal for use on a server or whenever you need long-running functionality that

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-33130353556653726282008-06-19T12:28:00.000-07:002008-06-19T12:31:59.015-07:00

How to dynamically get new textboxes on a button click?You can find the answer/solution with an example here:http://forums.asp.net/p/1205279/2108767.aspx#2108767

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-85835117393803422442008-06-16T12:45:00.000-07:002008-06-16T12:58:52.471-07:00

To shrink the SQL transaction log do the following:First do a manual checkpoint to make sure point the T-log to the place where it would shrink then use the shrink command to shrink it. Here is how to do that:Step 1. In Query Analyzer type the following:Use YourDbNamegoCheckpointStep 2. In Query Analyzer type the following:DBCC SHRINKFILE('logfilename', 1)BACKUP LOG redeoba WITH TRUNCATE_ONLY

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-75846237372468690712008-06-16T12:41:00.000-07:002008-06-16T12:44:27.438-07:00

So what is the difference between Enabled and ReadOnly in ASP.NET?An explanation can be found here:http://scottonwriting.net/sowblog/posts/4965.aspx

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-63438971858750568342008-06-12T12:39:00.000-07:002008-06-12T12:42:57.082-07:00

If you want a more solid alert so that you make sure you don’t miss seeing an email arriving then you might consider a desktop (client-only) alert which we are going to show you in this article.I have been using this feature for over 2 years and I really enjoy it and benefit from it.Here are the steps to configure the desktop alert in MS Outlook 2003:1. Open Outlook and go to Tools > Rules and

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-40668310267829679932008-06-12T12:37:00.000-07:002008-06-12T12:39:38.986-07:00

You can use the following stored procedure to show you the size of your database:sp_helpdb 'NameOfYourDb'

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-1693339900871620212008-06-12T12:33:00.000-07:002008-06-12T12:37:35.415-07:00

You probably have heard of SQL injection attacks but do you know if ASP.NET is set for such security issues? Here is an article that will clarify things up for you:http://weblogs.asp.net/scottgu/archive/2006/09/30/Tip_2F00_Trick_3A00_-Guard-Against-SQL-Injection-Attacks.aspx

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-49712236363106066322008-06-11T11:48:00.000-07:002008-06-11T11:56:03.134-07:00

There are times when you want to check a value in the select statement and based on that display a different value. So you would need an IF statement which is a CASE statement in SQL. The CASE statement is in this format:CASEWHEN (Your condition here, for example userID > 200) THEN (do whatever)ELSE (do whatever)ENDHere is a real world example: say I have a field called phone and another field

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-30571297254009483532008-06-06T12:27:00.000-07:002008-12-02T08:09:15.749-08:00

Splitting your MS Office Access database into a front end and a backend is a good idea. Not only is it easy to maintain your application but also it is safer since this will avoid less corrupted data. It is highly recommended that you split your database this way especially if there are multiple users using your MS Access database application.Here is how to split your database:1. Open your .mdb

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-40474594182218503762008-05-30T09:29:00.000-07:002008-05-30T09:48:53.350-07:00

You know what a dropdown is on web pages. You know and use the ASP.NET’s DropDownList control for such drowdown lists. You probably have seen most of the dropdowns on the internet have a friendly text (or a blank) as the 1st item in the list.When you populate the DropDownList from a database such as using an SqlDataSource then whatever is in the database gets into the DropDownList. Now, what if

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com1tag:blogger.com,1999:blog-783123901994318102.post-56075032283294865822008-04-10T11:09:00.000-07:002008-04-10T11:43:07.240-07:00

Logging ASP.NET Errors Automatically (Global Exception Handling)When your web application goes live on the production server and people start using it you won’t know about the problems or errors that occur unless you are told somehow. You say the “user who saw the error will tell you”; I say in your dreams! The users will hardly ever tell you. So how do you fix or debug problems if you don’t know

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-12975480831168116982008-04-04T12:36:00.000-07:002008-04-04T12:42:19.603-07:00

A View in SQL is a virtual table that uses the result of a SELECT statement for its rows and columns. In other words the fields in a view are from real tables. You canCreating a ViewTo create a view first make your select statement as you want it and then add the following syntax to the beginning of the select statement:CREATE VIEW viewName ASFor Exampleyou can use the following SELECT statement

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-65805909920402661882008-04-03T11:01:00.000-07:002008-04-03T11:03:13.247-07:00

To password protect your Microsoft Excel file (.xls) follow these steps1. Open your Excel file either by double clicking on it or going to File > Open.2. Go to Tools > Options…3. Select the Security tab4. Provide a “Password to open” and if you like you can provide the same or another password to modify the file in the field “Password to modify”.That is all to it.

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-88820478026606495072008-04-03T07:58:00.000-07:002008-04-03T08:03:41.724-07:00

To password protect your Microsoft Access database file (.mdb) you need to open it for exclusive use first. Don’t worry to what that means, here are the steps.1. Open the Microsoft Access applicationIf you opened your database file (for example by double clicking on it) then close that and leave the Microsoft Access application open.2. Go to File > Open3. Browse to find your database file and

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0tag:blogger.com,1999:blog-783123901994318102.post-69233573315916908472008-03-25T10:41:00.000-07:002008-03-25T10:54:45.235-07:00

GUID (Global Unique Identifier) are used as PK (primary keys) when developers need a key that would be unique across multiple database servers. While the GUID has this benefit, there is a drawback to it. There is a performance drawback because of the size and non-sequentialness of the GUID. So what is the solution if you really need a GUID so to use a unique id accross multiple database servers?

ka-simhttp://www.blogger.com/profile/15126595204680636478noreply@blogger.com0