IT
Data Center
A Data Center is the primary container of inventory objects such as hosts and virtual machines. (from VMware’s perspective) From the datacenter, you can add and organize inventory objects. Typically, you can add hosts, folders and clusters to a datacenter vCenter Server can contain multiple datacenters. Large companies might use multiple datacenters to represent organizational …
Information Rights Management
To download, see Microsoft KB 979099 In Exchange 2010, IRM protection can be applied to messages using the following methods: Manually by Outlook users Your Outlook users can IRM-protect messages with the AD RMS rights policy templates available to them. This process uses the IRM functionality in Outlook, and not Exchange. However, you can use …
Router Passwords
http://www.routerpasswords.com/ This website is very useful to provide information for about default passwords used on routers, default web logins, CCTV systems and other electronic devices
SQL Server 2005 Backward Compatibility
This feature is installed automatically by the Microsoft SQL Server install for most editions of SQL Server, but is not included in the 32-bit install for SQL Server 2008 and above, so therefore only the x86 download is given. Automated installation of SQL Server 2005 Backward Compatibility is performed by Process Id 4IE and is …
Essential skills on T-SQL Programming
> Create Database Objects – CREATE/ALTER/DROP TABLE/COLUMN – Data Types (XML, DATETIME, SPATIAL, VARCHAR) – Constraints (Primary Key, Foreign Key, Unique, Check, Default) – Calculated Column – Views – Indexed Views (SCHEMABINDING, COUNT_BIG(*), CLUSTERED INDEX) – Stored Procedures, [link]. – DML Triggers (INSERTED, UPDATED, UPDATE function) vs CHECK Constraint – TRIGGER for VIEWS (INSTEAD OF) …
Move DB files to new location
In my opinion, we should perform database migration/movement programmatically in order to achieve an automated task, freeing up human resources from tedious tasks. SQL Server 1) ALTER DATABASE <dbname> SET SINGLE_USER WITH ROLLBACK IMMEDIATE; 2) ALTER DATABASE <dbname> SET OFFLINE; 3) ALTER DATABASE <dbname> MODIFY FILE 4) ( 5) Name = <dbname>_Data, 6) Filename …
Control calls with Asterisk
Asterisk is often described as a PBX in software – that is, a system for routing and connecting calls in a building or office. Asterisk’s developer prefer to describe it as ‘communication server’ since it’s the engine that powers a whole range of communication application including automated menus, call centres, conference bridges and voicemail servers. …
Ubuntu 11.04
Buntu in Bahasa means “a dead-end”, however Ubuntu is changing from time to time without any foreseeable ending. For years, Ubuntu has used a generally vanilla Gnome setup as its default desktop environment, but now the world’s most popular Linux distribution is doing something radical. Gone is the trusty old Gnome, and in is the …