Applicable on: SQL Server 2014, SQL Server 2016 What is In-Memory OLTP? New in SQL Server 2014, Microsoft added new feature called In-Memory OLTP which can significantly improve
Planning the hardware infrastructure for a OLAP or OLTP solution that is based on Microsoft SQL Server requires an understanding of how the various SQL Server components work
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
Organizations often store and manage data files on the file system of the server operating system. But organizations are increasingly moving to integrate data files
Hi dear all, hope you enjoy the last post about Sorting and Filtering Data. As you see below, transact-SQL (T-SQL) consists of several commands. One of
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
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
SQL server provides many built-in functions, ranging from those that perform data type conversion, to those that aggregate and analyze groups of rows. Functions built-into
The pain that organizations are experiencing around consistent reporting, regulatory compliance, strong interest in Service-Oriented Architecture (SOA), and Software as a Service (SaaS) has prompted
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
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
Most SQL Server DBAs believes that TempDB always recreated once SQL Server service is restarted and makes a clean copy of TempDB database. therefore, it
This post is an overview of Microsoft SQL Server. After reading this, you will know about basic architecture of SQL Server, SQL Server Management Studio
Write Ahead Logging To understand how the write-ahead log works, it is important for you to know how modified data is written to disk. SQL
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.