DBAs often skip Windows security because they are not Windows experts. Brian Kelley explains file, folder and share permissions and why teamwork matters.
SQL SERVER – SSIS Look Up Component – Cache Mode – Notes from the Field #028
Many people ignore the SSIS look up component and pay for it in performance. Tim Mitchell explains how its cache mode settings affect your packages.
Developer’s Life – Attitude and Communication – They Can Cause Problems – Notes from the Field #027
Sometimes there are incidents when our attitude creates confusion in the communication and we end up creating a situation which is absolutely not warranted.
SQL SERVER – Good Value for Page Life Expectancy – Notes from the Field #026
I was once corrected on Page Life Expectancy. Here my friend Tim Radney explains in simple words what a good value for Page Life Expectancy really is.
SQL SERVER – Database File Names and Extentions – Notes from the Field #025
What is in a name? Plenty, when it comes to database file names and extensions. Tim Radney shares a funny story on why naming standards matter.
SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #024
Tools for proactive DBAs: after many AlwaysOn Availability Group projects, John Sterrett hears the same two questions and answers both in this Notes from the Field episode.
SQL SERVER – Finding Jobs Shrinking Database Files – Notes from the Field #023
Many shops have had jobs shrinking database files for years. Tim shares a simple script to find those jobs so you can deal with them.