How do you change fill factor in SQL Server? This SQL in Sixty Seconds video explains what fill factor is, its default of 100, and how to change it.
SQL SERVER – Attach or Detach Database – SQL in Sixty Seconds #068
Many developers still use the deprecated sp_attach_db. In this SQL in Sixty Seconds video, I show the new way to attach or detach database files.
SQL SERVER – Copy Database – SQL in Sixty Seconds #067
Backup and restore or detach and attach are not the only ways. This SQL in Sixty Seconds #067 video shows how to copy the database with the built-in copy feature.
SQL SERVER – Poll – What would you love to see in SQL in Sixty Seconds?
SQL in Sixty Seconds is coming back in June. Tell me what you would love to see, and if I build a video on your idea, you get a surprise gift.
SQL SERVER – Reset SA Password – SQL in Sixty Seconds #066
Forgot the SA password or your DBA just left? This SQL in Sixty Seconds video shows how to reset SA password by logging in with Windows Authentication.
SQL SERVER – How to Install SQL Server 2014 – A 99 Seconds Video
Everyone asks about SQL Server 2014, but few try it due to fear of the unknown. Here is a 99 second video that shows how to install SQL Server 2014.
SQL SERVER – Optimizing Three Important Resources – CPU, Memory and Disk
A true story of a new manager, a frustrated employee and the three resources every DBA watches: CPU, memory and disk, with Spotlight on SQL Server Enterprise.