"How Do I" Videos for Security

Here you’ll find videos that explore a variety of security questions for developers, including encryption, handling attacks, security best practices, and a lot more. New videos are added regularly, so check back often.

How Do I: Secure SQL Server using SQL Server 2008 Policy Based Management?

SQL Server 2008 introduced a new feature known as Policy Based Management (PBM). This feature allows us to create policies for our SQL server instance. Few important features of Policy Based Management are:

It is similar to group policy feature provided by Windows
We can create SQL Server Policies and deploy these policies across multiple servers
Policies can be scheduled or we can run them on demand
Policy can also rollback the transaction (policy violating transactions) with raising an error

In this video I’ll showcase how we can leverage Policy Based Management to secure our SQL server environment. I’ll introduce you with these basics of PBM and we will see how we can build policies related to SQL server security and assess those policies on our SQL Server instance.

Presented by Gaurav Sharma, Information Security on July, 2009

Length: 8 minutes 56 seconds

Video Downloads
WMV (Zip) | WMV | iPod | MP4 | 3GP | Zune | PSP

Audio Downloads
AAC | WMA | MP2 | MP3 | MP4

Additional Video Series

Previously Featured Videos

Writing Secure Code in ASP.NET (1 hour, 8 minutes, 38 seconds)	The Art of Identifying, Assessing and Mitigating Software Risk (1 hour, 10 minutes, 52 seconds)	Security Innovation video: A Proactive Approach to Building a Successful Security Development Lifecycle (1 hour, 1 minutes, 55 seconds)	Security Innovation Video: Minimizing Software Risk: Reducing your Application's Attack Surface ( 21 minutes, 27 seconds)

Hunting Down Vulnerabilities in your Code: Effective Review Techniques (54 minutes 44 seconds)	Six Key Security Activities for Software Engineering and Development (34 minutes 49 seconds)	How Do I: Use the Web Protection Library a.k.a Anti-XSS Library? (13 minutes 31 seconds)	How Do I: Identify and Fix Configuration Issues with WACA? (9 minutes 55 seconds)

How-Do-I: Sanitize HTML Using Anti-XSS Library 3.1? (6 minutes 24 seconds)	How Do I: Defend Against Truncation-Based SQL Injection Attacks? (Length: 17 minutes 29 second)	How Do I: Change Default Work Items in the SDL Process Template? (Length: 4 minutes 1 second)	How Do I: Use the SDL Process Template Documentation and Reporting? (Length: 5 minutes 17 seconds)

How Do I: Set Up the SDL Process Template? (Length: 9 minutes 4 seconds)	How Do I: Improve My Check-In Process? (Length: 9 minutes 10 seconds)	How Do I: Evaluate my site’s performance with neXpert? (4 Minutes 22 seconds)	How Do I: Use .NET Framework’s Code Access Security? (6 minutes, 34 seconds)

How Do I: Use Smart Encryption Techniques for Cloud Apps (33 minutes, 55 seconds)	How Do I: Export and Import Certificates? (3 minutes 28 seconds)	How Do I: Secure Data Using Symmetric Key Encryption? (19 minutes, 27 seconds)	How Do I: Secure Data Using Asymmetric Key Encryption? (7 minutes 33 seconds)

How Do I: Secure Passwords Using Hashing Algorithms? (9 minutes, 9 seconds)	How Do I: Improve Cryptographic Security by Storing Keys in Containers? (25 minutes, 36 seconds)	How Do I: Add Hashing to Existing Application? (10 minutes 11 seconds)	How Do I: Perform Imperative Security Checks? (8 minutes, 27 seconds)

How Do I: Create a Windows Principal for Role Based Security? (10 minutes, 6 seconds)	How Do I: Create a Generic Principal for Role Based Security? (11 minutes 11 seconds)	How Do I: Add Security to Applications Built with Visual Basic.NET and Visual C#? (32 minutes, 42 seconds)	How Do I: Create a Secure Custom Membership Provider? (19 minutes, 52 seconds)

How Do I: Improve Data Security by Encrypting and Decrypting XML Data Using Asymmetric Keys? (22 minutes 16 seconds)	How Do I: Improve Data Security by Encrypting and Decrypting XML Data Using Symmetric Keys? (19 minutes, 54 seconds)	How Do I: Attach Client Credentials to a Web Service Call For Security? (16 minutes, 17 seconds)	How Do I: Integrate SqlMembership Provider into My Existing Database? (11 minutes 8 seconds)

How Do I: Set up SqlMembership Providers? (9 minutes, 59 seconds)	How Do I: Add Security to Applications by Digitally Signing XAML Documents? (28 minutes, 23 seconds)	How Do I: Digitally Sign Documents with the Signature of a Single Party? (31 minutes 8 seconds)	How Do I: Add Security to Visual Basic and C# Applications with Digital Signatures? (20 minutes, 19 seconds)

How Do I: Add Security to .Net Applications with the ProtectedData Class? (21 minutes, 47 seconds)	How Do I: Add Security to Visual C++ Applications? (26 minutes 28 seconds)	How Do I: Prevent a SQL Injection Attack Over a PHP/MySQL/Linux Platform? (8 minutes, 59 seconds)	How Do I: Use Managed Cards in Windows CardSpace to Increase the Security of My Web Site? (17 minutes, 50 seconds)

How Do I: Prevent a SQL Injection Security Flaw in an ASP.NET Application? (22 minutes 51 seconds)	How Do I: Prevent a Cross Site Request Forgery Security Flaw in an ASP.NET Application? (20 minutes, 7 seconds)	How Do I: Encrypt My Web.Config File? (11 minutes, 55 seconds)	How Do I: Use Discretionary Access Control Lists in Windows? (30 minutes 8 seconds)
How Do I: Apply SDL Requirements practices within Windows Azure? (17 minutes 19 seconds)	How Do I: Perform the requirements phase of the Microsoft SDL? (12 minutes 43 seconds)	How Do I: Apply SDL Design practices within Windows Azure? (29 minutes 24 seconds)	How Do I: Perform the implementation phase of the Microsoft SDL? (37 minutes 15 seconds)
How Do I: Apply SDL Implementation practices within Windows Azure? (33 minutes 19 seconds)	How Do I: Perform the design phase of the Microsoft SDL? (50 minutes 38 seconds)	Code Analysis Tool .NET (CAT.NET) Overview (5 minutes 12 seconds)	How Do I: Apply SDL Release practices within Windows Azure? (8 minutes 15 seconds)
How Do I: Perform the release phase of the Microsoft SDL? (6 minutes 28 seconds)	How Do I: Apply SDL Verification practices within Windows Azure? (18 minutes 55 seconds)	How Do I: Perform the verification phase of the Microsoft SDL? (21 minutes 57 seconds)	Anti-Cross Site Scripting (Anti-XSS) Library Overview (11 minutes 10 seconds)
SDL Regex Fuzzer Overview (6 minutes 53 seconds)	Code Analysis for C/C++ video (10 minutes 6 seconds)	SDL Process Template for Visual Studio Team System Overview (7 minutes 40 seconds)	BinScope Binary Analyzer Overview (6 minutes 26 seconds)
MSF-Agile+SDL Process Template for Visual Studio Team System Overview (6 minutes 42 seconds)	FxCop Overview (5 minutes 49 seconds)	banned.h Header File Overview (4 minutes 28 seconds)	SDL Threat Modeling Tool Overview (10 minutes 45 seconds)
SiteLock ATL Template Overview (5 minutes 29 seconds)	MiniFuzz File Fuzzer Overview (6 minutes 35 seconds)

Advertise Here