Pinal Dave - SQL Server Performance Tuning Expert

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

November 4, 2013

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…

Big Data – Final Wrap and What Next – Day 21 of 21

October 29, 2013

Pinal Dave

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

In yesterday’s blog post we explored various resources related to learning Big Data and in this blog post we will wrap up this 21 day series on Big Data. I have been exploring various terms and technology related to Big Data this entire month. It was indeed fun to write about…