Simple play icon Course
Skills Expanded

Securing and Maintaining Stored Procedures in T-SQL

by Jared Westover

Do you build and maintain stored procedures? Well, this course is for you! Take your skills to the next level by learning all the ins and outs of securing and maintaining stored procedures.

What you'll learn

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.

About the author

Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. When he started his education, he didn’t consider any other field than computers. Jared has been working with technology for over 15 years. He focuses on SQL Server and finding ways to tell inspiring stories with raw data. Technology became his first love while working on a Tandy back in the ’80s. Undertaking an epic quest, Jared wanted nothing more than to design video games using C. Working with data giv... more

Ready to upskill? Get started