Organiser

Chris Webb

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 This event is not available via LiveMeeting
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

Tue, 7 Sep in 4 days
BRACKNELL
Evening Meeting
Wed, 15 Sep in 12 days
LEEDS
Evening Meeting (15 registered)
Thu, 16 Sep in 13 days
MANCHESTER
Evening Meeting (14 registered)
Wed, 22 Sep in 19 days
MAIDSTONE
Evening Meeting
Thu, 23 Sep in 20 days
CARDIFF
Evening Meeting (13 registered)
Thu, 30 Sep in 27 days
YORK
Multi Day Seminar
Thu, 7 Oct in 34 days
EDINBURGH
Evening Meeting (5 registered)
Wed, 27 Oct in 54 days
LEEDS
Evening Meeting (5 registered)
Thu, 28 Oct in 55 days
MANCHESTER
Evening Meeting (12 registered)
Wed, 8 Dec in 96 days
LEEDS
Evening Meeting (4 registered)
Thu, 9 Dec in 97 days
MANCHESTER
Evening Meeting (6 registered)
Wed, 19 Jan in 138 days
LEEDS
Evening Meeting (4 registered)

Past Events RSS

19 Aug 2010
EDINBURGH
Evening Meeting (11 registered)
18 Aug 2010
MAIDSTONE
Evening Meeting
5 Aug 2010
MANCHESTER
Evening Meeting (21 registered)
20 Jul 2010
LEEDS
Evening Meeting
14 Jul 2010
LONDON
Evening Meeting (92 registered)
28 Jun 2010
EDINBURGH
Evening Meeting (14 registered)
24 Jun 2010
CARDIFF
Evening Meeting (16 registered)
23 Jun 2010
READING
Evening Meeting (31 registered)
17 Jun 2010
LONDON
Full Day Seminar
27 May 2010
ONLINE
Online
20 May 2010
LONDON
Evening Meeting (30 registered)
19 May 2010
LONDON
Evening Meeting (38 registered)
7 May 2010
ONLINE
Webcast (14 registered)
21 Apr 2010
READING
Evening Meeting (40 registered)
15 Apr 2010
LONDON
Evening Meeting (11 registered)

Member Chat

Members online:
To post messages you must be signed on - please register or logon.
Stephanie Sullivan Wed 3:34PM
Looking for a lift to sql bits from south wales. Anybody driving up who welcome a reduction in petrol money?
neil_hambly Tue 2:11PM
My next presentation (DAC-PAC) is @ the VBUG Bracknell (7th Sept) http://bit.ly/9ZgObb along with GrumpyDBA (CLR vs TSQL functions) #sqlfaq
allansqlis Sun 9:08PM
Solution to a practical problem when issuing Current Time Increments in StreamInsight http://goo.gl/UhQn #StreamInsight #CEP #sqlfaq
gavinpayneuk Sat 10:02PM
@SQLRich #sqlserver #sqlfaq Using the internal SQL Server encryption tools
sqlrich Sat 9:58PM
@GavinPayneUK Do you mean SQL's internal code or DBA's implementing encryption? #sqlserver #sqlfaq
gavinpayneuk Sat 9:14PM
@mouldie Have they started using SQL's internal encrypt tools or is it still done at the app, o/s or storage level? #sqlserver #sqlfaq
gavinpayneuk Sat 8:40PM
Does anyone bother with encryption actually within SQL Server? #sqlserver #sqlfaq
neil_hambly Sat 9:44AM
Can't stop laughing RT @tonyrogerson: RT @fasel: Mongo DB is web scale :D http://bit.ly/cWY3el #nosql very funny video and so true #sqlfaq
tonyrogerson Sat 9:26AM
RT @fasel: Mongo DB is web scale :D http://bit.ly/cWY3el #nosql very funny video and so true #sqlfaq
bletchleypark Fri 12:00PM
RT @tonyrogerson: I've given up a days pay for the 16th Sept Bletchley Park pledge http://bit.ly/bshbSs, done via paypal #sqlfaq - very worthy cause!
neil_hambly Fri 10:28AM
I have also pledged 1 day RT @tonyrogerson: I've given up a days pay for the 16th Sept Bletchley Park pledge http://bit.ly/bshbSs, #sqlfaq
tonyrogerson Fri 10:10AM
I've given up a days pay for the 16th Sept Bletchley Park pledge http://bit.ly/bshbSs, done via paypal #sqlfaq - very worthy cause!