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
We have decided to have more than one prize. This time, we’re giving away three prizes for the winners:
- SQL Server Interview Questions and Answers Book – 1 winner
- SQL Wait Stats – 1 winner
- Pluralsight FREE learning code – 5 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)
12 Comments. Leave new
One of the best favorite video among the above is SQL Server Performance: Indexing Basics.
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.
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
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.
My Most favorite is Episode 7 and Least favorite is Episode 04
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 .
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
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.
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.
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.
i like T-SQL Errors and Reactions Demo the most
and i would like to see the video for
truncate data from partition table
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.