Cool!! Try this..

I thought of sharing this nice little piece of JavaScript snippet to show you what you can do in Google. I don’t know who wrote this but really cool. Ok. Follow the following steps to try out:
1. Go to Google – (just in case you never use Google before. haha).
2. Click on the "Images" hyperlink located at the top left corner.
3. Type "flowers" or any other word of your choice whose images you like to hijack (joking.. :-)) and click "Search Images".
4. You’ll then see a page which consists of the images that you searched for in step 3.
5. Delete the URL from the address bar and paste the following snippet
javascript:R=0; x1=.1; y1=.05; x2=.25; y2=.24; x3=1.6; y3=.24; x4=300; y4=200; x5=300; y5=200; DI=document.images ; DIL=DI.length; function A(){for(i=0; i<DIL; i++){DIS=DI[ i ].style; DIS.position=’absolute’; DIS.left=Math.sin(R*x1+i*x2+x3)*x4+x5;*y1+i*y2+y3)*y4+y5}R++}setInterval(‘A()’,5); void(0)
6. Deng deng deng!! See the magic!!!.

Regression Tool in Excel 2003 and 2007

Last few days I was working on a research paper for my studies, I need to do linear regression to evaluate my technique. I was exploring several tools before deciding on using Excel. Excel provides a wonderful add-ins called Analysis Toolpack which allows you to do statistical calculations. The Regression tool is included in the Analysis ToolPak. The Analysis ToolPak is an Excel add-in program. It is available when you install Microsoft Office or Excel. Before you use the Regression tool in Excel, you have to load the Analysis ToolPak.
To do this in Excel 2007, follow these steps:
. Click the Microsoft Office Button, and then click Excel Options.
. Click Add-Ins, and then select Excel Add-ins in the Manage box.
. Click Go.
. In the Add-Ins available box, click to select the Analysis ToolPak check box, and then click OK.
Note: If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.
To do this in Excel 2003 and in earlier versions of Excel, follow these steps:
. On the Tools menu, click Add-Ins.
. In the Add-Ins box, click to select the Analysis ToolPak, and then click OK,
Note: If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

SQL Server 2005 SP3 Now Available for Download

Finally, you can now download SQL Server 2005 SP3 for
. Enterprise
. Enterprise Evaluation
. Developer
. Standard
. Workgroup
from SP3 contains all the cumulative updates for SQL Server 2005, and fixes to issues that have been reported through Microsoft’s customer feedback platform. These include supportability enhancements and issues that have been reported through Windows Error Reporting.
The following components have new or improved features:
. Database Engine
. Notification Services
. Replication
. Reporting Services

Documenting your SQL Server

Maintaining documentation about your SQL Server databases is a big task.  No matter how many developers or administrators you may have, keeping documentation current is a challenge.  In most cases you only need view a portion of the database defined in an easy to view format, but if this is something you don’t keep up with on a constant basis your efforts will never yield up to the minute documentation.  In addition, SQL Server stores all kinds of meta data about your database objects, so it makes sense to utilize this data since it is easily accessible.  You could take the time to right queries and reports, but why bother when there are so many documentation products already available.

Today I did a survey on different SQL Server documentation tools.I have discovered that most of these tools allow you to document your database from top to bottom in various formats such as CHM, HTML, XML, and PDF. The following are my findings:

Database Documentation

    * ApexSQL Doc
    * BI Documenter
    * DTM Schema Reporter
    * Database Documenter
    * dbdesc
    * DBScribe 1.1 for SQL Server
    * Document! X
    * Red-Gate’s SQL Doc
    * SchemaToDoc
    * SqlRaptor
    * SqlSpec
    * SQL Server Documentation Builder / SQL Scribe
    * SQL Documentation Tool
    * SQL Help Builder

Analysis Services Documentation

    * BI Documenter

Reporting Services Documentation

    * BI Documenter

Integration Services Documentation

    * BI Documenter
    * SSIS Documenter

DTS Documentation

    * dtsdoc
    * DTS Documenter

Of all the tools, I would highly recommend BI Documenter which is so far the best SQL Server documentation tool that I have discovered till now.

Subversion: Common Version Control Operations in Visual Studio 2008

Recently, I have introduced to a few of my friends which are ISV business owners Subversion. We were discussing the vulnerabities of other software which we have experienced. I thought would be worthwhile that I summarize commonly asked questions on version control operations especially if you are moving from one product to another product in this blog entry. 🙂
Lock an item
When you need to be the only user able to edit and commit changes to an item, you can use the Lock option. Examples of such situations are when you are working on files whose changes cannot be merged, such as graphics or binary files. Until you release the lock, other users will be blocked from committing their changes to that item.
1. In the Solution Explorer, right-click a file and select Subversion > Lock.
2. In the Lock window, enter your reason for locking the file.
3. Click OK.
NOTE: When the operation completes, you will see a "lock" icon next to the item in the Solution Explorer. When you commit your changes to a locked item, the lock is released. If you want to retain the lock, select the Keep locks option while committing it.
Unlock an item
To allow other users to edit and commit changes to an item that you have locked, use the Unlock option and release the lock. When you commit a locked item, usually the lock is released. However, if you had selected the Keep locks option while committing it, the lock does not get released. In that case, you need to manually unlock the item.
1. In the Solution Explorer, right-click a locked item and select Subversion > Unlock.
NOTE: When the operation completes, the "lock" icon next to the item is removed.
Undo changes
To undo all your local changes to an item since the last update, use the Revert option. This operation does not affect any changes that you have already committed. It only reverts your local changes, and restores the item to the version to which it was last updated. To undo all changes up to a specific revision, you need to use the Revert to Revision option.
1. In the Solution Explorer, right-click an item and select Revert. The Revert window displays a list of all the items you changed locally since your last update.
2. In the Select items to revert window, check the required items.
3. Click OK.
Note: Since you cannot undo a revert operation, you might consider backing up your local changes before reverting them.
Compare revisions
To compare different revisions of a project file or folder, use the Diff option.
1. In the Solution Explorer, right-click a projet file or folder and select Subversion > Diff.
2. In the Select items for diffing window, select the revisions you want to compare. For example, select the head and previous revisions to compare the latest revision with the previous one. To compare versions of the file or folder as it existed on different dates, select the Date option for the "start" and "end" revisions and specify the corresponding dates.
3. Click OK. By default, the differences are displayed in a Unified Diff format. You may find it helpful to check them before you commit your changes.
Revert an item to a specific revision
To revert an item to a specific version, use the Revert to revision option.
1. To revert only your local changes since the item was last updated, use the Revert option.
In the Solution Explorer, right-click an item and select Subversion > Revert to revision.
2. In the Reverse Merge window, select the revison you want to revert to.
3. Click Merge.
Find out who made what changes to a line
When you need to know what changes were made to a specific line in a file, as well as who made them, you can use the blame option.
1. In the Solution Explorer, right-click an item and select Subversion > Blame.
2. In the Blame window, the item appears selected. Specify its start and end revisions within which you want to view the changes.
3. Click OK.

Configuring SQL Server 2008 after installing SQL Server 2008

Recently, a few of my customers complaint to me the they couldn’t find the Surface Area Configuration anymore in SQL Server 2008. You should be using the SQL Server Configuration Manager in SQL Server 2008. SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers. SQL Server Configuration Manager can be used to start, stop, pause, resume, or configure services on another computer.

SQL Server Configuration Manager and SQL Server Management Studio use Window Management Instrumentation (WMI) to view and change some server settings. WMI provides a unified way for interfacing with the API calls that manage the registry operations requested by the SQL Server tools and to provide enhanced control and manipulation over the selected SQL services of the SQL Server Configuration Manager snap-in component.

To open the SQL Server Configuration Manager
1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.

To configure a service to start automatically
1. In SQL Server Configuration Manager, expand SQL Server Services.
2. In the details pane, right-click one of the SQL Server services, and then click Properties.
3. In the Properties dialog box, set Start Mode to Automatic.

To configure the Database Engine to accept remote connections
1. In SQL Server Configuration Manager, expand SQL Server Network Configuration, and then click Protocols for <instancename>.
2. In the details pane, right-click one of the available protocols, and then click Properties.
3. To enable a protocol for remote connections, set the Enabled box to Yes.