Securing and Maintaining Stored Procedures in T-SQL

Securing and Maintaining Stored Procedures in T-SQL | Pluralsight
English | Size: 236.90 MB
Genre: eLearning

Often, security and maintenance are the last thoughts on a developer’s mind. But in today’s data-driven world, keeping data secure is more relevant than ever! If you want to keep data protected and highly available, it’s time to take your understanding of stored procedures in SQL Server to the next level. In this course, Securing and Maintaining Stored Procedures in T-SQL, you’ll learn all about ensuring procedures are secure and performing optimally. First, you’ll explore why developing a security and maintenance strategy is the first step towards progress. Next, you’ll discover why granting the least privileges to a user is often the best course of action. Finally, you’ll learn how to track the performance of stored procedures over time. After measuring performance, you’ll be better equipped to implement tuning techniques. When you’re finished with this course, you’ll have the skills and knowledge required to secure and maintain stored procedure performance needed to ensure your company’s data is protected and highly available.