SQL Server Advance Corruption Recovery

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 we ensure you understand *why* and *how* a technique works rather than just what the technique is. This usually means we will explain how SQL Server works internally while discussing […]

PowerBI Workshop

Training Summary: Fard Solutions Consulting understands our client busy schedules that do not allow for prolonged travel to a distant training facility. For this matter we created In-House training whereby our trainer will personally conduct the training in clients’ office. Our training classes can accommodate classroom sizes from up to twenty five(25), but we have […]

SQL Server Performance Tuning Training Course (FS-2050A)

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 ensure you understand *why* and *how* a technique works rather than just what the technique is. This usually means we will explain how SQL Server works internally while discussing a […]

We are the ideal choice for
organizations seeking uncompromissing service quality.

Our Recognitions

Know our Happy Clients and Partners

Latest News and Articles

Find Out Whats Going On

Relational Databases vs. Hadoop

Posted on September 1, 2018
Big Data is a common buzzword in the world of IT nowadays, and it is important to understand what the term means: Big Data describes the realization of greater business intelligence by storing, processing, and analyzing data that was previously ignored or siloed due to the limitations of traditional data management technologies. Notice from this definition […]
Read More

Introduction to Views

Posted on April 24, 2018
A view is a named SELECT query. Unlike ordinary tables, a view is not part of the physical schema; it is a dynamic, virtual table that collect data from base tables (or views). Effective use of views in database design helps improve performance and manageability. The data that is accessible through a view is not […]
Read More

Create Table By T-SQL

Posted on April 17, 2018
In relational database management systems (RDBMSs), user and system data is stored in tables. Each table consists of a set of rows that describe entities and a set of columns that hold the attributes of an entity. For example, a Customer table would have columns such as CustomerName and CreditLimit and a row for each […]
Read More

Advanced Indexing and Performance Monitoring Fundamentals

Posted on April 4, 2018
In earlier post about Execution Plans, you have seen that one of the most important decisions that Microsoft SQL Server takes when executing a query, is how to access the data in any of the tables involved in the query and how each step of a query was executed. In this post, you will see […]
Read More

Does Non-Clustered Index (B-Tree) Gets Update Asynchronously?

Posted on March 23, 2018
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 asynchronously and it does not impact INSERT, DELETE and UPDATE transaction performance. Are you shocked? I understand. Prior demonstration of how SQL Server handles Non-Clustered indexes, I would like to […]
Read More

SQL Server Hybrid Data Synchronization (Azure & On-Premise)

Posted on March 19, 2018
As you know, the On-premise & Azure data synchronization feature is just released by Microsoft Azure team as preview version; therefore I want to have a try on this feature to check the limitations and advantages over other traditional techniques and technologies regarding data synchronization. This blog will go through Azure SQL Database synchronization setup […]
Read More

Data Integrity

Posted on
Data integrity refers to maintaining and assuring the accuracy and consistency of data over its entire life-cycle, and is a critical aspect to the design, implementation and usage of any system which stores, processes, or retrieves data. SQL Server enforces data integrity to guarantees the quality of data in the database. It is a critical […]
Read More

How to Deal with Deadlock in SQL Server?

Posted on March 15, 2018
A deadlock is a special blocking scenario in which two sessions get blocked by each other. Each session, while holding its own resources, attempts to access a resource that is locked by the other session. This will lead to a circular blocking scenario, also known as a deadly embrace, as illustrated below. Deadlocks also frequently […]
Read More

SQL Server Database File Deduplication

Posted on February 17, 2018
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. It reduces the impact of redundant data on storage costs. When enabled, Data Deduplication optimizes free space on a volume by examining the data on the volume by looking for […]
Read More

How to Prevent SQLInjection

Posted on
SQL injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing and execution. Any procedure that constructs SQL statements should be reviewed for injection vulnerabilities because SQL Server will execute all syntactically valid queries that it receives. Even parameterized data can […]
Read More

Interaction Between Sets

Posted on February 13, 2018
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 operators: The input sets must have the same number of columns and compatible data type – implicit conversion or explicit conversion. Input sets are the result of a SELECT statements […]
Read More

Grouping and Aggregating Data

Posted on February 12, 2018
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 based on multiple rows. In this post, we will discuss about aggregate functions, GROUP BY, and HAVING clauses. Using Aggregate Functions Microsoft SQL Server provide aggregate functions such as SUM, […]
Read More

SQL Server TSQL Subquery

Posted on January 23, 2018
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 query is the outer query. A subquery can be used anywhere an expression is allowed, as a column expression, in a WHERE clause, in a HAVING clause or even in […]
Read More

Using DML to Modify Data

Posted on January 11, 2018
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 the most important commands of T-SQL is DML. In this post we will learn about DML commands and how to use. Transact-SQL (T-SQL) Data Manipulation Language (DML) is the subset […]
Read More