All Articles - SQL Authority with Pinal Dave

SQL SERVER – Microsoft SQL Server 2014 CTP1 Product Guide

June 16, 2013

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…

SQL SERVER – Weekly Series – Memory Lane – #033

June 15, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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

SQL – Quick Start with Explorer Sections of NuoDB – Query NuoDB Database

June 14, 2013

Pinal Dave

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

NuoDB

This is the third post in the series of the blog posts I am writing about NuoDB. NuoDB is very innovative and easy-to-use product. I can clearly see how one can scale-out NuoDB with so much ease and confidence. In my very first blog post we discussed how we can install…

SQL – Quick Start with Admin Sections of NuoDB – Manage NuoDB Database

June 13, 2013

Pinal Dave

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

NuoDB

In the yesterday’s blog post we have seen that it is extremely easy to install the NuoDB database on your local machine. Now that the application is properly set up, let us explore NuoDB a bit more and get you familiar with the how it works and what the important areas of the…

SQL – Step by Step Guide to Download and Install NuoDB – Getting Started with NuoDB

June 12, 2013

Pinal Dave

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

NuoDB

Let us take a look at the application you own at your business. If you pay attention to the underlying database for that application you will be amazed. Every successful business these days processes way more data than they used to process before. The number of transactions and the amount…

SQL SERVER – Puzzle #1 – Querying Pattern Ranges and Wild Cards

June 11, 2013

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Joes 2 Pros

Note: Read at the end of the blog post how you can get five Joes 2 Pros Book #1 and a surprise gift. I have been blogging for almost 7 years and every other day I receive questions about Querying Pattern Ranges. The most common way to solve the problem…

SQL SERVER – New SQL Server 2012 Functions – Webinar by Rick Morelan

June 10, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros

My friend Rick Morelan is a wonderful speaker and listening to him is very delightful. Rick is one of the speakers who can articulate a very complex subject in very simple words. Rick has attained over 30 Microsoft certifications in applications, networking, databases and .NET development, including MCDBA, MCTS, MCITP, MCAD,…

SQL SERVER – The Story of a Lesser Known Startup Parameter in SQL Server – Guest Post by Balmukund Lakhani

June 10, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

This is a fantastic blog post from my dear friend Balmukund ( blog | twitter | facebook ). He had presented a fantastic session in our last UG and there were lots of requests from attendees that he blogs about it. Well, here is the blog post about the same very popular…

SQL SERVER – 2014 Announced and SQL Server 2014 Datasheet

June 9, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server

Earlier this week Microsoft has announced SQL Server 2014. The release date of Trial of SQL Server to be believed later this year.

SQL SERVER – Coding Standards – Weekly Series – Memory Lane – #032

June 8, 2013

Pinal Dave

SQL

Memory Lane, SQL Coding Standards

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 favorite article from memory lane. Let us learn about Coding Standards in this blog post.