SQL Server Database Corruption Prevention
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
Menu
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
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
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
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
In the security terms, Authentication is the operation to verify the user and Authorization is the rights that have been assigned to the user. Securing
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
Taking regular database backup is important and most of DBAs are assigned to perform this task, but making sure the backup is restorable and entire
In most advance and complex databases, developers and DBAs faces double hop security issue, which usually DBAs granting the permissions to resolve the issue but
Gamuda Berhad is an engineering, property and infrastructure company based Malaysia. It is one of the largest Malaysian infrastructure companies and has undertaken various projects,
Speakers During Event Dinesh Nair, Director, Developer Experience and Evangelism, Microsoft Malaysia Marko Hotti, Senior Technical Product Manager for Microsoft SQL Server, Microsoft Corporation Hamid
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
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
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
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