Forrards Blog

Category
130 cents total
Forgot sa password for your SQL Server?

It may happen so that you don`t know the password of sa user for SQL Server you inherited from somebody. Actually it can happen cause of many reasons. We`ll try to resolve this issue now.So here is a step by step guide for resetting forgotten sa password.

Forrards
March 31, 2023
Boost your OLTP database performance with SQL Server 2014 in-memory tables

Today we can already say with certainty that the most striking innovation in the MS SQL 2014 is the In-Memory OLTP. In-Memory OLTP (project Hekaton) functionality was designed to expedite the processing of typical OLTP-operation in SQL Server. As you know, server load can be divided into two classes: data collection and analysis of what is collected. The first class of problems called OLTP (On-Line Transactional Processing). It is characterized by a short updating transaction affecting a relatively small number of tables in the database. The second class of problems called OLAP (On-Line Analytical Processing) and is characterized by massive prolonged reading, covers a large number of tables and collecting of them, as a rule, the maximum entries. In-Memory OLTP - fully transactional technology and supports failover.

Forrards
March 31, 2023
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Subscribe to our blog

                             

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Remote DBA Services: Database Shrinking

It is a well-known fact that sooner or later each business dependent on IT-infrastructure faces with “Low disk memory” problem. There are plenty of ways to clean the disk’s space, using standard OS services. But neither of them can be used for cleaning or shrinking data on SQL Server. The problem can stuck the overall business processes though and lead to unplanned delay and high costs.

Forrards
March 31, 2023
Top 4 Reasons to decide on Remote DBA Services

Before we review what remote DBA services are, let’s clarify the DBA itself. Database administration or shortly DBA aims to maintain functionality, safety and integrity of database management software – Oracle, DB2 and SQL Server in the first hand. Nobody wants to end up with a non-working system with all the data become unavailable or even lost. So the scope of DBA services covers every matter that explicitly or implicitly influences the operation of a DBMS.

Forrards
March 31, 2023

Let's discuss your project or resource request

                       

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Contact Us
To let us help you

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.