Whitepaper : SQL Server in Simple Words
Introduction:
DBAs can benefit from taking full advantage of the variety of features available in SSMS. In this eBook, you will learn how to:
- Leverage debugging options and shortcuts
- Identify potential problems of locking and blocking
- Set up SQL Server security and permissions
Topics :
Products :
Introduction:
DBAs can benefit from taking full advantage of the variety of features available in SSMS. In this eBook, you will learn how to:
- Leverage debugging options and shortcuts
- Identify potential problems of locking and blocking
- Set up SQL Server security and permissions
Topics :
Products :
Pinal Dave
Pinal Dave is a Developer Evangelist. He has authored 11 SQL Server database books, 14 Pluralsight courses and over 2900 articles on the database technology on his blog at http://blog.sqlauthority.com. Along with 10+ years of hands-on experience, he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ.
Complete SQL performance tuning and recommendations
- Easily monitor and improve the performance of SQL Server, Azure and AWS instances.
- Instantly locate real-time performance issues with Quick Findings.
- Improve performance with updated recommendations for SQL Server 2016 and 2017, Azure SQL Database, and Amazon RDS.
- Generate executable scripts to optimize performance.
- View trends from history of analysis recommendations.