Imagine this. Your users have developed an Excel spreadsheet that extracts data from your SQL Server database, manipulates that data through the use of Excel formulas and, possibly, some VBA code which is then used to calculate P&L, hedging requirements or even risk numbers. Management comes to you and tells you that they need to get rid of the spreadsheet and that the results of the spreadsheet calculations need to be persisted on the database.
Big Data – Various Learning Resources – How to Start with Big Data? – Day 20 of 21
We learned how to become a Data Scientist for Big Data. In this article we will go over various learning resources related to Big Data.
SQL SERVER – Download FREE PDFs from SQLAuthority.com
Throughout the last seven years, we have created many Free PDFs downloads from SQLAuthority.com and many are very much appreciated by users. I just wanted to list all the downloads which we have created so far in a single place, hence here is the blog post which contains all the PDF downloads which we have created so far.
SQL SERVER – Union, Union All and More – Memory Lane – #051
This is 51th episode of Memory Lane. Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. My favorite blog post is about Union, Union All. Let me know which one of the following is your favorite article from memory lane.
Big Data – Role of Cloud Computing in Big Data – Day 11 of 21
In this post we learned the importance of the NewSQL. In this article we will understand the role of Cloud Computing in Big Data Story
Big Data – Buzz Words: What is MapReduce – Day 7 of 21
In yesterday’s blog post we learned what is Hadoop. In this article we will take a quick look at one of the four most important buzz words which goes around Big Data – MapReduce.
SQL – Business Intelligence: Derive Data or Information?
We all know the value of information in our lives. Whether it’s a personal decision or a business initiated one, people need it. But the question is: who is to make the distinction between data and information? We all come across a whole lot of data daily, that may be significant or not. We filter what’s required and forget about the rest. Information is filtered and distilled data. Filtering and distillation can also alter its actual meaning and natural state. Therefore, in this blog we discover some ways to ensure that we’re using business intelligence derived from the right information for making critical management decisions.