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

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

Ranking Functions

Posted on January 9, 2018
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 SQL server can be categorized as below: In this blog I want to write about ranking functions. As it mentioned in above table, ranking functions return a ranking value for […]
Read More

SQL Server AlwaysOn Availability Group Performance Internals

Posted on January 3, 2018
One of our customer requested us to showcase the SQL Server 2016/2017 AlwaysOn Availability Group performance increments in Synchronous replica scenarios, then I thought it is a good topic to write a blog post about. I have prepared a SQL Server AlwaysOn Availability Group on two different Virtual Machines (VM) as the following figure with […]
Read More

Sorting and Filtering Data

Posted on December 27, 2017
hi all, hope enjoy the last post about ‘SELECT Queries’, you can also refer to ‘Saeed’s Post’ for further information about Querying Multiple Tables by JOINs. 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 theory, sets of data […]
Read More

Data Types in SQL Server

Posted on December 26, 2017
To write effective queries in T-SQL, you should understand how SQL server stores different types of data. This is especially important if your queries not only retrieve data from tables, but also perform comparisons, manipulate data, and implement other operations. In this blog I want to show you built-in systems data types specifications, similarities and […]
Read More

SQL Server StretchDB

Posted on September 25, 2017
StretchDB is a new feature of SQL Server 2016 to archive/migrate cold data from on-premise to Azure SQL Database. We as consultant put the following values on the StretchDB feature:- The cost of keeping cold data is low on Azure compare to On-Premise environment. Using this feature does not require any changes on TSQL queries […]
Read More

SQL Server Strech Cluster with Windows Server Storage Replica

Posted on November 5, 2016
Windows Server 2016 Storage Replica technology enables synchronous replication of volumes between servers or clusters for disaster recovery. It also enables you to use asynchronous replication to create failover clusters that span two sites, with all nodes staying in sync. Storage Replica supports synchronous and asynchronous replication: Synchronous replication mirrors data within a low-latency network […]
Read More