This is a special edition for SQL Snacks. It is one (of many hopefully) SQL Snacks that has been recorded with the intention of fulfilling a request by a SQL community member looking to learn more about SQL Server. It is straight forward, very basic, beginner level information about Joins with a few examples.
There are many features/options we sometimes overlook and then wonder later what went wrong. The COPY_ONLY option with backups is one that I felt is important to highlight to SQL Server DBAs. This backup is independent backup that is not part of the regular cycled backups that you perform; hint if you’re not performing regular backups please get up and schedule them NOW! Sorry for yelling 🙂
Using this option when doing backups allows you to take backups that do not interfere with your regularly scheduled backups in order to move them off to a QA, Development, or Staging area where you can test against that database or fix bugs without interrupting your production environment. Many times, I have seen that off-cycle backups are taken which become part of the backup set and then are deleted. This can cause negative consequences when doing restores as I will demonstrate in today’s SQL Snack:
Code is provided below if you would like to test it yourself. Please watch the video in order to understand how to test this yourself:
In December 2013 I presented at a SQL Saturday event in Washington DC. My presentation was about Backup and Recovery Fundamentals which I had done before for the PASS DBA Fundamentals Virtual Chapter. This time around, I decided to add a Tail Log (Active Log) Backup and Recovery demo to enhance my Presentation. The presentation went quite well, and so I’ve decided to put a short video together to demonstrate how to do a Tail Log Backup and Recovery.
***Make sure you change the backup, database, and log file paths to match your configuration***
To snack lovers every where now you can consume SQL Learning the same way, in Snack Size! Introducing the new way to snack with 0 calories intake, a simple solution to your learning cravings and available 24/7 from the click of a button!
Late last year I introduced my YouTube Channel with a short video on Hyper-V followed by a 10 hour series of teaching SQL Server in Arabic. This year, I hope to continue with those projects and in addition to that add to my newest delicious invention, the SQL Snack. The idea of this video series is to provide short videos to teach SQL Server content; and other technologies relevant to SQL Professionals on a daily basis. This allows for people to grab a snack and enjoy a short learning experience instead of having to sit down for a long drawn out lecture. Real snack is optional and not provided by me… sorry!
Below is the SQLSnacks Playlist you can also access it at the top menu by hovering over “Videos” and selecting it.
Please enjoy and please feel free to suggest topics you would like to see in the comments and I will try to do my best to accommodate your requests.