SQL Server Archives - Page 93 of 393 - SQL Authority with Pinal Dave

Big Data – Evolution of Big Data – Day 3 of 21

October 3, 2013

Big Data, SQL, SQL Server, SQL Tips and Tricks

In yesterday’s blog post we answered what is the Big Data. Today we will understand why and how the evolution of Big Data has happened. Though the answer is very simple, I would like to tell it in the form of a history lesson. Data in Flat File In earlier days data was…

Big Data – What is Big Data – 3 Vs of Big Data – Volume, Velocity and Variety – Day 2 of 21

October 2, 2013

Pinal Dave

Big Data, SQL, SQL Server, SQL Tips and Tricks

Data is forever. Think about it – it is indeed true. Are you using any application as it is which was built 10 years ago? Are you using any piece of hardware which was built 10 years ago? The answer is most certainly No. However, if I ask you –…

Big Data – Beginning Big Data – Day 1 of 21

October 1, 2013

Pinal Dave

Big Data, SQL, SQL Server, SQL Tips and Tricks

What is Big Data? I want to learn Big Data. I have no clue where and how to start learning about it. Does Big Data really means data is big? What are the tools and software I need to know to learn Big Data? I often receive questions which I mentioned above.…

Big Data – Beginning Big Data Series Next Month in 21 Parts

September 30, 2013

Pinal Dave

Big Data, SQL, SQL Server

Big Data is the next big thing. There was a time when we used to talk in terms of MB and GB of the data. However, the industry is changing and we are now moving to a conversation where we discuss about data in Petabyte, Exabyte and Zettabyte. It seems…

SQL – Download FREE Book – Data Access for HighlyScalable Solutions: Using SQL, NoSQL, and Polyglot Persistence

September 29, 2013

Pinal Dave

Big Data, SQL, SQL Server, SQL Tips and Tricks

Recently I was preparing for Big Data and I ended up on very interesting read for everybody. This is created by Microsoft and it is indeed a fantastic read as per my opinion. It took me some time to read this entire book but it was worth reading this as…

SQL SERVER – Select Columns from Stored Procedure Resultset

September 26, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

It is fun to go back to basics often. Here is the one classic question: “How to select columns from Stored Procedure Resultset?” Though Stored Procedure has been introduced many years ago, the question about retrieving columns from Stored Procedure is still very popular with beginners. Let us see the…

SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 3

September 24, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Earlier I wrote a blog post SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? and SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 2. In part 2 of the blog post, I wanted to write…