Organiser

Tony Rogerson, SQL Server MVP

my blog |  hire me

SQLBlogCasts

Public Content

Microsoft 2005 KB's

Microsoft 2008 KB's

Evening Meeting on Wed Oct 28, 2009 in Dundee

SQL Injection Attacks and Tips on How to Prevent Them


LiveMeeting Attendee URL Click here to join Meeting
Time Starts (UK time) at 18:00 , Finishes 21:00
Cost Free
Organiser Scottish Developers
Address Queen Mother Building, Dundee University, Nethergate, Dundee, DD1 4HN
Directions to Event
Tags SQL Injection Attack, Security, Best Practices

Wednesday, 28th October 2009 at 19:00 – 21:00
Queen Margaret Building, Dundee University

The Talk

In light of some recent events, such as the man who was convicted of stealing 130 million credit card details through a SQL Injection attack, it is imperative that developers understand what a SQL Injection Attack is, how they are carried out, and most importantly, how to defend your code against attack.

In this talk Colin Mackay will demonstrate a SQL Injection Attack on an application in a controlled environment*. He’ll show you where the vulnerable code lies and what you can do to harden it.

Although this talk uses C# as the application language and Microsoft SQL Server 2008 as the database engine many of the concepts and prevention mechanisms will apply to any application that accesses a database through SQL.

* Demonstrating an attack on a real system without the owner’s consent is a breach of the 1990 Misuse of Computers Act, hence the controlled environment.

The Speaker

Colin Angus Mackay is a Software Developer living in Glasgow. He has been programming since the age of 9 starting with a Sinclair ZX Spectrum. He became a professional software developer in 1994, using a Smalltalk based language called Magik. In 1996 he started using C++ commercially and in 2002 migrated to the emerging language of C#.

Colin has received a number of awards including Code Project MVP (for 5 years) and Microsoft MVP (for 3 years). He is a member of the British Computer Society and a Member of the Institution of Analysts and Programmers. He is currently the chairman of Scottish Developers and has organised the last two Developer Day Scotland conferences (with a third in the works).

You can find out more on his blog.

The Venue

We are meeting in the Queen Mother Building at Dundee University. After the meeting we normally retire to the the bar at Laing’s

The Agenda

18:45 Doors Open
19:00 Welcome
19:10 The Talk (Part 1)
19:55 Break
20:05 The Talk (Part 2)
20:45 Feedback & Prizes
21:00 Repair to the Pub

Registration

Space is limited, to sign up go to http://www.eventbrite.com/event/443957890/sql

Coming Events RSS

Past Events RSS

25 Feb 2010
EDINBURGH
Evening Meeting (19 registered)
25 Feb 2010
CARDIFF
Evening Meeting (16 registered)
20 Jan 2010
DUNDEE
Evening Meeting (7 registered)
17 Dec 2009
MANCHESTER
Evening Meeting (9 registered)
10 Dec 2009
LEEDS
Evening Meeting (9 registered)
26 Nov 2009
EDINBURGH
Evening Meeting (8 registered)
26 Nov 2009
LONDON
Evening Meeting (57 registered)
18 Nov 2009
LONDON
Evening Meeting
11 Nov 2009
READING
Evening Meeting (36 registered)
29 Oct 2009
LONDON
Evening Meeting (42 registered)
28 Oct 2009
DUNDEE
Evening Meeting
15 Oct 2009
MANCHESTER
Evening Meeting (17 registered)
14 Oct 2009
READING
Evening Meeting (33 registered)
8 Oct 2009
CARDIFF
Evening Meeting (18 registered)
8 Oct 2009
EDINBURGH
Evening Meeting (11 registered)

Member Chat

Members online:
To post messages you must be signed on - please register or logon.
Jennifer Stirrup Wed 6:49PM
Is anyone hiring at the moment? Looking for a London-based BI focused role
tonyrogerson Wed 12:46PM
@philcr I'd really like to see Surface with a 2008 R2 demo on it taking full advantage of the kit - that would be cool! #sqlfaq
tonyrogerson Sun 10:14AM
Time for a brew - am reading on the SQL Server Modelling stuff and "M" - don't see where it fits to be honest #sqlfaq
tonyrogerson Fri 8:13PM
@Plip Should have used DAS and disk replication - commodity simple kit always the best approach (usually) #sqlfaq
tonyrogerson Fri 4:52PM
Ashwani Roy and Chris Testa-O'Neill are doing a 30 minute Q&A panel at the 17th March UG even - cool #sqlfaq
tonyrogerson Fri 3:13PM
Posted a blog http://bit.ly/afepEy that describes what Granularity is #sqlfaq
tonyrogerson Fri 12:24PM
7th May 1pm - 1.45pm http://bit.ly/c4UmAP I'm going to do a webcast on Normalisation - vender neutral #sqlfaq
tonyrogerson Fri 12:02PM
Just helped a friend take her first steps in SQL Server #sqlfaq over LiveMeeting; dam "namespace error" on SSRS on the install though :(
tonyrogerson Fri 10:32AM
Thinking about my Denormalisation/RElational Theory talk for SQLBits #sqlfaq; so much to cover - so little time.
mladenprajdic Fri 10:22AM
@tonyrogerson i don't know how useful the #sqlfaq is but there is #sqlhelp that is used and has quite some traffic.
tonyrogerson Fri 10:17AM
Whats the point using DISTINCT (tuples will b unique-I get that), but still keyless - what have you achieved in "relational" terms? #sqlfaq
tonyrogerson Fri 10:09AM
In CJ Date's book SQL and Relational Theory he talks about having DISTINCT on every query - that would be interesting #sqlfaq #infooverload
tonyrogerson Fri 7:39AM
17th March Business Intelligence event is now full - we've over 100 registered now, there is a reserve list in operation #sqlfaq
deepfat Thu 1:26PM
#SQLFAQ London SQL Server BI evening 17th March in Victoria be there and be a cube http://bit.ly/cx1vu4
tonyrogerson Thu 1:09PM
Just emailed the UG, had 4 offers to present and more registrations - the 17th will be a good evening! #sqlfaq BI is popular these days