SQL Server 2008 introduced Policy Based Management feature to ease the managing and monitoring SQL Server instances. The Policy-Based Management feature assists you to monitor
The production environment is SQL Server Active-Passive Failover Cluster, our team managed to migrate SQL Server Reporting Services databases and instances into the current production
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
SQL Server Optimizer is a software to check the specific SQL Server performance measures and on top of the findings it is able to generate TSQL codes for DBAs to review and execute the codes for having better performance.
Allianz General Insurance Company had few physical servers for every individual systems which each server uses SQL Server 2005 & 2008. We introduced by Microsoft Malaysia to Allianz for accomplishing this project and at same time we guided Allianz to purchase suitable SQL Server license for their business.
I tried to explore more regarding SQL Server on Linux operating system, and I found few mysterious stuff which I hope they are interesting to you
SQL Server uses lock mechanism to synchronize data access to prevent corruption for in-memory data (such as buffer pool) and to provides higher level of
SQL Server Health Checker is a software to check the specific SQL Server health. It executes multiple advanced SQL Queries to gather health and statistical
SQL Server 2012 Service Pack 3 – New Features and Bug Fixes.
A stored procedure is a named collection of Transact-SQL statements that is stored on the server within the database itself. A stored procedure could be
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.
I came across to install and configure SQL Server 2016 and found there are many MSSQLSERVER windows users are created in Windows Local Users. Therefore
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
Sometimes we do need to disable AUTO_STATS_UPDATE or AUTO_STATS_UPDATE_ASYNC due to many reasons such as database performance impact in heavy workload environment. Updating statistics based
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