Newsgator Go 2.2.7 download

August 30, 2009

Managing MSDE 2000 or SQL Server 2005 Express Edition using osql utility

August 24, 2009

Specify a Single Transact-SQL Statement

To run a Transact-SQL statement against the local default instance of MSDE 2000, type a command similar to this one

osql -E -q "Transact-SQL statement"

where

  • E uses Microsoft Windows NT authentication.
  • q runs the Transact-SQL statement but does not exit osql when the query completes.

To run the Transact-SQL statement and exit osql, use the -Q argument instead of -q.

To run a Transact-SQL statement against a non local default instance of MSDE 2000, type a command similar to this one

osql -Usa -PmyPassword -S .\MyMSDEInstance -q "Transact-SQL statement"

where

  • U uses SQL authentication.
  • P password for SQL account.
  • S non default instance.

Attach and detach MSDE databases

August 24, 2009

To detach a database directly from the command prompt:

osql -U sa -P MyPassword -S MSDEInstance -Q "sp_detach_db 'databasename'"

To detach a database from within MSDE:

osql -U sa -P MyPassword -S MSDEInstance
1> exec sp_detach_db 'databasename'
2> go

To attach a database directly from the command prompt:

osql -U sa -P MyPassword -S MSDEInstance -Q "sp_attach_db 'dbname', '$DBPATH\dbname.mdf', '$LOGPATH\dbname_log.LDF'"

To attach a database from within MSDE:

osql -U sa -P MyPassword -S MSDEInstance
1> exec sp_attach_db 'dbname', '$DBPATH\dbname.mdf', '$LOGPATH\dbanme_log.LDF'
2> go


Running SQL scripts in MSDE

August 24, 2009

OSQL -Usa -PmyPasword -S .\MSDEInstance -i myScript.sql

How to back up a Microsoft Data Engine database by using Transact-SQL…

 


Websense services start and stop sequence

August 20, 2009

Occasionally you may need to stop/start/restart the Websense components. E.g. if you edit any Websense *.ini files, you must stop and then restart services to implement any changes or backup Websense configuration files.

If you are stopping or starting multiple services, stop Policy Server last, and start it first.

For example:

Stop services in the following order:

  • Other Websense Services (DC Agent, Explorer Report Scheduler, Log Server, Real-Time Analyzer, Reporter Scheduler, Usage Monitor)
  • Network Agent (this service may be on a separate machine)
  • Filtering Service
  • User Service
  • Policy Server

Start services in the following order:

  • Policy Server
  • User Service
  • Filtering Service
  • Network Agent
  • Other Websense Services (DC Agent, Explorer Report Scheduler, Log Server, Real-Time Analyzer, Reporter Scheduler, Usage Monitor)

Websense KB: 2893


How to bypass “runonce” web page to save Internet Explorer 7 settings

August 15, 2009

After installing Internet Explorer 7 all users are supposed to save their settings, the IE automatically redirects the page to “http://go.microsoft.com/fwlink/?LinkId=74005” which redirects to “http://runonce.msn.com/runonce3.aspx” till the user saves the settings to set their preferences such as the default search engine, whether turn on automatic Phishing Filter, language settings and so on.

Follow steps below to disable auto-direct to this web page. Two values should be added/modified in the registry, so that IE 7 will go to the home page instead of the external link above:

  1. 1. Open the regedit.exe applet.
  2. Go to registry key: HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main]
  3. Right-click this key and select New -> DWORD Value.
  4. On the right pane, create the new value to RunOnceComplete.
  5. Right-click RunOnceComplete and click “Modify” and set the value data to 1.
  6. Repeat Step 3 to Step 5 to create/modify the value name RunOnceHasShown and set the value data to 1.
  7. Restart the IE 7 to see if it still visits the Save settings web site.

To make changs via .REG file, create and use the one below:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main]
"RunOnceComplete"=dword:00000001
"RunOnceHasShown"=dword:00000001

Note: IE7 will query the two values RunOnceComplete and RunOnceHasShown every time it starts. If these values have been set as depicted above, IE will visit the home page set in the IE control panel.

For terminal server, you can set a log-on script, so that these two values will be added and set automatically when users connect to the server.

Source…


Skype v4.1 application causes slow performance in Internet Explorer 8

August 15, 2009

If you are seeing slow performance within Internet Explorer 8 (opening new tabs, for example), after just recently installing the latest version of the Skype application (v4.1), the issue could be caused by the IE add-on that gets installed by the latest revision of the Skype software.

To resolve this issue quickly, please open Managed Add-Ons and disable the installed Skype IE add-on.

Instructions…


Update to Microsoft’s IE8 Tolerates Other Browsers

August 12, 2009

Microsoft has issued an update to Internet Explorer 8 that allows users to either keep an alternate browser as the default installation, or else choose to install IE8 as the default.

The reason? A more open Microsoft that is both losing market share to Mozilla’s Firefox and other browsers, as well as negotiating with European antitrust officials about provisions in its upcoming Windows 7 operating system.

The update has been rolled out as part of this week’s Patch Tuesday. “IE will never install, or become the default browser without your explicit consent,” stated Microsoft’s original corporate blog posting on July 16.

After installing Internet Explorer 8, users who already have a rival browser set as their default will be presented with a screen that asks, “Do you want to make Internet Explorer your default browser?” Those who have already set Internet Explorer as their default browser will not see this screen.

“This change applies not only to IE8 installations on Vista and XP, but also when those users with a non-IE default browser install Windows 7,” the Internet Explorer team mentioned on the blog. “We will make this change available in the next cumulative security update for Internet

In Europe, while Microsoft originally countered with plans to ship an EU-only version of its upcoming operating system without the browser (due antitrust regulators who argued that the inclusion of Internet Explorer 8 with Windows 7 represented a monopolistic violation), it now plans to issue the same version of Windows 7 to Europe that it will issue to the rest of the world.


Fun facts about Facebook

August 12, 2009

Having 250 million members, if Facebook was a country it would be the fourth country in the world measured on population size (US is third with 300 million, India and China are the numbers 2 and 1 with more than one billion people).

With 250 million active members, one out of approximately every six people who can be online is a member of Facebook.

Why should Facebook want to leave the traditional web? Because they can? Facebook has an immense userbase and this userbase contributes immense numbers of data (which can be information and knowledge) to the platform. Every day five billion minutes are spend on Facebook, every week one billion pieces of content are added and shared. Most of this content is not shared with the outside world, is not indexable by for example Google and is thus only available within the great wall of Facebook. So Facebook already left the Web by keeping most if its content inside its network.

Facebook does not need other sites on the Web, other sites need Facebook. Why would Facebook still hinder its members with the rather old-fashioned WorldWideWeb (which is slow, since you first have to resolve the URL into an IP address via DNS, then do the HTTP request to the web server, than receive the HTML and other files and than render the page) and why wouldn’t they introduce their own implementation (facebook:// instead of http://) which could do more than just the aforementioned process?

Facebook has the size to introduce its own browser-like platform, its own operating systems and perhaps even its own hardware line.

Facebook could disrupt the Web and create a new (proprietary?) standard on how the new Web could be. They can, because one out of every six people that is online, has a Facebook account. They can because they have got such immense amount of data and people who are spending so much time on it, people will miss it when it is gone.

Facebook can, however will they do it?

Read more…


Ibiza Tune of the Week #32

August 8, 2009

Jochen Miller, a past winner of the Dutch Mixing Championships at Dance Valley, where he had advantage over the rest for spinning three turntables, pulls out this amazing Summer Trance Anthem.