SQL Archives - Page 198 of 519 - SQL Authority with Pinal Dave

Big Data – ClustrixDB – Extreme Scale SQL Database with Real-time Analytics, Releases Software Download – NewSQL

November 6, 2013

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

There are so many things to learn and there is so little time we all have. As we have little time we need to be selective to learn whatever we learn. I believe I know quite a lot of things in SQL but I still do not know what is…

SQL SERVER – Implementing IF … THEN in SQL SERVER with CASE Statements

November 4, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Here is the question I received the other day in email. “I have business logic in my .net code and we use lots of IF … ELSE logic in our code. I want to move the logic to Stored Procedure. How do I convert the logic of the IF…ELSE to…

MYSQL – Detecting Current Version of MySQL Server Installation

November 3, 2013

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

Here is one of the most popular questions which I receive which is related to MySQL installation. The question is how do I know which version of the MySQL I have installed on my server. Here is the simple trick which works all the time. Connect to your MySQL engine…

SQL SERVER – Weekly Series – Memory Lane – #053 – Final Post in Series

November 2, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

It has been a fantastic journey to write memory lane series for an entire year. This series gave me the opportunity to go back and see what I have contributed to this blog throughout the last 7 years. This was indeed fantastic series as this provided me the opportunity to…

SQLAuthority News – 7th Anniversary of Blog – A Personal Note

November 1, 2013

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MySQL

Special Day Today is a very special day – seven years ago I blogged for the very first time. Seven years ago, I didn’t know what I was doing, I didn’t know how to blog, or even what a blog was or what to write. I was working as a…

Big Data – Is Big Data Relevant to me? – Big Data Questionnaires – Guest Post by Vinod Kumar

October 31, 2013

Pinal Dave

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

This guest post is by Vinod Kumar. Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Working on various versions of SQL Server 7.0, Oracle 7.3 and other database technologies – he now works with the Microsoft Technology Center (MTC) as a Technology Architect. Let us…

Big Data – Learning Basics of Big Data in 21 Days – Bookmark

October 30, 2013

Pinal Dave

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

Earlier this month I had a great time to write Bascis of Big Data series. This series received great response and lots of good comments I have received, I am going to follow up this basics series with further in-depth series in near future. Here is the consolidated blog post…