Database Recovery

Using the SQL Server 2014 Standard Edition – Remain Prepared to Deal with Contingencies

With the 2014 iteration of its flagship database product, Microsoft seems to have stolen a march over its competitors. Features like AlwaysOn availability groups have literally redefined the way companies looked at achieving high availability and business continuity. Considered as a significant improvement over plain vanilla disk mirroring, this feature seems to have gone down well with both users and analysts. However if you have opted for a SQL Server Standard license, you would remain bereft...

Read more »

The PowerPivot Add In Feature expands the ease with which SQL Data can be analyzed

The Ms Excel application is without doubt the most popular spreadsheet application on the planet and has millions of avid users. Excel is typically used for analyzing data and those who are familiar with the application simply love its easy filtering and sorting features. Now if you have always wanted to read the SQL Server data in an Excel spreadsheet, it is now possible without much hassle with the PowerPivot feature. On the technology front the PowerPivot relies on SQL Server Analysis...

Read more »

Learn How SQL Server 2014 is Primed for Big Data

In today’s world dominated by user generated content and frequent data transactions, there is a need to store and understand an extensive volume of data. Now this data is getting created at every given moment, say when a purchase is made at a departmental store or when you make post on a social networking website. Big data is often used as an umbrella term to refer to large data sets, irrespective of their structure. The 2014 iteration of SQL Server seems to lay a great emphasis in making the...

Read more »