Friday, June 24, 2016

New age computing could make a difference at Rio 2016 Olympics

Artificial intelligence and machine learning could make the difference where winning margins are just hundredths of a second at Rio 2016.

Already there are reports of Britain’s rowing team and Brazil’s canoeists turning to analytics at Rio with IBM, SAS and GE among companies offering it.
While in Australia the technology is in pilot phase, Microsoft, BizData and The Australian Institute of Sport have taken giant strides in that direction by using machine learning to crunch three years of solid data to predict when an Australian athlete might suffer injuries and illness induced by factors in their body.
Microsoft Australia Director, Cloud & Enterprise Business Group Toby Bowers said machine analysis could make a huge difference in Olympic competition. “The solution that they’ve built with our technology using predictive analytics predicts when an athlete’s going to be injured three days before it happens,” Mr Bowers said.

Thursday, June 23, 2016

Disable Column Store Indexes for One Database

Disabling column store indexes needs to be done time to time. Following query will generate the script. 

SELECT 'ALTER INDEX [' + Name + +'] ON ' + OBJECT_NAME(object_id) + ' DISABLE'
FROM sys.indexes WHERE TYPE_DESC
LIKE '%COLUMNSTORE%'

Output of the query is shown below.

ALTER INDEX [IndFactResellerSalesXL_CCI] ON FactResellerSalesXL_CCI DISABLE
ALTER INDEX [NonClusteredColumnStoreIndex-20160622-204327] ON DimEmployee DISABLE
ALTER INDEX [NonClusteredColumnStoreIndex-20160622-210321] ON FactInternetSales DISABLE

Free ebook: Introducing Microsoft Power BI

Get started quickly with Microsoft Power BI! Experts Alberto Ferrari and Marco Russo will help you bring your data to life, transforming your company’s data into rich visuals for you to collect and organize, allowing you to focus on what matters most to you. Stay in the know, spot trends as they happen, and push your business to new limits.
This free ebook introduces Microsoft Power BI basics through a practical, scenario-based guided tour of the tool, showing you how to build analytical solutions using Power BI. Read the ebook to get an overview of Power BI, or dig deeper and follow along on your PC using the book’s examples.

Download the book from here.

Tuesday, June 21, 2016

Demand for SQL Server Skills in India

India’s Information Technology sector is regarded as the biggest private sector employer, with over 10 million employees across India. Talent assessment platform Youth4work has announced its findings about the top five desired skill sets in the Indian IT sector. ASP.net is the most in-demand skill set in the IT sector followed by SQL Server, PHP, Advance Java and JavaScript.



Here are the salary comparison for SQL Server in India.