![]() ![]() GUI’s are fine to use as long as you have the understanding of behind the scenes and you know what the GUI isn’t showing you… Installing SQL Server via GUI is totally fine in most cases, unless you are deploying many identical instances (in which case, of course scripting it is better…) I disagree with a several of these, Gerald… It’s all fixable! Spend some time figuring out why you shouldn’t be doing these. How many of these are you doing? The higher your number is, the less of a Senior DBA you are. I’ve done many of these things, but I was either a Junior DBA or an Intermediate DBA. ![]() What would you add to this list? What are the questionable things you’ve seen a Senior DBA doing or not doing? How do you stack up? Not trying to improve your skills – don’t rely on your company to send you to training.Using maintenance plans – I’m okay, though I still dislike them, if you use them for backups or DBCC CHECKDB but not for index maintenance.Not checking for high-value missing indexes periodically.Ignoring job failures and warnings/errors in the Error Log.Manually doing a task over and over again when it can be automated.Not monitoring your systems – you don’t need expensive monitoring tools to monitor your systems!.Updating statistics after the respective index was rebuilt.Thinking you should set MAXDOP to 1 to avoid CXPACKET waits.Thinking that 1 FULL backup and 1 LOG backup per day is sufficient for an RPO goal of anything less than 24 hours.Using Activity Monitor – I might get some flack on that one, but it’s true.Relying on the Database Tuning Advisor to determine which indexes are needed.Not knowing what wait stats are or how to use them.Shrinking databases on a schedule or using auto-shrink.Not checking the databases for corruption.I’ve seen some very questionable things in my career. I’ve encountered some people that have Senior DBA as their job title but don’t really have senior-level experience. In that case though, you know better but choose not to do better. You could be sucking at your job because you hate your job and just don’t care. This isn’t about having a sucky job, this is about you sucking at your job. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |