In SQL Server environments, when user wants to retrieve data from multiple tables needs to make join between those tables based on date relationship between
Allianz General Insurance Company had few physical servers for every individual systems which each server uses SQL Server 2005 & 2008. We introduced by Microsoft Malaysia to Allianz for accomplishing this project and at same time we guided Allianz to purchase suitable SQL Server license for their business.
In last article “In-Memory OLTP Introduction” we discussed what is in-memory OLTP and how it works. We also got to know memory-optimized tables and natively
Our professional trainer conducted this course for 6 days to 37 participants from United States of America, India, Singapore and Malaysia.
SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more
Powershell is a new modular command-line tool from Microsoft, by using this tool you are able to perform whatever you can do by GUI. most
The common language runtime (CLR) is the heart of the Microsoft .NET Framework and provides the execution environment for all .NET Framework code. Code that
The production environment is SQL Server Active-Passive Failover Cluster, our team managed to migrate SQL Server Reporting Services databases and instances into the current production
A stored procedure is a named collection of Transact-SQL statements that is stored on the server within the database itself. A stored procedure could be
Big Data World Show Malaysia 2014 will be launched on September 9 – 10! The event is recognized as a prestigious platform in the industry with the largest scale, most professional attendees, richest content, most advanced experience and most senior speakers in Asia-Pacific region and around the world.
A database that is not maintained can become sluggish, and cause problems with everyday use. Database backups, data recovery, solution clean up, and database optimization are services
Database page level corruption in SQL Server is the worst trouble that any SQL Server professional can face. In any environment, either small or enterprise,
An index is a collection of pages associated with a table. Indexes are used to improve the performance of queries or enforce uniqueness. You can
Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with
Data manipulation language (DML) triggers are a powerful tool that enables you to enforce domain, entity, and referential data integrity and business logic. The enforcement
Fard Solutions Sdn. Bhd. Company was established in 2012 in Kuala Lumpur. We are engaged in development, implementation, integration and maintenance of the most advanced database solutions and IT research & development (innovation).
Fard Solutions Sdn. Bhd. Company was established in 2012 in Kuala Lumpur. We are engaged in development, implementation, integration and maintenance of the most advanced database solutions and IT research & development (innovation).
Fard Technology Corp.
700-1199 West Hastings Street,
Vancouver, British Colombia,
V6E 3T5 Canada.
Fard Solutions Sdn. Bhd.
1-1C & 1-2C Incubator 1,
Technology Park Malaysia,
Bukit Jalil, 57000
Kuala Lumpur, Malaysia.
Join Our SQL Server E-Newsletter
Signup today for free and be the first to get notified on new updates