Database optimization is the act of design and developing database systems to take maximum advantage of the resources available. For example, databases can be optimized to
Data warehousing is a technique and concept for gathering and centralizing data for reporting and analysis purposes. Although the data warehouse project is subjective case by
In this post we will discuss how to limit the number of rows in SELECT queries and control the order of results. Because of relational
Backup and restore plan! The operation that is getting fade and fade among SQL Server DBAs due to other backup technologies such as SAN replication, VM
Securing SQL Server is not completely done in the instance, there must be secure network environment to reduce or avoid attacks to the server. To
Functions are routines that consist of one or more Transact-SQL statements that you can use to encapsulate code for reuse. In this blog, you will
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.
Bursa Malaysia Berhad is an exchange holding company. It operates a fully integrated exchange, offering the complete range of exchange-related services including trading, clearing, settlement and depository services.
Taking regular database backup is important and most of DBAs are assigned to perform this task, but making sure the backup is restorable and entire
This blog post covers the details of physical cube processing and storage, including an explanation of the what, when, and why to use any of the three cube storage methods: MOLAP, HOLAP, or ROLAP. These storage-type acronyms stand for Multidimensional, Hybrid, or Relational OLAP.
StretchDB is a new feature of SQL Server 2016 to archive/migrate cold data from on-premise to Azure SQL Database. We as consultant put the following
Encrypting the database backups help to secure the data. Today, as we get closer and closer to cloud solutions including backup files, every day, backup
In relational database management systems (RDBMSs), user and system data is stored in tables. Each table consists of a set of rows that describe entities
SQL Server like any other application is using a specific process and threads, therefore the processor resource needs to be shared with fair amount of
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