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
Except of row-by-row queries, you may need to summarize data to analyze it. Microsoft SQL Server provides built-in functions that can aggregate, and summarize information
SQL Server Query Execution Overview The database component of Microsoft SQL Server is a Structured Query Language (SQL)–based, scalable, relational database with integrated Extensible
This class will give you a wealth of practical corruption recovery techniques that you can put into production as soon as you return to work and
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
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
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
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.
Jan 27, 2016 Feb 25, 2016 March 24, 2016
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
Taking SQL Server database backup takes very long time to accomplished on database in production servers. Most DBAs complain about the backup performance, therefore I
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
To successfully implement high availability for on-premises implementations of SQL Server, you need to understand the difference between high availability and disaster recovery, and how
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
One of the most important role of database administrators is working with Microsoft SQL Server to manage database and storage. It is important to know
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