SQL Tips and Tricks Archives - Page 279 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Be Different – Be Leader – An Interactive Journey – Questions and Answers – Book and Video

February 16, 2012

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

This is a true story. My wife and my daughter were playing in the play area in our resident complex. I was sitting a ways off and was watching them play various games. My daughter likes the slides a lot. Suddenly, one kid started to climb the slide from the…

SQL SERVER – T-SQL Errors and Reactions – SQL in Sixty Seconds #002 – Video

February 15, 2012

Pinal Dave

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

Database, SQL in Sixty Seconds, SQL Scripts

We got tremendous response to our very first video of SQL in Sixty Seconds #001. We talked about how to convert Subquery to CTE very quickly. My co-authors Vinod Kumar and Rick Morelan, we often came across very interesting and useful tips which we believe would be helpful to readers.…

SQL SERVER – Building Interactive Reports in Quick Moments – From CSV to Excel Pivot Table – A Conversation turned to Webinar

February 13, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Utility

“I have text files and I need to create interactive reports for my boss – do you have few minutes of time right now? Let us discuss.” I often get questions from people who are new to technology and struggling to get something done. However, this time it was not…

SQLAuthority News – Business Intelligence features of SQL Server 2012 RC0 – Download Virtual Machine

February 12, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence, SQL Download

I am in front of computer 16+ hours of the day. However, I accept that I am bit lazy when it is about doing installation etc. I always prefer that IT department help me to install my computer and I use it right away. Same feeling I get when I…

SQL SERVER – Solution – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

February 11, 2012

Pinal Dave

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

SQL Scripts

Yesterday was really fun. I asked a simple Brain Teaser and we had excellent conversation on SQLAuthority Page as well SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser. That was an easy puzzle for those who have attended the SQL Server Questions and Answers online course. Here is a quick…

SQL SERVER – INNER JOIN Returning More Records than Exists in Table

February 9, 2012

Pinal Dave

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

SQL Joins, SQL Scripts

I blog and engage with the community because it gives me satisfaction when someone resolves an issue. A few days ago, I blogged about a DBA who began his first day at a new company and could not find out where the installation summary file was. He was very happy…

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

February 8, 2012

Pinal Dave

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…