Database Solutions

How to Restore Individual Pages in SQL Server

In this article, we look at the concept of restoring pages in SQL Server instead of performing a file recovery. Many times, while using SQL Server databases, you might come across one of the pages in the application that is corrupt. When a page out of the complete database is corrupt, there is no need of restoring the whole database, you can simply restore the corrupted page. For restoring corrupted pages in SQL Server, you can either make use of the SQL Server Management Studio (SSMS), or T...

Read more »

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 »