Last week, I had my very first SQL in Sixty Seconds Video of this year. Lots of people send me email asking for me to continue this series as it was extremely fun at times to watch the video. I am going to start the series again in the month of June. However, I need your help to decide what would like to see in SQL in Sixty Seconds Videos.
Contest
If you leave a comment to this blog post and if I build a SQL in Sixty Seconds Video on it. I will send you a surprise gift (worth USD 25).
Earlier Videos
Here are few of my previous SQL in Sixty Seconds Video. Please check them out they should give you an idea what I usually cover in Sixty Seconds.
What Makes a Good SQL in Sixty Seconds Topic
This poll is from 2014, so the contest is long over, but the question is still a fun one. A one minute video works best when it answers one clear question, shows one small script, and ends with a result you can see on the screen. A handy function, a quick SSMS shortcut, a common error with its fix, or a small performance trick all fit very well. The goal is that you can try it on your own server before your coffee gets cold.
Big subjects such as a complete backup strategy, high availability or full index design do not fit into a minute. For those, a longer blog post or a course is better, because there is time to explain the reason behind every step. A one minute version would leave out exactly the parts that matter.
If you want to watch the older episodes, search my YouTube channel for the series name, and you will find them. And if you still have an idea for a short video, leave a comment. A real question from a reader is often the best starting point, because I know at least one person needs the answer.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Discover more from SQL Authority with Pinal Dave
Subscribe to get the latest posts sent to your email.
6 Comments. Leave new
Love to see performance tuning not by license software but core parts of sql. And few new features in latest sql.
I’d recommend doing something like a surface level view of what indexes are and how they are used in relational databases. You obviously couldn’t go very deep into data structures in a sort video, but a surface view and practical understanding would be helpful and would address a deficiency I’ve seen in many candidates I’ve interviewed. Thanks for your consistent and high quality content.
Wow. How could anyone apply for a database job without knowing at least in definition what an index is and can be used for? Amazing.
What’s a good way to write a script for SQL Server to run a query every X seconds to output a text or csv file with some data in it?
Thanxxx…As your site contains many solution which help a lot for me and more people like me.
Another idea would be to give a quick overview of replication – what and why you would want to use it. Maybe a quick view of different types and how to set it up.