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 Clients

Know our Happy Clients

Products

Discover our Products

Latest News and Articles

Find Out Whats Going On

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

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