SQL Server Database Recovery

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 »

SQL Server Compact Edition – Overview and Benefits

As the popularity of Smartphones and PDA devices increase with every passing day, companies are looking to build applications that can harness the power of these mobile devices. For example a courier and cargo company may wish to facilitate data interchange with PDA devices carried by their agents on the field with their central server. With SQL Server Compact which runs on mobile devices, it is now possible to run an application with two way data transfer with a central SQL Server. Let’s...

Read more »