Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Weekly Series – Memory Lane – #034

June 22, 2013

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. Let me know which one of the following is your…

SQL SERVER – Storing 64-bit Unsigned Integer Value in Database

June 21, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Datatype

Here is a very interesting question I received in an email just another day. Some questions just are so good that it makes me wonder how come I have not faced it first hand. Anyway here is the question – “Pinal, I am migrating my database from MySQL to SQL…

SQL – Contest to Get The Date – Win USD 50 Amazon Gift Cards and Cool Gift

June 20, 2013

Pinal Dave

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

NuoDB

If you are a regular reader of this blog – you will find no issue at all in resolving this puzzle. This contest is based on my experience with NuoDB. If you are not familiar with NuoDB, here are few pointers for you. Step by Step Guide to Download and…

SQL SERVER – NuoDB in Sixty Seconds – SQL in Sixty Seconds #053

June 19, 2013

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts

Earlier this week, I have done five part blog series on NuoDB and it was very well received by audience. NuoDB is an elastically scalable SQL database that can run on local host, datacenter and cloud-based resources. t is an operational NewSQL database built on a patented emergent architecture with full support for SQL and ACID…

SQL – NuoDB and Third Party Explorer – SQuirreL SQL Client, SQL Workbench/J and DbVisualizer

June 18, 2013

Pinal Dave

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

NuoDB

I recently wrote a four-part series on how I started to learn about and begin my journey with NuoDB. Big Data is indeed a big world and the learning of the Big Data is like spaghetti – no one knows in reality where to start, so I decided to learn…

SQL – Migrate Database from SQL Server to NuoDB – A Quick Tutorial

June 17, 2013

Pinal Dave

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

NuoDB

Data is growing exponentially and every organization with growing data is thinking of next big innovation in the world of Big Data. Big data is a indeed a future for every organization at one point of the time. Just like every other next big thing, big data has its own…

SQL SERVER – Microsoft SQL Server 2014 CTP1 Product Guide

June 16, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

Today in User Group meeting there were lots of questions related to SQL Server 2014. There are plenty of people still using SQL Server 2005 but everybody is curious about what is coming in SQL Server 2014. Microsoft has officially released SQL Server 2014 CTP1 Product Guide. You can easily…