It’s Friday, and I’m out of town on vacation in historic Williamsburg, VA (if any burglars are reading this, I forgot to feed the 5 rabid Rottweilers that I’m fostering so feel free to stop by and visit them). What does that have to do with upgrades and migrations? Nothing. Just making conversation, but that…
Tag: 5 Tips for Friday
5 Tips for Friday: Transaction Log
For this week’s 5 Tips for Friday, I want to talk about some best practices for the transaction log. The transaction log in SQL Server is a critical component of a database, and it can affect performance and recoverability of the database. It warrants special care and maintenance. Back it up often: The goal with…
5 Tips for Friday: Query Tuning
Time for another 5 Tips for Friday. Truth be told, I almost forgot that it was Friday so this week’s post is coming late int he day. This week’s fast, fun tips are all about tuning queries. Look at current waits, not total waits: I see it asked time and time again in the forums…
5 Tips for Friday: Security
Today I am starting a new series called 5 Tips for Friday. Every Friday, I will post 5 best practice tips for a particular subject. For the inaugural 5 Tips for Friday, I am going to post tips about Security. Don’t use impersonation: Unfortunately, some people think that the recommendation to use Windows authentication means…