File Recovery

SQL Server 2014 Introduces Delayed Durability

When it comes to IT systems scalability is a huge buzz words. Everyone wishes to create robust and scalable systems that can be dynamically upgraded, however it is hardly easy to execute in practice. In some cases you need to come up with innovative solutions to deal with tricky issues. Let’s take a corporate application that runs perfectly for most part of day except for certain hours where a higher number of people log-in and update data. During those peak hours transactions take a huge...

Read more »

Microsoft SQL Server Reporting Services – Key Advantages

We today live in a hyper-connected world where information is the key to success for both individuals and businesses. However raw information contained in a data repository can hardly make a clear sense and this where data reporting tools come into the picture. The SQL Server database in its enterprise edition and other iterations comes with a powerful reporting service (SSRS) which helps you gain insights from the data stored in your repository and even allows you the flexibility to mix...

Read more »

Learn How SQL Server Handles Time zones

In the computing world, time zones have a very important place. Imagine a news website where content is published from two different places. If the time zones are not synchronized, the order in which stories may appear may be incorrect. Or you can consider the case of a bid based shopping site which gets accessed from different regions. If time zones are not factored in, some people from a certain location may get the idea that the bid closing time mentioned is their local time and end up...

Read more »