SQL Video Archives - Page 37 of 38 - SQL Authority with Pinal Dave

SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video

February 8, 2012

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts

SQL Server is an ocean of information. I believe if one starts learning today, after 60 years he/she may still be learning the subject (there are always a few exceptions)! Recently, I published the SQL Server Questions and Answers video tutorial, and since the course came out, I have been…

SQLAuthority News – Interview with Book Authors after 2 Months of Book Released

January 26, 2012

Pinal Dave

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

SQLAuthority Book Review

Community is the most motivating force for me. I have often found situations where I have done more and better things because there was community around me. My latest book SQL Server Interview Questions and Answers is the result of the community’s support and love. Without the wide acceptance of…

SQL SERVER – A Quick Trick about SQL Server CONCAT function

December 20, 2011

Pinal Dave

SQL Video

SQL Function, SQL Scripts, SQL Server, SQLAuthority Book Review

Just a day before I was presenting at Virtual Tech Days and I wanted to demonstrate the current time to audience using SQL Server Management Studio, I ended up a quick error. If any of you ever tried to concat multiple values of different datatype this should not be surprise to you.

SQL SERVER – Video – Performance Improvement in Columnstore Index

November 7, 2011

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQL Video

SQL Index, SQL Scripts

I earlier wrote an article about SQL SERVER – Fundamentals of Columnstore Index and it got very well accepted in community. However, one of the suggestion I keep on receiving for that article is that many of the reader wanted to see columnstore index in the action but they were…

SQLAuthority News – Uncut and Unedited – Interview of Pinal Dave on Book Authoring

September 15, 2011

Pinal Dave

SQL Video

Joes 2 Pros, SQL Wait Stats

I was very happy when books were published and I got a print copy in my hand. In this blog post we will discuss about Book Authoring.

SQL SERVER – Denali CTP3 – Step by Step Installation Video – 200 Seconds

September 12, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

SQL Download

My recent article on SQL SERVER – Download Denali CTP3 and Denali CTP 3 Product Guide has inspired today’s post. After reading this blog post, I received a few emails and few comments on facebook page that if I can post a video guide to Denali CTP3 installation. Finally I create…

SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD

May 19, 2011

Pinal Dave

SQL Video

SQL Scripts, SQL Server, SQL Utility, sqlcmd

Recently I got a call from an old friend I used to call “DJ”. Here is the exact conversation we had about SQLCMD.