Required Housekeeping on SQL Server after renaming the hostname

SQL Server 2008 – Server Name Change (compiled and written by Rinith)

It might cause serious impact for your business applications running on backend SQL server, if the SQL server hosted server has been renamed without doing a proper housekeeping on the SQL Server itself.

So, in other words, if windows admin changes the server name, the following changes needs to be carried out on a sql server 2005-2008 (tested ok):

 

Changed server name shows 'hrms-app2' so we need to make this effective on the SQL server as well.

1. Open SQL Server Management Studio and click New Query.

2. Type Select @@ServerName to verify that the server name is correct or incorrect. In this example, I changed the Windows 2003 from HRMS-APP1 to HRMS-APP2.

follow the steps:

3. Next, type sp_dropserver 'HRMS-APP1'

syntax:

sp_dropserver <old_name>  (old name is the name you get from the select @@servername)

GO

4. You are now ready to add the correct name by typing sp_addserver 'HRMS-APP2', local

syntax:

sp_addserver <new_name>, local

GO

if you just mention sp_addserver 'newservername' wont show the right result, though the command will executed properly.

Restart sql server and the sql server agent by opening a command prompt and type: net stop mssqlserver and then net start msssqlserver to stop and start the sql server agent, type net stop or start sqlserveragent.

you might see a message with status 'disconnected' when executing sql queries after the above net start commands.

just close the sql management studio and start again, should work

note: A reboot might be required based on various environmental factors like:

even after reconnecting sql server name not displayed properly.. or selecting the statement showed servername as null.

this might have caused coz we executed the command sp_addserver 'HRMS-APP2' instead of sp_addserver 'HRMS-APP2', local

Restart the SQL server services with the above commands (net start...) and then see if the new servername is displayed or not.

check and confirm the server name (Select @@ServerName ) after restarting the server.

tech ref

Outlook 2010: Display reminders from shared calendars by delegating permission

This might be very useful for the company secretary to get email notification to the inbox when a meeting is requested to his/ her Supervisor. Attendees may accept or reject the meeting, that's not our concern. Concern is - your secretary should receive the notification.

 

So it's pretty simple in Outlook 2010; all what you have to do is to delegate the permission to the person from the source email account by following the below displayed steps:

Click Account Settings – Select Delegate Access

Add the person with whom you have to give delegation to your Calendar or Emails or any other Task

Check delegate receives copies of meeting-related message sent to me. that's it.

 

Internet Explorer Stopped Working with the latest security patch update

It's quite nuisance in closing down your valuable time?? Yes, indeed when Internet Explorer stops functioning, just follow the steps:

Go to eventvwr.msc and check the application events for application error event id 1000. You might see faulting module names: here in this example I could see ie versus flash player errors.

Faulting module name: Flash32_11_4_402_278.ocx

This might have caused coz of improper upgrade of Flash from previous version to 11.5 beta from Adobe's website.

Try uninstalling Flash and reinstall it again

Use this uninstaller tool to uninstall Flash (uninstaller)

Refer Adobe Site

Delete files from the following path:

C:\Windows\SysWOW64\Macromed\Flash

 %appdata%\Adobe\Flash Player

 %appdata%\Macromedia\Flash Player

Click here to Install Falsh Player Again

Most often, IE stability issues are caused by an add-on. Try starting it without any add-ons and see if the problem persists:

Start -> All Programs -> Accessories -> System Tools -> Internet Explorer (No Add-ons)
If that method works, try opening IE using the standard shortcut and troubleshoot your add-ons by navigating to Tools -> Manage Add-ons and disabling them one at a time to narrow down which one is causing the problems.

If the problems still persist when you use Internet Explorer (No Add-ons), try performing an Internet Explorer RESET:

Tools -> Internet Options -> Advanced tab -> Reset Internet Explorer settings and click the Reset button.

TSIS unveils journal on the eve of Gandhi Jayanthi celebrations

TSIS had a wonderful and auspicious curtain raiser to bestow honours to the 'Little Scholars' and 'Teachers' on the eve of Gandhi Jayanthi celebrations. In tandem the multi-colored skit trickled down reminiscence of MK Gandhi's childhood to the Quit India movement before concluding with National Anthem.

Indian Embassy First Secretary Shri. P. S. Sasi Kumar unveiled the monthly journal 'In Touch'. Mr. Anand Victor, Principal of TSIS who addressed the parents is the first scholar of its kind who brings in structural changes to the students at TSIS. The Chief Guests, Board of Directors, Investors, and Parents amassed at TSIS premises applauded the outstanding event.

Download the first e-journal copy by clicking 'In Touch' image. Comments and feedbacks will be taken into consideration. 

Emerging TSIS opens with lucky 999 factor

The Scholars' International School (TSIS) opens here in Doha, State of Qatar. Based in Muaither (near to Aspire Park), TSIS is offering the Indian CBSE (Central Board of Secondary Education) curriculum. We are lucky that we are the 9th Indian School in Qatar emerging on the 9th Day of the month and on the 9th month of the year. Indeed a Lucky 999 day for TSIS..!

With a modest tuition fee we are providing quality and value added education. We have adapted the eCampus with the latest 'Learning Management System' an online portal which allows teacher to interact with parents for the academic improvement of the students. The teachers can transform their day-to-day activities, lesson plans, resource types, question bank, content filters, assignments and much more into the online portal. In addition to this we have class rooms equipped with latest Smartboards, LED TVs and latest cloud and virtual computer labs which will boost an extra height for students.

LMS is partnered with "ETH Research Lab", India spearheaded by renowned scientist Padmashri Dr. Vijay P Bhatkar, the Father of Indian Supercomputers and an acclaimed ICT leader, who is architecting the programs of ETH Research Lab.

The school is also offering coaching in spoken Arabic, public speaking along with theatre lessons at no extra cost. Fee structure

In the news

The Peninsula Qatar

Gulf-Times

Qatar Tribune: New Indian school to focus on students´ all-round growth

THE Scholars´ International School will focus on providing valueadded education and grooming the innate skills of the students, said Principal Anand Victor. Speaking at a press meet on Saturday, Victor said the school will start academic activities on Sunday "Scholars´ will integrate academic pursuits with cocurricular activities in order to create an environment that inspires a child to blossom to its ...

 

Qatar Tribune 6thSept

also watch

The logo launching video

and

TSIS Intro

Scan this QR Code to see this pages information on your mobile devices

Once in a Blue Moon in August

The term Blue Moon refers to the second full moon in a single calendar month. The first full moon was on 2nd Aug 2012 The second full moon will occur tomorrow the Friday, 31st Aug 2012, a rare spectrum happening once in 3 years. Doesn't mean the moon is blue it would be the normal FULL MOON. 

However, as per NASA's email alert I received earlier this morning I thought of writing it down here what I knew. It could be either Blue Full Moon or the normal lighter red Full Moon which occurs only once in a blue moon. 

With the caveat in mind, A True Blue-Moon can happen with a rare disaster. As a catastrophic result of forest fire or volcanic eruption which could throw plumes of smoke where the atmosphere could get more aerosols which scatters blue light can cause the Moon turn blue..   sounds absurd? This also can happen once in a blue moon, indeed..!

As a matter of scientific fact; the SKY remains blue and the RED BALL 'sun' spurns from yellow to red - The pattern of color spectrum and its scattering wavelengths forms so.

During sunrise and sunset Blue and associated spectrum of colors are scattered by the molecules in the atmosphere more than the visible red light which has a wavelength (lambda) of 650 nanometer.

So the lambda of colors and the aerosol scattering affect makes the natural formation of scenery..! its all about, 'once in a Blue Moon' twin sister of 'Harvest Moon' or the 'Wine Moon' AND cousins of 'Wolf Moon, 'Snow Moon', 'Worm Moon', 'Pink Moon', 'Flower Moon',  'Strawberry Moon', 'Buck Moon', 'Sturgeon Moon', 'Hunters Moon', 'Beaver Moon' and 'Cold Moon'.

Send me the pictures whoever grabs the best FULL MOON. Good Luck..!

Will Air-India recover its scorn and opprobrium with the arrival of Boeing 787 Dreamliner?

Let's hope Air-India's new Boeing 787 Dreamliner is the paradigm of a class airliner and an eye-opener for expats..! We have enough time to decide the fate of another 27 by 2016.

787 design highlights

Chak de Air-India

India's first 787 Dreamliner to arrive today