SQLAuthority News – Select the Best SQL in Sixty Seconds Episode – Help us Improve

SQLAuthority News - Select the Best SQL in Sixty Seconds Episode - Help us Improve 60seconds

It has been more than 3 months since we have started experimenting with a new concept in  SQL in Sixty Seconds. Every Wednesday, we putt a fresh new interesting concept out via video. Rick Morelan, Vinod Kumar and myself – the three of us decided to do something new and something exciting. We decided to create a short video which will consider the attention span of the viewer, keep them focused and help them learn something new through our teaching.

We all liked the idea of SQL in Sixty Seconds. As the name suggests, you will not watch content for more than a minute. We did our best to keep the video down to single minute, well, in most of the cases. There are cases when we could not accommodate the content in sixty seconds so the video had to roll for over few more seconds. In the end, we try to come up with an extremely short video which is able to teach some learning on SQL Server. So far we have 10 videos out for the SQL in Sixty Seconds series.

SQL in Sixty Seconds

Here are the details to our SQL in Sixty Seconds series. It has a total of 10 videos and a total cumulative time of around 15 minutes for all the videos.

Link to watch all the Episodes

Episode 01 – Subquery to CTE
Episode 02 – T-SQL Errors and Reactions
Episode 03 – T-SQL Constructs – Declaration and Initialization
Episode 04 – Function: Is Leap Year
Episode 05 – T-SQL Errors and Reactions Demo
Episode 06 – SQL Server Performance: Indexing Basics
Episode 07 – Table Variables and Transactions
Episode 08 – Using MAXDOP 1 for Single Processor Query
Episode 09 – T-SQL Constructs – += and *=
Episode 10 – Installing AdventureWorks Sample Database

We need your help

We seriously need your help by means of rating our videos. All you have to do is to answer these three simple questions:

1. Which is your most favorite SQL in Sixty Seconds Episode? and Why?
2. Which is your least favorite SQL in Sixty Seconds Episode? and Why?
3. What next you would like to see in SQL in Sixty Seconds?

Just leave your answers in comment area.

Selection of Winner

On May 1st, we will go over the complete list. Rick, Vinod and I have also picked our most favorite episode and least favorite episode. You may call it a co-incidence or an accident, but our choice was exactly the same. Yes, three of us have selected the same video for best and least favorite videos. We will select the winner who has exactly the same selection as our selection. In case of a tie, we will look at the third question and as well as your answers to the “Why” follow-up question asked in the first and second questions.

Prizes

SQLAuthority News - Select the Best SQL in Sixty Seconds Episode - Help us Improve j2pwait_s

We have decided to have more than one prize. This time, we’re giving away three prizes for the winners:

If you stay in a country where we cannot ship these books, we will send you the appropriate Pluralsight FREE learning code.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Database
Previous Post
SQL SERVER Cheatsheet – Released for SQL Server 2012 Edition
Next Post
SQL SERVER – Performance Tuning – Part 1 of 2 – Getting Started and Configuration

Related Posts

12 Comments. Leave new

  • One of the best favorite video among the above is SQL Server Performance: Indexing Basics.

    Reply
  • 1. Which is your most favorite SQL in Sixty Seconds Episode? and Why?
    Using MAXDOP 1 for Single Processor Query
    Generally we are using queries without looking at impact on processors, so it would be great for us to see if MAXDOP should be used or not.

    2. Which is your least favorite SQL in Sixty Seconds Episode? and Why?
    T-SQL Constructs – Declaration and Initialization
    Not many users are using sql version below 2005, so I was not interested with this.

    3. What next you would like to see in SQL in Sixty Seconds?
    I would like to focus on how to optimize databases step by step.
    Where we should start? What actions we should perform.
    Also another big question is how to make a fast search in a huge table.
    For example we have a products table with 1 million products..
    What columns should be indexed and how to perform intelligent searching, also paging practices.

    Reply
  • Most favorite SQL in Sixty Seconds Episode is
    Episode 07 – Table Variables and Transactions
    gives the knowledge and advantages about the table vairable

    least favorite SQL in Sixty Seconds Episode is
    Episode 06 – SQL Server Performance: Indexing Basics
    less thing to learn from the video

    Next I would like to see in SQL in Sixty Seconds
    more stuffs like
    Indexing, more functions in 2012 like
    Episode 04 – Function: Is Leap Year
    and Episode 08 – Using MAXDOP 1 for Single Processor Query

    Reply
  • 1. Which is your MOST favorite SQL in Sixty Seconds Episode? and Why?
    My favorite is episode # 7, because it is something I completely ignored, I have read several books on SQL and none had raised me an example as shown in the video. For me it’s an excellent knowledge.
    2. Which is your least favorite SQL in Sixty Seconds Episode? and Why?
    If I had to choose one, would be episode # 10, because a lot of documentation on installing the sample database for the product and in some ways is very easy to do.
    3. What next you would like to see in SQL in Sixty Seconds?
    More Videos involved with the new tools that brings SMS for administrators, developers and business intelligence, would be good also to be made a top of the top 10 features that brings SQL 2012 or something. Pinal Dave Thanks for this blog.

    Reply
  • My Most favorite is Episode 7 and Least favorite is Episode 04

    Reply
  • My favorite is Episode 7 and 8 . Even though i was using both the temp table and variable table i just thought using variable table improves performance.but now i actually know the differance even though it did not afftect my queries.
    Least liked is Episode 10 .

    Reply
  • ChiragSatasiya
    April 19, 2012 7:51 pm

    Hi pinal sir,
    First i would like to thanks for such a usefull information.
    Its really great that someone like you contribute to community and
    help them to improve the knowledge.

    My most favorite Episode is no. 4: Function: Is Leap Year
    Because its something very uniqe and new that i never thought about it.
    And really usefull piece of information in less than two mins.

    My least favorite Episode is no. 03 – T-SQL Constructs – Declaration and Initialization.
    Because its very common that we are use in C#.

    And what i like to see next is more SQL Server 2012 functions and its usage.

    Thank you

    Regard$
    Chirag Satasiya

    Reply
  • I watched all the videos… Its really nice to have such interactive sessions which i can say short but sweet. :). For beginners like me, these are really helpful.

    Most favorite #07
    I personally liked the way difference between Table variable and temp table has been explained.

    Least favorite #06
    I least recommend the video on indexing basics. I feel its title misleads the user. It seems more like an advertisement.

    Next things
    I would want to see new features in SQL 2012. At the same time the comparison between old syntax and new syntax if any. The use of graphical diagrams like that in Video #02 can really help to digest thing very short time.

    Reply
  • For me all so far are my favorites. Why, because as the name; SQL in 60 seconds. You provide a quick simple audio and video example of a small piece of the SQL world.
    It is like my morning cup of coffee, I can come into work and look forward to the email and within a minute I have learned or seen something in SQL.
    In the future: keep it going, I like to see anything and everything you know out there on SQL. The 60 seconds is great – quick. simple. informative.
    KEEP IT GOING.

    Reply
  • Matej Skubic (@matejskubic)
    April 22, 2012 3:11 am

    My favorite is Episode 08 – Using MAXDOP 1 for Single Processor Query

    Least favorite is Episode 10 – Installing AdventureWorks Sample Database

    I’m looking forward for new performance optimization tips and tricks.

    Reply
  • Nirav Gajjar
    May 1, 2012 6:05 pm

    i like T-SQL Errors and Reactions Demo the most
    and i would like to see the video for
    truncate data from partition table

    Reply
  • first of all Thanx for your valuable post.

    1. Most favourable Video is : Episode 06 – SQL Server Performance: Indexing Basics. Because performance is very important thing in database.

    2. Least fourable Video is: Episode 10 – Installing AdventureWorks Sample Database. Because installing is most basic part of database that every body should know before reading some blog on sql server.

    3. Like to see in SQL in Sixty Seconds: Difference between SQL Server 2008 v/s SQL Server 2012.

    Reply

Leave a Reply