Data Recovery

Using Power View in Ms SQL Server 2012 with SharePoint

Databases today tend to serve as huge repositories of knowledge and they typically incorporate a plethora of business data. Quite expectedly they are managed by skilled administrators and developers who create applications to extract information from them. However for a company executive looking to get a view of certain data present in the database is a complicated affair as it involves making a request to the database team to create a user defined report. However with SQL Server 2012 it is...

Read more »

Quick tips to recover a corrupted SQL Server Database – A Primer

The very thought of a corrupted database can give nightmares to database administrators who are entrusted with the critical task of managing valuable business data. There may be several reasons including firmware compatibility issues that can lead to a SQL server crash. Moreover the application is known to be vulnerable to antivirus scans which may interfere with its workings. Given the chances of data corruption, most SQL server administrators in large organizations tend to keep an adequate...

Read more »

Data Quality Services in SQL Server – A Primer

With the advent of social media, Smartphone and a hyper connected world, we are in throes of an information revolution. A company today tends to receive huge volume of data from which valuable actionable intelligence can be garnered. However even the best Business Intelligence tool will fail to deliver relevant results if the underlying data is vague or error prone. A lot of the data that enters into the SQL database may go unmapped if they do not conform to parameters necessary for BI...

Read more »