Database Recovery

Learn about the Types of Wizards available in the SQL Server Report Builder

In any typical SQL Server implementation, it is important to make sense of the data stored in it. Reports provide us with a handy option to view data as per our requirement and even present it before different stakeholders in a structured manner. Now the MS SQL Server Report builder feature allows you to create reports of various hues using the readily available wizards. Let’s look at them in detail.   Chart Wizard – Representing data in a vivid visual style The chart wizard...

Read more »

Hardware tips for Managing Intense Workload on a SQL Server

The MS SQL Server can be used to tackle intense workloads with clinical efficiency provided the hardware infrastructure is in place. Now if your application needs to service a cross department, large user environment or is a client facing application accessed by thousands, it needs to be run on proper hardware. Let’s look at some of key hardware recommendations that can help jazz up the performance of your SQL Server application.   Consider Adding as Much Memory as Possible Most...

Read more »

A Quick overview of Backup types available in MS SQL Server

The MS SQL Server is without doubt rich in features and it offers several options for backups too. Depending on your specific needs you can choose a backup option that suits you. For example in large organizations where it is necessary to meet strict compliance needs, complete backups may be necessary at quick intervals. In contrast in an independent department store or an educational institute, partial backups taken every week may suffice. Let’s discuss the major backup types in...

Read more »