SQL Server Analyzer
SQL Server Analyzer’ to run remotely by client and at the last, client will email us the SSA generated file for further analysis by our expert consultants.
Menu
SQL Server Analyzer’ to run remotely by client and at the last, client will email us the SSA generated file for further analysis by our expert consultants.
Securing SQL Server is not completely done in the instance, there must be secure network environment to reduce or avoid attacks to the server. To
Our consultant successfully conducted FS-2050A SQL Server Performance Tuning Course for IT Executives and DBAs.
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
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
Base on our experience from tuning SQL Server databases for companies , Most of the times we have seen tables are having not less than 8 Non-Clustered
This latest release of SQL Server introduces new features that makes it powerful and robust RDMS for enterprise companies. It is needed to mention that
If Reporting Services were simply a report authoring environment, it would be a good tool. However, Reporting Services has much more to offer beyond just
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
In SQL Server environments, when user wants to retrieve data from multiple tables needs to make join between those tables based on date relationship between
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
Smith & Nephew supports healthcare professionals in more than 100 countries in their daily efforts to improve the lives of their patients. Therefore their Dynamic
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
SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more
Few days ago, I had chat with few SQL Server Database Developers, they asked me how ‘Select Into’ bulk operation works in SQL Server and whether
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