Stay Tuned!

Subscribe to our newsletter to get our newest articles instantly!

Apps

Getting Intelligent About Your Business

Prior to Microsoft’s SQL 7, it required a Database Administrator (DBA) to be parked in front of a monitor, watching the system as closely as a prison guard would have to watch jail inmates getting exercise out in the yard. When I began examining MS SQL Server 2012 it was difficult to believe what I was seeing.

A demonstrator working on an everyday laptop worked with an Excel spreadsheet connected to MS SQL Server 2012 with 100 million rows of data. Calculations were spat out in mere seconds. Yet that is not the tricky part. The trick comes from a piece of technology found in Redmond’s newest SQL Server known as PowerPivot. I’ll explain that in a second.

The problem in today’s businesses inverse of the challenges business faced yesterday. Take for example the newspaper industry. A newspaper would have to take educated guesses as to what its readers wanted. Today, with most news being delivered online editors and publishers now have so many metrics of what the readers want they are awash in data.

Bill Gates wanted to usher in the Information Age. He succeeded, all too well. The mountains of data created information overload. The company that has led the charge while inadvertently creating the new problem of information overload has come to the rescue with MS SQL Server 2012 and PowerPivot.

In essence, what they have done is take all the data into a three-dimensional cube-like matrix. Then using PowerPivot as an interface for the user is almost like having Dr. Know. Just tell it what you want to know and answers are delivered, virtually instantly.

There is one more trick they have up their sleeve for MS SQL 2012. People in the IT world complain not only is there so much data, but each huge pile of data is also stuck in its own platform. It’s referred to as data silos. The latest MS SQL can build connectors to all different types of data silos.

I mentioned before how incredibly fast MS SQL 2012 is. If you are a regular reader of the Wall Street Journal you have probably noticed on the bottom of the front page in the lower right-hand corner Oracle runs an ad claiming how they clean IBM’s clock. Yet never once have they ever mentioned Microsoft’s SQL Server 2012. Not many years ago Larry Ellison used to poke fun at MS SQL as a toy. Recently he has had to resort to picking on IBM and not mentioning MS SQL Server 2012.

Looking at the case studies banks are running MS SQL Server 2012 with double-digit terabytes of data. Scaling from a small project all the way up to Big Data Analytics and Predictive Analysis is now not only possible, but it’s also incredibly easy for the average worker. What used to take so long to get an answer for, the question moved by the time the results were back. This made work often frustrating. Now with MS SQL 2012, Business Intelligence got a genie.

Credits

[Note: Pageviews – 4,144 – before migrated from the Dewalist Blog website on 09/08/2020]

Avatar

Valdy

About Author

Valdy founded Dewacorp.com, a helpdesk and IT Services provider that has taken care of over 39,000 customer service requests in the past 15 years - that's nearly 2,600 per year. He also created the growing Dewalist.com - a classified website that has close to 55,000 page views and 6,000 user visits per month with 52,000 yearly published ads and 39,000 active registered users. He blogs for the ever-growing Dewapost.com, a tech blog that gets around 20,000 impressions per month with 700 clicks and 10 average pages first impressions on Google Search. You can reach him on the Contact Us page, social media links below or Dewachat.com.

You may also like

Apps

Automate Repetitive Tasks on Your Computer

[This blog is migrated from our classifieds website on 18 July 2020. Previously, it has 3,759 views.] Pre-Solution There are
Apps

Why does Joomla! 1.5 use UTF-8 encoding?

Well… how about never needing to mess with encoding settings again? Ever needed to display several languages on one page