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 …
Mnemonics
The Greek Alphabet has 24 letters, and I come up with this mnemonics to make them easier to remember.
Easter is paganism?
Do you celebrate Easter? A good day to start writing a blog… Easter Sunday is the highlight of the Roman Catholic liturgical year when the resurrection of Jesus Christ is celebrated. The origins of Easter, however, reveal that it flows directly from ancient paganism. Shortly after the flood, Nimrod reestablished idolatry in the earth. After …
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 …
Microsoft Virtualization Tools and Websites
Microsoft has several website locations for finding information about their virtualization products and technologies depending on the type of virtualization we are looking for. The following Microsoft websites include general and technical virtualization information as well as information about Microsoft VDI, Microsoft Virtual PC, Microsoft Desktop Opimization Pack Main Virtualization www.microsoft.com/virtualization Technical …
RAID Configuration
RAID stands for Redundant Array of Independent Disks. RAID is a method of combining several hard drives into one unit. It offers fault tolerance and higher throughput levels than a single hard drive or group of independent hard drives. RAID levels 0,1, 10 and 5 are the most popular. RAID Calculator https://www.icc-usa.com/raid-calculator Parity is …
