1,037 reputation
1828
bio website sblackler.net
location Bournemouth, United Kingdom
age 25
visits member for 3 years, 2 months
seen Sep 23 at 8:12

I am a self-taught programmer originating from the Isle of Wight. I have approximately 3 years commercial experience in developing LOB applications for a wide range of customers (local companies to FTSE 100). During this time, I have honed my development skills across a wide range of platforms and frameworks including C#, VB.net, T-SQL, Web Services and Android programming.

I am currently training towards my MCSA SQL Server 2012 qualification alongside my degree in Computing from Bournemouth University (Graduating 2013). During my time at Bournemouth University, I have built an extensive knowledge in core networking protocols and architecture including TCP, IP (v4 & v6), DNS, ARP, HTTP, EMAIL (SMTP, POP3 and IMAP), WiMAX (802.16) and WiFi (802.11).


Sep
22
awarded  Nice Question
Aug
18
awarded  Popular Question
Jul
25
accepted Implementing application locks within SQL Server (Distributed Locking Pattern)
Jul
25
awarded  Popular Question
Jul
24
awarded  Custodian
Jul
24
reviewed Approve suggested edit on Implementing application locks within SQL Server (Distributed Locking Pattern)
Jul
24
asked Implementing application locks within SQL Server (Distributed Locking Pattern)
Jul
6
awarded  Yearling
Jul
4
comment Is select * still a big no-no on SQL Server 2012?
At the end of the day pulling back data you don't need is wasteful. /EndOf really.
Jul
3
comment Is select * still a big no-no on SQL Server 2012?
@RobIII In essence it's a select *, i've updated to clarify, thank you. The less you ask SQL Server to do the better for everyone, yes you should consider lazy loading etc, but if you need 1/2 properties why pull back the whole table? Especially if that table contains a large entity such as an image. The correct 'solution' should be tested, measured and evaluated in a development environment.
Jul
3
revised Is select * still a big no-no on SQL Server 2012?
added 12 characters in body
Jul
3
awarded  Nice Question
Jul
2
comment Is select * still a big no-no on SQL Server 2012?
@rotard its not in the table itself, I meant the actual resolved entities. So if I dont need property x which is a 1024 length byte array, then I dont need to retrieve it from the database. Thus, saving memory from RAM. Hope that clears it up.
Jul
2
awarded  Curious
Jul
2
awarded  Nice Answer
Jul
1
comment Is select * still a big no-no on SQL Server 2012?
@rotard I've added a sample for you :)
Jul
1
revised Is select * still a big no-no on SQL Server 2012?
added 244 characters in body
Jun
30
awarded  Teacher
Jun
30
answered Is select * still a big no-no on SQL Server 2012?
Jun
26
awarded  Popular Question