SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite

SQL Injection Explained

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.

Duration:
5 mins 44 secs
Skill Level:
100
Rating:
4.41 out of 5
Publish Date:
December 15, 2008
SQL Injection Explained You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of K. Brian Kelley
Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...

References

There are no downloads or recommended reading links for this video

Comments
Jason Martinez on 1/31/2009
Explained beautifully

SAy Soukamneuth on 5/11/2009
Good job

SAy Soukamneuth on 5/11/2009
good job

Veilinginfo on 5/11/2009
Very basic

Harold Snelgrove on 5/11/2009
Great video- I'll recommend it to my junior team members.

Axel Grude on 5/11/2009
I'd like to see an advanced video about methods of code obfuscation

9F655BCB23 on 5/11/2009
Really wanted to see more ways in which injection can take place and how to prevent them. This was way too basic.

Saravanan on 5/11/2009
Short and Clear. Nice Job. Would like to see advanced videos too.

Mark Fyffe on 5/11/2009
A little basic but probably good for beginners

BJ on 5/11/2009
great video! Iwas able to understnad it and I am not a programmer... :)

Rubens on 5/11/2009
Fantastic video, something I don't know a lot about so this video was very useful to me.

Kenneth Wymore on 5/11/2009
Thank you so much for making this easier to understand.

Paul Swanberg on 5/11/2009
Short and to the point

Steve Harris on 5/11/2009
might want to add additional videos of more complex ways sql injection can occur

Carla Wilson on 5/11/2009
Would have been nice to see an example of validating a string input, as this is more complicated than validating for an integer value.

D151BB6B9F on 5/11/2009
You should have given an example of how to validate varChar data. It's easy to check for an integer, but what's the best way to validate TEXT. Showing a check for certain characters (e.g. ";") or whatever way you'd recommend, would have been worth the extra minute or less on the clip.

Marshall Cole on 5/11/2009
Awesome!!!!!!!!!!!!!!!1

DavidB on 5/11/2009
A great basic overview of SQL injection and how to protect against it.

82796FB536 on 5/11/2009
Input validation is not nessesary if you use command object with parameters. PLEASE DO NOT USE DYNAMIC SQL!!!

Michelle Poolet on 5/11/2009
I really like the entire JumpstartTV concept and content -- I can get a bite of good info with my morning coffee. Thanks!

Stephanie Brown on 5/11/2009
Good basic explanation. Would have been nice to show other injection attacks, since validation on text fields is much more difficult.

Andrew on 5/11/2009
Great and simple way to explain SQL injection

Mark Sopczak on 5/11/2009
Very good.

Patrick on 5/11/2009
This was a great video.

luther smith on 5/11/2009
Very clear, no unnecessary words

John William Shroy on 5/11/2009
Basic with great example; good explanation.

melt on 5/12/2009
nice an trivial way to illustrate the problem

Ahmad Elayyan on 5/12/2009
x

Leonard Peoples on 5/12/2009
Great video. All developers should be aware of this.

Dipak Saha on 5/12/2009
Great demo.

Anitha on 5/13/2009
Very insightful and valuable.

Christine Lewis on 5/13/2009
great simple example of the issue

Stuart Ainsworth on 5/18/2009
The question at the end had almost nothing to do with the content material, other than both talked about SQL Injection. The video discussed security and validation; the question referred specifically to EXEC() and sp_executeSQL, neither of which were mentioned in the video.

BillRoger on 5/20/2009
short but very interesting

David Lundell on 5/27/2009
good intro to sql injection but glosses over the vulnerabilities in stored procs. also the question afterwards didn't come from the video

01EFFB45CF on 5/30/2009
Best explanation of SQL Injection yet. Other examples I've seen are much too wordy and clubmsy. This demo was great.

Juan Lorenzoni on 6/8/2009
Great information.

xakep on 9/13/2009
dh

Jody Dodson on 9/21/2009
Short and sweet with applicable information. Thank you!

sunil on 10/22/2009
cool

JohnG on 10/29/2009
Nice one!

Terry on 11/25/2010
Great quick tutorial on SQL injections... I've looked into this a fair bit as the DBA of my corporation. We have VERY old asp applications that we found to have these types of vulnerabilities (which we have fixed)... All DBA's and developers should be very concerned about this type of attack... thanks again!!!

Jamshid Nouri on 11/25/2010
excellent demo

Travis on 11/25/2010
Way too basic. Just converting input to an integer does not address most input text boxes that allow text input. You have to go deeper and filter against particular characters like ';' that cause SQL Injection in the first place.

azad on 11/25/2010
the narrator can be a bit slow

Larry Beals on 11/25/2010
Checking an integer is simple enough but how would you do a text input? The start of the video discussed text as the most vulnerable but did not address it.

ttony on 11/25/2010
The prime mechanism is parameterised sprocs, not vbscript integer validation! The error message that was received, informed the "injector" of the type of protocol, database and script language used. Thats a good yield for a hacker!

Nilesh on 11/25/2010
nice

Mat on 11/25/2010
great explanation of the problem and solution.

badelal on 11/25/2010
Very good

kalapala baburao on 11/25/2010
ok

Mike on 11/26/2010
wow! Very crafty!

Charlie Bruno on 11/26/2010
Nice presentation... the presenter spoke a bit rapidly though, but informative!

syeed on 11/28/2010
Could have a real web application and see a few different SQL injection use cases

Raymond on 11/28/2010
Great. Thanks.

Robert Wine on 11/29/2010
Great information, keep up the GREAT job.

Tahir A. Syed on 11/29/2010
Marvelous!

Trent on 11/29/2010
very good explanation. Easy to follow. I would like to hear more about this topic maybe how it works with stored procedures.

Leonard Peoples on 11/29/2010
Very helpful

John Kingery on 11/29/2010
Explains the issue very well.

5E39C1CBDC on 11/29/2010
good topic and good explanation,

Neal Ganslaw on 11/30/2010
very good introduction to SQL Injection and security on SQL Server. If would be great to see an example of SQL Injection vulnarabilities using the new EF framework because, let's face it, nothing is 100% bulletproof.

Tina on 11/30/2010
Thank you!

Derek on 11/30/2010
That is pretty neat. I never realized that people actually do this kind of thing.

Don Weigend on 11/30/2010
Very nice example, thank you!

Kenneth Wymore on 12/1/2010
Nice and simple with examples. I like it!

Mark Sopczak on 12/1/2010
Great explaination. Thanks.

Satyabodhi Densmore on 12/15/2010
Could have more suggestions for input validation such as forbidding key words or semicolon in strings.

John on 1/7/2011
It would have been nice to have a few more examples of possible attacks and some other ways to protect from SQL Injection. This was just the basic stuff that probably every script kiddie already knows. For a complete beginner/intro video, this was pretty good.

Wasim on 1/24/2011
nice work!!

Eric on 8/10/2011
Fantastic explanation, thank you. I've read about SQL injection attacks before, and explanations of how they work, but yours was the best.

Ralf Riedel on 10/3/2011
sums it up nicely in 5 mins

James Tyree on 10/3/2011
Very short and concise. I loved it;INSERT INTO PublicAccess VALUES(999);

Shane on 10/3/2011
Thanks for explaining how simple it is to stop SQL injection attacks. It's nice to see the cause, effect and solution all in the same video.

Leonard Peoples on 10/3/2011
Good info. Thanks.

David Hunter on 10/3/2011
I would like to see a follow up with other methods of preventing SQL Inj.

Chris Luttrell on 10/3/2011
Good explanation, examples and presentation.

Cosmin Tornea on 10/3/2011
cool

Azhar on 10/4/2011
Good

Dave on 10/4/2011
Nice example

Dave on 10/4/2011
Nice example

Dave on 10/4/2011
Nice example

Dave on 10/4/2011
Nice example

Dave on 10/4/2011
Nice example

Dave on 10/4/2011
Nice example

jose rodriguez on 10/4/2011
It's simple and good explained. Recommended for those who are just begining in this topic.

Rohan on 10/4/2011
Very simple and basic.I understood very well the whole video. Thanks. --Rohan

crystal.kilgus on 10/4/2011
quick. to the point and informative. Super.

Tom Hamilton on 10/4/2011
Thank you - really need to see this scenario explored more from the industrial strength point of view.

D151BB6B9F on 10/4/2011
He should have shown what to do if you need the data in "text" format- in other words, cfquerryparam. It would have been worth the extra time.

Craig on 10/4/2011
Great instruction Brian!

araivnd on 10/5/2011
Please also provide various OTHER ways in which we can over come sql injection.

Satya Thota on 10/6/2011
very helpful to understand how one can inject code, and how we can take care of

prijeshyyn on 10/10/2011
Nice One!!!

James Young on 10/11/2011
When I had an sql injection on one of my websites that is backed by SQL SERVER database I created a public login that had only look-up rights and then using REPLACE function stripped out all characters that are not 1-9 a-z from the input string. REPLACE functions can be stacked to get rid of just about anything. As with most of these excellent tutorials this give you pointers for further reading.

James Moore on 10/26/2011
Good stuff! Thank you.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions