Microsoft SQL Server has rapidly become the database of choice for a large number of prepackaged and custom-build business applications due to its robust feature
Lets dive into one of the amazing features of SQL Server regarding data protection and security. So far the data protection is mostly handled by
Taking database backup is a compulsory task if your data is critical. SQL Server backup and restore operations can take from few seconds to few
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.
Our consultant successfully conducted FS-2050A SQL Server Performance Tuning Course for IT Executives and DBAs.
Every company ranging from enterprise level to small-scale startups has money for Big Data. The storage and hardware costs have dramatically reduced over the past
One of the most important steps in working with Microsoft SQL Server data management is to understand what execution plans are, why execution plans are
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
Backup plan! The operation that is getting fade and fade among SQL Server DBAs due to other backup technologies such as SAN replication, VM replication and
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.
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 Vision® is an intelligent criminal and crime analytics and processing unit which is developed for preventing crimes through enterprise criminal detection and recognition platform by Fard Solutions Sdn. Bhd. Company. It provides capture and recognition of criminals and crimes from a video stream of every CCTV camera real-time. Fard Vision® is the only criminal and crime detection and recognition system in the universe yet.
In the previous blog post regarding SQL Server In-Memory Internals, I wrote an overview of how In-Memory OLTP engine controls the concurrency without acquiring Lock
SQL Server Optimizer is a software to check the specific SQL Server performance measures and on top of the findings it is able to generate TSQL codes for DBAs to review and execute the codes for having better performance.
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