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
It is been long time that I do hardware I/O subsystem pressure test prior to SQL Server installation, based on my experience and observation, not
PowerShell can help you to automate security tasks. Whether you need to monitor repeated failed login attempts by parsing out event logs, or manage roles
One of the most important steps in working with Microsoft SQL Server data management is to understand what execution plans are, why execution plans are
It’s been a while, that I did not write up any blog post. So as the title mentions, I would like to write about Temporary
Fard-Solutions Sdn Bhd understands our clients’ schedules do not allow for prolonged travel to a distant training facility, which is why we created our Training
Top 6 Performance Issues in SQL Server for OLTP Applications. OLTP work loads are characterized by high volumes of similar small transactions. It is important
Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with
Aggregate functions are mostly used in our queries to find out SUM, AVG, COUNT and so on information from stored records for analytical purposes. In
Microsoft introduced In-Memory OLTP technology for SQL Server in version 2014, I would not explain about this technology, you may visit our other blog post
As a service provider, it happens all the time that some companies request our services or in need to have immediate solution for their current problem
Taking SQL Server database backup takes very long time to accomplished on database in production servers. Most DBAs complain about the backup performance, therefore I
If SQL Server Enterprise Edition is Expensive, What about Other Editions!
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