Categories

A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

Backup IIS7 ApplicationHost.config and Settings

\r\n

Internet Information Services 7 (IIS7) doesn’t use metabase-like file from IIS6. Instead the settings and configuration are stored in schema files and applicationHost.config files.\r\n\r\nSince the configuration files are different, the old IIS6 tools will not be able to backup IIS7 settings.\r\n\r\nThis is the new script that you can use to backup your IIS7 web […]

How to change SQL Server database collation

\r\n

\r\n

\r\n\r\nIf you tried changing collation to from English to Turkish or other using the script as below but it will fail due to dependencies issues, You have to script them, drop them, change db collation and recreate them from script.\r\n\r\nThe Collation change script:\r\n

\r\n

Code:

\r\n

ALTER DATABASE {your database} SET SINGLE_USER WITH […]

Recover SQL Server Database from Suspect Mode

To recover database from suspect mode in SQL Server 2005 / 2008 use this script in MS SQL Server management Studio:\r\n\r\nEXEC sp_resetstatus ‘yourDBname’;\r\nALTER DATABASE yourDBname SET EMERGENCY\r\nDBCC checkdb(‘yourDBname’)\r\nALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE\r\nDBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS)\r\nALTER DATABASE yourDBname SET MULTI_USER\r\n\r\nNote: change ‘yourDBname’ with database name you want to recover from suspect mode.

Arabic Language Shows ??? in Smartermail Web interface

\r\n

Problem: When someone send email through smartermail web interface anything with Arabic Language shows ????. Is this SM related or something we need to set server side?\r\n\r\nSolution: This can be controlled at the User’s Inbox through Settings > My Settings > Account Settings >> Compose. Set the Text Encoding to “Unicode (UTF-8)” (“Arabic (ISO)” […]

How to enable Full text search in SQL Server 2008

In this article we will describe to create Full text search in SQL Server 2008 through SQL Server management studio. To create a full-text catalog:\r\n

\r\n

Launch SQL Server management studio 2008

\r\n

Connect to SQL Server

\r\n

In Object Explorer, expand the server, expand Databases, and expand the database in which […]

Rhythmbox – A Tool to Sync Android Smartphones Using Linux

Interest levels in synchronize music collections have notched up a bit of late with the introduction of a plethora of new Android-based super phones. That is, unless you happen to be one of those owners with a large quantity of digital music encumbered by digital rights management (DRM) also known as copy protection. For this […]

Mono 2.8 is Released.

The Mono developers have released Mono 2.8, a major update to the implementation of Microsoft’s .NET technology for Linux and other platforms. Miguel de Icaza, project lead, said in his blog that the release “contains ten months worth of new features, stability fixes, performance work and bug fixes”. The Mono C# compiler is now a complete implementation of the C# 4.0 specification and defaults to operating as a 4.0 based platform.\r\n\r\nA new Generational GC (Garbage collector) offers better performance for applications which consume and reuse large amounts of memory; benchmarkingshows CPU use is now much more predictable. Support for LLVM has now been marked as stable with a mono-llvm command allowing server applications to run with an LLVM back end, potentially offering greater performance; JIT compilation with LLVM is described as “very slow” in the release notes and therefore only currently suits long-lived server processes. […]