Welcome back for part 2 of my SQL Snack Pack on Table Partitioning! If you have not watched the first video, I would highly encourage you to do so.
Category Archives: Videos
I hope you’re hungry for another SQL Snack! In fact, this will be one of a series of snacks (dare I call it a SQL Snack pack?). Table partitioning is a fantastic feature that is easy to learn and can significantly improve your OLTP and Data-warehouse environments. It can be a little intimidating because it is tricky to get started with, but once you get the basics down you’ll realize it’s pretty straight forward and a very useful feature to have. I will be providing the code and outline for each of the SQL Snacks related to table partitioning so that you have a chance to practice on your own. Happy partitioning!
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.
Instant File Initialization (IFI) is an interesting topic with regards to how SQL Server works with storage. It is an easy feature to turn on and can improve the performance of your server; specifically with creation and growth of data files including TempDB rebuilds with SQL Server restarts. There is a slight security risk where a professional data thief could potentially recover bits of data that have not been over written since IFI was turned on, but the chances of that happening are slim. Plus, if they have physical access to the hard drives on your server, you will have bigger problems to fix.
So without further ado here is the next delicious SQL Snack for Instant File Initialization:
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***
Code for demo below.
Read the rest of this entry »
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.