
What is SQL Server MCM, MCSM and MVP?
The good point of Microsoft is providing multi level certifications, I regularly speak at local SQL Server user group in Malaysia and few times happened
The good point of Microsoft is providing multi level certifications, I regularly speak at local SQL Server user group in Malaysia and few times happened
What is SQL Server Consolidation? You can simply assume that SQL Server databases in different instances from different servers come and reside together at one high performance
A subquery is a SELECT statement nested, or embedded, within another query. The nested query (subquery), is the inner query. The query containing the nested
Recently this issue happened once we upgraded a database from SQL Server 2005 to SQL Server 2014 to meet the compliance. Once the upgrading process
Data Deduplication feature is added on Windows Server 2012 to reduce the storage cost by replacing duplicate data chunks from files with some reparse pointers.
Obviously, sometimes your queries might run slower than usual or seem like they do not progress. Once we check the session requests, the result specifies
Gamuda Berhad is an engineering, property and infrastructure company based Malaysia. It is one of the largest Malaysian infrastructure companies and has undertaken various projects,
This class will give you a wealth of practical optimization techniques that you can put into production as soon as you return to work and we
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.
It is important to monitor SQL Server instances to identify potential problems early, and to help with ongoing planning. SQL Server includes built-in features that
Sometimes we are required to enable auditing because of many reasons such as monitoring the data modification, tracking the user activities through the system and
Problem As a database administrator one of your key roles is dealing with data corruption. In this article we will learn how to solve Transaction
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
To write effective queries in T-SQL, you should understand how SQL server stores different types of data. This is especially important if your queries not
The Evolution of the Microsoft Data Platform Before we get into SQL Server 2014 I want to start off by showing you how far the
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