Database Recovery

What is Simple Recovery Model and When You Should Use it in SQL Server

In this article, we look at a simple recovery model which incidentally does not include log backups. A Full Recovery Model which does not make use of log backups is called a Simple Recovery Model. A Simple Recovery Model forms the most basic recovery model available in SQL Server. All the recovery models that SQL allows the users access to, are based on maintenance of transaction log, the feature in the application that decides how the transactions are logged, is the Recovery Model...

Read more »

3 Critical Security Best Practices Needed for Your SQL Server

In this article, we cover three critical security best practices that one must follow if they are using SQL Server as their primary production database. The security of SQL Server databases is something any organization would seldom take lightly. The databases belonging to an organization are not just a collection of important records, but also form useful assets for the company. If any organization or DBA gets careless regarding the security of databases or database backups, it can result...

Read more »

How to Auto Monitor the Changes of Port Numbers for Multiple SQL Servers

If there is a change in the SQL Server's port number, connections will fail. In order to avoid this, it is a good practice to proactively monitor SQL Server's port number and act on non-compliance. Monitoring SQL Server's port number is important. So in this article, we would be learning to automate it. TCP/IP – A universal method The TCP/IP is a universal network protocol that is used to connect to a SQL server instance. When the port number of SQL Server is changed, application connected...

Read more »