Securing and Maintaining Stored Procedures in T-SQL

Focused View

Jared Westover

2:00:13

12 View

01. Course Overview

01. Course Overview.mp4

01:51

02. Building a Security and Maintenance Strategy

02. Introduction.mp4

02:43

03. Reviewing the Dilemma.mp4

03:21

04. Demo-Creating Our Test Environment.mp4

05:41

05. Securing Stored Procedures.mp4

03:37

06. Demo-Analyzing Security.mp4

02:55

07. Maintaining Performance.mp4

02:57

08. Demo-Enabling Query Store.mp4

02:20

09. Summary.mp4

02:48

03. Granting Permissions

10. Introduction.mp4

02:04

11. Investigating Permissions.mp4

02:24

12. Reviewing Syntax.mp4

02:03

13. Demo-Granting Permissions.mp4

04:33

14. Ownership Chaining.mp4

02:49

15. Demo-Ownership Chaining.mp4

03:55

16. Implementing Database Roles.mp4

02:34

17. Demo-Database Roles.mp4

02:44

18. Summary.mp4

01:56

04. Executing Stored Procedures

19. Introduction.mp4

02:27

20. Examining Impersonation.mp4

02:02

21. Switching Context.mp4

02:26

22. Demo-Impersonation.mp4

04:36

23. Minimizing SQL Injection.mp4

02:51

24. Demo-Minimizing SQL Injection.mp4

04:29

25. Summary.mp4

01:33

05. Encrypting and Signing Stored Procedures

26. Introduction.mp4

02:55

27. Examining Encryption.mp4

03:29

28. Demo-Applying Encryption.mp4

05:06

29. Signing Modules.mp4

03:54

30. Demo-Signing Modules.mp4

05:37

31. Summary.mp4

01:46

06. Maintaining Performance

32. Introduction.mp4

03:26

33. Exploring Dynamic Management Views.mp4

02:56

34. Demo-Dynamic Management Views.mp4

06:18

35. Examining Query Store.mp4

02:47

36. Demo-Query Store.mp4

05:49

37. Course Summary.mp4

02:31

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Jared Westover

Instructor's Courses

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 gives Jared a chance to combine his passions for technology and creativity. Tracking data, whether steps taken or money spent, has become an obsession. He loves spending time with his wonderful wife Amanda and three children in his spare time. Jared enjoys lifting weights, along with a good Netflix binge.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.