A Leader Is …

A Leader Is …

• “A good leader is a person who takes a little more than his share of the blame and a little less than his share of the credit.” — John C. Maxwell
• “A leader is not an administrator who loves to run others, but someone who carries water for his people so that they can get on with their jobs.” — Robert Townsend
• “A leader’s role is to raise people’s aspirations for what they can become and to release their energies so they will try to get there.” — David R. Gergen
• “A leader is best when people barely know he exists, when his work is done, his aim fulfilled, they will say: we did it ourselves.” — Lao Tzu
• “A leader is one who sees more than others see, who sees farther than others see, and who sees before others see.” — Leroy Eimes

Quoted From http://sourcesofinsight.com

Excel 2003 Office File Validation (OFV) opens workbooks slower across the network

You can use the EnableOnLoad registry entry to configure how you want Excel to handle opening workbooks for the OFV. By default, the EnableOnLoad entry is not present in the Windows registry. To add the EnableOnLoad entry to the Windows registry, follow these steps:


1.Exit Excel.

2.Click Start, click Run, type regedit, and then click OK.

3.Locate and then click to select the following registry key:



HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\

4.After you select the key that is specified in step 3, point to New on the Edit menu, and then click Key.

5.Type Excel, and then press ENTER.

6.Select Excel, point to New on the Edit menu, and then click Key.

7.Type Security, and then press ENTER.

8.Select Security, point to New on the Edit menu, and then click Key.

9.Type FileValidation, and then press ENTER.

10.Select FileValidation, point to New on the Edit menu, and then click DWORD Value.

11.Type EnableOnLoad, and then press ENTER.

Note: The default value is 0 which disables the validation.

12.On the File menu, click Exit to quit Registry Editor.

To Create My Computer Shortcut When Deleted and on Classic view XP

Step 1.

Create New Shortcut

Step 2

Copy paste this line and paste on the location :

explorer ::{20D04FE0-3AEA-1069-A2D8-08002B30309D}

Click finish. The New My Computer Icon is created.

Apologize with Skill

“What do I say when it’s all over … And sorry seems to be the hardest word.” — Elton John

Mistakes happen.  People fall down.  What’s important is how you get back up.  This is really geared towards leaders and pro-active repair, but I think the frame below is useful in many everyday situations.  It’s powerful because you’re owning your mistake, you’re acknowledging it, and you’re finding a way forward.  What you resist persists, and dwelling doesn’t help.

In the book, Power Thinking: How the Way You Think Can Change the Way You Lead , John N. Mangieri, Ph.D., and Cathy Collins Block, Ph. D., write about proactively repairing when things go wrong, as a more effective way to think and act.

4 Steps to Practice Repair
Mangieri and Block share the following steps for proactive repair:

1. Find out what went wrong.
2. Apologize for negative outcomes that your decision or behavior caused.
3. Explain why you made the decision (or took the initial, ineffective action.)
4. State what you want to achieve in the future with a new decision or action.

I think an important addition is empathic listening — listen until the other person feels heard, and don’t get defensive.

When do you use these steps? According to Mangieri and Block, “as soon as a leader’s self-respect diminishes, indicating that a decision or behavior just enacted was not effective or proper.”

Mangieri and Block say that it’s about acknowledging what went wrong, and co-creating the future:

Repair occurs whenever it is necessary to enact a thoughtful action to remedy the damage or ill will that a past decision or action created.  Repair begins by acknowledging the negative consequence your actions caused (by saying, for example, “I am aware that my decision angered and frustrated many of you”).  Then you state that you want to avoid such detrimental effects in the future.  Openly ask for others to offer suggestions that can ensure that such decisions or action will not occur again, and state an action that you are going to take to ensure that it does not.

From what I’ve seen, even if you fumble with the words, if it’s from the heart, that’s what matters.

In the end, the most important thing is — it’s got to come from the right place.

Source from : http://sourcesofinsight.com/apologize-with-skill

Re-create the Show Desktop Icon

To re-create the Show desktop icon yourself, follow these steps:

1. Click Start, click Run, type notepad in the Open box, and then click OK.
2. Carefully copy and then paste the following text into the Notepad window:
   [Shell]
   Command=2
   IconFile=explorer.exe,3
   [Taskbar]
   Command=ToggleDesktop
3. On the File menu, click Save As, and then save the file to your desktop as "Show desktop.scf". The Show desktop icon is created on your desktop.
4. Click and then drag the Show desktop icon to your Quick Launch toolbar.

To Get User's IP Address ASP.Net C#

            // Get request.
     HttpRequest request = base.Request;

     // Get UserHostAddress property.
     string address = request.UserHostAddress;

Time Changes What’s Important

“The key is in not spending time, but in investing it.” — Stephen R. Covey  

One of the main reasons To Do lists, backlogs, and lists of all the things you need to get done rots over time is because time changes what’s important.

That’s a good thing.

Because time changes what’s important, it’s a do a reset and a re-think on what your next best thing to do is.  Before you just grab things from your lists or from your backlog, ask yourself a few questions:

1. Is this still relevant?
2. Is this still important?
3. Is this my next best thing to do?

This is a quick way to step back and take a look from the balcony.  By asking if this is still relevant or still important, you can let things slough off and free yourself up for doing stuff that matters.  Letting stuff slough off makes space for the great stuff.

By asking if this is your next best thing to do you’re asking a question about windows of opportunity.   It’s true that a stitch in time saves nine, and you really can miss the boat for some things.  By paying attention to your windows of opportunity, you can get time on your side.

Quoted from : http://sourcesofinsight.com

The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine?

The error occured in an asp.net application while trying to upload data from an excel file to a database.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Solution

Downladed the 2007 Office System Driver: Data Connectivity Components and installed on the hosted server and the issue was sorted.

The 2007 Office System Driver: Data Connectivity Components could be downlaoded from the following link http://www.microsoft.com/downloads/en/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

Google Changes Search Algorithm

Google Changes Search Algorithm

Unprotect a Protected Excel Workbook

To unprotect a protected workbook all you have to do is to run this macro on the protected workbook. It really worked on me.

Happy Endings !





Sub PasswordBreaker()
    'Breaks worksheet password protection.
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
        Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
        Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "One usable password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
            Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub

Recovering From A Suspect Database

Recovering From A Suspect Database


Tormented problem that occurred due to database showing as suspect could be recovered with a hope of luck. Various articles on the WWW depict the similar T-SQL queries to be run on the suspected database. Simply the suspected database could be restored with the latest backup available and could solve the issue in minutes. Worst case scenario you will not have a back up or the latest back up is taken after the database mode has already gone to suspect mode.


We really came across the worst case scenario to one of our most critical database. We purchased a software (recovery tool for sql server) which created scripts which could be executed to populate the tables and data from the suspected data backup. Believe me running them is a task.


Why this suspect mode in a database does occur?


Actually to our scenario we really could not find the real answer why. But we suspect to be the low disk space in the server.


During a WWW search I found these...


A database can be marked suspect for one of the following reasons (this is from SQL Server Books Online):

• If one or more database files are not available.

• If the entire database is not available.

• If one or more database files are corrupted.
• There is not enough space available for the SQL Server to recover the database during startup.

• Database cannot be opened due to inaccessible files or insufficient memory or disk space.

• Database files are being held by operating system, third party backup software etc.

• Unexpected SQL Server Shutdown, Power failure or a Hardware failure.

How you could recover?


Run this query


USE Master

GO


-- Determine the original database status



SELECT [Name], DBID, Status

FROM master.dbo.sysdatabases


GO


-- Enable system changes


sp_configure 'allow updates',1


GO

RECONFIGURE WITH OVERRIDE


GO


-- Update the database status


UPDATE master.dbo.sysdatabases


SET Status = 24


WHERE [Name] = 'YourDatabaseName'


GO


-- Disable system changes


sp_configure 'allow updates',0


GO


RECONFIGURE WITH OVERRIDE


GO


-- Determine the final database status


SELECT [Name], DBID, Status


FROM master.dbo.sysdatabases


GO


We ran this on on our suspect mode database. But there occcred a situation where it did not display any tables after some time. But mode of the database has been chaged from suspect mode. We did this several times. With some luck this would correct the problem. But to our scenario the recovered database could not be backed up. So what we did was made a DTS transfer to another database. And made a scripts of the sp’s, views, indexes and constraints and built up simultaneous database to bring back the database with the most current data.

Essential Things That One Should Know Of Window Phone 7

Much talk that was heard around the world the last couple of days came to a halt when the Windows Phone 7 was released on the 11th of November. Intresting topics was posted throug out the WWW. Some thing that captured my eyes is the article that i am going to post to readers.

Microsoft officially unveiled its new mobile operating system, Windows Phone 7, at a press event held on 11th October 2010 in New York City. CEO Steve Ballmer described the new line of Windows Phones as "different" and more modern, in both design and principles. With Windows Phone 7, the focus is on how "real people want to use their phones," he said.


Besides being different, a key point Microsoft needs to drive home if wanting to compete in a crowded mobile landscape, there was also a big focus on personalization. "We also wanted these to be wonderfully mine, or yours, or yours, or the next person. Here's my phone, the way I've made it wonderfully mine," explained Ballmer. "My photos, my email, my start screen, my activities, my world... and of course, my avatar."

The Software

Microsoft Corporate VP Joe Belifore described the phone's final software as an operating system that helps you get things done. "We wanted to figure out how to build a phone that simplifies the basics," he said.

One of the ways WP7 achieves this, explained Belifore, is through the use of something called Windows Phone Hubs. These live-updating tiles display on the Windows Phone 7 homescreen, alerting users to new text messages, missed calls, voicemails and more. But hubs can deliver non-phone related info too, like live Twitter and Facebook updates, Internet news and new photos uploaded by friends. One hub even connects the phone to Xbox LIVE, Microsoft's online service for its Xbox 360 gaming console.

The tiles can be moved around and deleted, so as to allow complete customization of the homescreen.

The Camera

Another major feature with the new mobile operating system is how the camera works. Instead of having to launch an app, WP7 users will just press a hardware-based camera button to snap a photo. Then from within the camera's onscreen interface, you can access the photo gallery and immediately upload those photos to the cloud.

Office Integration

Microsoft's Office software is deeply integrated into the new device. In the phone's mobile version of Outlook, viewing Office documents is supported right from within an email, as is standard on many of today's smartphones. But editing Office files is also supported, explained Belifore, which is more of a unique feature.

Outlook calendaring is available, including free/busy information and conflict detection, the ability to accept meeting requests on the device, different view options (e.g. "today's agenda") and a one-touch "I'll be late" button which signals to meeting attendees that you're behind schedule.

He also demonstrated how auto-correction works - instead of automatically changing a misspelled word, the OS offers suggestions for word correction to choose from.

Bing Onboard

Microsoft's Bing search engine, whose team recently gobbled up the group from Microsoft's Live Labs, creators of SeaDragon, Photosynth and data visualization technology Pivot, is also baked into WP7.

Addresses in emails or calendar invites take you to Bing Maps, which also includes the traditional mapping application features like search, walking and driving directions and more. It also offers street-level images, similar to Google's Street View, and real-time traffic updates.

The integrated Bing service itself provides Web search, voice search (via Microsoft's TellMe), instant answers (short answer search results for things like airline flight info, sports scores, etc.) and local search, the latter demonstrated by way of a search for a local restaurant and its related reviews and star ratings. From the reviews, another tap will dial the restaurant's phone number.

The Hubs

There are six Windows Phone Hubs that ship with the device, which you can think of as Microsoft's take on homescreen widgets: the People Hub, Pictures Hub, Music + Video Hub, Games Hub, Office Hub and the Marketplace.

The People Hub connects to social networking services like Facebook and Twitter, pulling in status updates from friends and providing contact info and phone numbers. Users can respond to updates, like sending a text message or commenting on a status update from here instead of launching an app.

The Pictures Hub displays photos from your friends, including those on Facebook. Here, users can share their own photos with friends or view and comment on friends' photos.

The Music + Video Hub connects with Microsoft's Zune service offering access to music, video, podcasts and FM Radio. The Hub supports both streaming and downloads.

In the Games Hub, users can customize their Xbox LIVE avatar, send and receive gaming invites to friends and, of course, play games on the phone. Games like The Sims 3 and Ilo and Milo were demonstrated. Other launch titles include Bejeweled, Uno, Game Chest (a collection of card and board games), CarenyVale: Showtime, Halo:Waypoint, Crackdown 2: Sunburst, Rocket Riot, and more.

Windows Phone 7 will connect to Xbox LIVE, allowing users to earn achievements on the phone and track their gamerscore.

The Office Hub offers mobile versions of Office applications including Microsoft Word Mobile, Excel Mobile, PowerPoint Mobile and OneNote Mobile. SharePoint Workspace Mobile 2010 allows business users to access their company's SharePoint workspaces from the device.

The Marketplace has its own Hub, where users can search and download new apps.

Third-party developers can also build their own Hubs using Microsoft's provided development tools.

Apps

During the today's demo, Belifore showed off some big-name apps including those from eBay, IMDB and AT&T's Uverse Mobile, a media app. More apps are showcased here including games, an official Twitter app and others. We're also aware of a Netflix app, Slacker radio app, a pre-loaded T-Mobile TV app on select devices and Fandango app. No word yet on the exact number of apps available at launch.

Copy & Paste

When Microsoft announced that copy & paste was not going to be initially available on the new phones, there was a big outcry. Today, Microsoft said that the feature would be available "in early 2011" via a software update.

The Hardware

Windows Phone 7, like Android, will ship on a variety of hardware devices from multiple manufacturers. There will be nine phones arriving by WP7's November U.S. launch date (WP 7 will debut in some European markets on Oct. 21, however). Devices from HTC, LG, Samsung and Dell will be available. The form factors will vary, with some phones offering keyboards, phones with very large screens and even a ruggedized device for heavy-duty users like the one from Dell.

For hardware specs and reviews, see Engadget.

Mobile Operators

Windows Phone 7 will arrive on 60 mobile operators worldwide in 30 countries including AT&T and T-Mobile in the U.S., Orange, SingTel, Telstra, Telus, Telefonica, Vodafone and more.

AT&T

President and CEO of AT&T Mobility and Consumer Markets Ralph de la Vega also spoke on stage at this morning's event. He said that the network, known best as the sole iPhone carrier in the U.S. was committed to offering customers a wide range of devices. Regarding WP7, he said AT&T "knew this was going to be a winner."

According to de la Vega, AT&T will launch three WP7 devices, the LG Quantum, featuring a full QWERTY keyboard for $199.99, the HTC Surround with 16 GB of onboard storage, 5 megapixel camera and two Dolby Surround Sound speakers, also $199.99 and finally, the Samsung Focus, with a super AMOLED screen, Snapdragon CPU and 8 GB of onboard storage, again for $199.99.

The Samsung will be available on November 8th, the others a "few weeks" later, but no specific launch date was given.

AT&T also announced Uverse Mobile for Windows Phone 7 customers, which will be available for a monthly fee.

Everyone at Microsoft Gets a Phone

Noted at the bottom of one of Microsoft's WP7 press releases is news of Microsoft's internal commitment to Windows Phone. "[Microsoft] has arranged for every full-time employee worldwide to be able to switch to the new phone as soon as it launches in their market," it says. While that's obviously great news for employees, it's also an indicator of how much Microsoft wants and needs the new OS to succeed. By offering everyone at the company a phone, Microsoft is, to some extent, making all employees accountable for the phone's future. "There's so much more of Microsoft we've got to bring out in the phone," says corporate vice president of Windows Phone engineering at Microsoft Terry Myerson. "We've got a lot of work to do."

Would Like to Ove One! 

Refered from  :   http://www.readwriteweb.com

SQL SERVER – How to change sa password

• Login into SQL Server using Windows Authentication.

• In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.

• Change the passwork and click ok. Now you have successfully changed the sa password.

• Make sure to restart the SQL Server and all its services and test new password by logging into system.

WMI: Initialization failure - SQL 2000

This was and serious error that occured in one of the database servers affecting the databases operations.The  error occured in the SQL Server Agent where it displays an error saying "WMI: Initialization failure" when the dependencies tab is clicked.
This wasted a lot of valuable time in seaching for an answer. Thought of posting as it would be important to anyone who comes accross this issue.

To overcome the following error you have to create this bat file and run it.

------------------------------------------------------------------------

 @echo on cd /d c:\temp if not exist %windir%\system32\wbem goto TryInstall cd /d %windir%\system32\wbem net stop winmgmt winmgmt /kill if exist Rep_bak rd Rep_bak /s /q rename Repository Rep_bak for %%i in (*.dll) do RegSvr32 -s %%i for %%i in (*.exe) do call :FixSrv %%i for %%i in (*.mof,*.mfl) do Mofcomp %%i net start winmgmt goto End :FixSrv if /I (%1) == (wbemcntl.exe) goto SkipSrv if /I (%1) == (wbemtest.exe) goto SkipSrv if /I (%1) == (mofcomp.exe) goto SkipSrv %1 /RegServer :SkipSrv goto End :TryInstall if not exist wmicore.exe goto End wmicore /s net start winmgmt :End

---------------------------------------------------------------------------------------------
Paste the above code on a note pad and save it as FIXWMI.CMD and run the error machine.

China launches Moon mission

News that struck me on BBC that Chinese are now on the invasion of the outer space. China was the third country to put a man in space. The start of China's space endeavors began in the space age too, on 8 October 1956, when it began its missile and rocket research. Now china has launched its lunar mission. We as Asians wish them all the success in the mission ahead.

Quoted …….

A Chinese rocket carrying a probe destined for the Moon has blasted into space.

A Long March 3C rocket with the Chang'e-2 probe took off from Xichang launch centre at about midday GMT.

The rocket will shoot the craft into the trans-lunar orbit, after which the satellite is expected to reach the Moon's orbit in about five days.

Chang'e-2 will be used to test key technologies and collect data for future landings.

China says it will send a rover on its next mission, and has ambitions to put humans on the surface of the Moon at some future date, also.

The Xinhua News Agency said Chang'e-2 would also circle just 15km above the Moon's surface in order to take photographs of possible landing sites of the future missions.

It is China's second lunar probe - the first was launched in 2007. It stayed in space for 16 months and was then intentionally crashed on to the Moon's surface.

China launched its first manned flight into low-Earth orbit in 2003; and two more followed, with the most recent one in 2008.

Quoted from BBC………..

http://www.bbc.co.uk/news/science-environment-11453384