Managing Microsoft SQL Server: For the "Reluctant" DBA
Are you tasked with managing your company's SQL Server instances just because you're "the Microsoft person" in your environment? Worry not: Self-proclaimed "Jack of All Tech" and MVP Don Jones gives you a crash course in SQL Server administration. Learn how SQL Server works, the right way to make backups, and what replication, high availability, and scalability options are available -- and how to set them up. Learn to make sense of SQL Server's security models, and to properly configure and maintain both security and auditing. Also, learn about SQL Server performance tuning from the administration side, including index tuning and maintenance, query profiling, and more. Learn the bad development habits to watch out for, and how to tune performance for the databases used by your third-party applications. You'll walk away having learned enough to be effective, boosting your resume and giving you more confidence in your SQL Server skills!