The ongoing chaos over Government Agency’s snooping has ignited a heated debate on privacy of personal data and its use by government and/or other institutions. It has created a feeling of disapproval and distrust among users. This incident proves to be a lesson for companies that are looking to leverage their business using a data driven approach. According to analysts, the goal of gathering personal information should be to deliver benefits to both the parties – the user as well as the data collector(government or business).
SQL SERVER – Number-Crunching with SQL Server – Exceed the Functionality of Excel
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.






