|
Date Published: July 27, 2009
Rating: 4.33
Description: Security in SQL 2005 and beyond includes the concept of securables, allowing the DBA more granularity when assigning permissions. It also means that our old friend sp_helprotect doesn't always return all the information and we need to look to a new resource instead. Presented by MVP Brian Kelley.
|
|
|
Date Published: December 15, 2008
Rating: 4.41
Description: SQL injection is a simple and common attack that can easily be prevented - if you understand how it works. In this video Brian covers what SQL Injection is and how to prevent from your code.
|
|
|
Date Published: December 15, 2008
Rating: 4.46
Description: In this video Brian goes over the different options available for communicating with a SQL Server instance over a network. He then shows you how to enable and disable those options using the SQL Server Configuration Manager. Understanding these settings is important - they rarely change, but when they do, you'll want to know what it all means!
|
|
|
Date Published: December 15, 2008
Rating: 4.41
Description: In this video Brian covers how to use xp_cmdshell in sql server 2005 / 2008.
|
|
|
Date Published: December 15, 2008
Rating: 4.16
Description: Do you know your options for logging in (authenticating) to a SQL Server? Brian discusses the options and in later videos digs deep into the security choices we need to make to correctly secure our SQL Servers.
|
|
|
Date Published: December 15, 2008
Rating: 4.71
Description: In this video Brian covers how to recover from being locked out of a SQL Server 2005 instance where the administrators groups access has been removed.
|
|
|
Date Published: December 15, 2008
Rating: 3.97
Description: Using Windows logins is a great way to leverage the investment in a Windows domain. Did you know that you can add domain users AND domain groups? Watch this short video from MVP Brian Kelley as he walks you through the very common task of setting up a Windows login within SQL Server.
|
|
|
Date Published: December 15, 2008
Rating: 4.28
Description: How do you know if someone is trying to hack into your server? Auditing logins gives you a way to see if attempts are being made, and it's surprisingly easy to configure. SQL security expert Brian Kelley shows you how to set it up.
|
|
|
Date Published: December 15, 2008
Rating: 4.44
Description: In this video Brian takes us through finding blank password for your SQL Server Logins. He shows you how to write a script using the sys.logins views and a what not to do when trying to find blank passwords.
|
|
|
Date Published: December 15, 2008
Rating: 4.13
Description: In this video Brian takes you through creating database roles and reasons to use roles in SQL Server. He also goes over assigning permissions to roles.
|
|