Having almost 100% accurate of SQL Server inventory (license and installed instances) is very difficult to get, but not impossible. every IT team in organizations
This blog post is dedicated to database corruption prevention, recently I did a database corruption recovery for a client of mine which caused by having
SQL Server Analyzer’ to run remotely by client and at the last, client will email us the SSA generated file for further analysis by our expert consultants.
SQL Server provides several operators that act on sets with different effect on the input sets. Common features that need to know before using set
If SQL Server Enterprise Edition is Expensive, What about Other Editions!
The idea of writing this blog post came to my mind, once one of our clients was insist and determine that Non-Clustered index gets update
Providing enough memory to SQL Server is very tricky and most DBAs do not know how much memory is needed, then the gradually add on
Microsoft introduced In-Memory OLTP technology for SQL Server in version 2014, I would not explain about this technology, you may visit our other blog post
SQL Server 2008 introduced Policy Based Management feature to ease the managing and monitoring SQL Server instances. The Policy-Based Management feature assists you to monitor
In most advance and complex databases, developers and DBAs faces double hop security issue, which usually DBAs granting the permissions to resolve the issue but
Sometimes it is required to return stored data in databases as XML documents. Usually, these requirements are relating to exchange data with other systems. By
Microsoft SQL Server is a Relational Database Management System (RDBMS) that contains few components and subcomponent. Each component in SQL Server has its own security
You might think why Pig is related to SQL Server, at first glance it might not be related but as we know that SQL Server
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
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
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