1,062 reputation
1828
bio website sblackler.net
location Bournemouth, United Kingdom
age 25
visits member for 3 years, 4 months
seen 23 hours ago

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).


Dec
8
comment case versus isnull versus coalesce
Thanks for the complete answer so quickly. I had no idea that the order of precedence mattered for COALESCE. Thanks again
Dec
8
accepted case versus isnull versus coalesce
Dec
8
comment case versus isnull versus coalesce
related I agree. but not dup. Thanks for the comment :)
Dec
7
asked case versus isnull versus coalesce
Nov
29
comment When should a primary key be declared non-clustered?
there are only two other answers to read... thanks for your time to answer mind.
Sep
20
awarded  Popular Question
Jul
15
comment Tempdb autogrowth settings
Got that down on my to-do list. Sys-admins are going to love me on Tuesday when im back in the office :D Thanks for the link.
Jul
15
comment Tempdb autogrowth settings
Yes it does, thanks for the insight. :)
Jul
15
comment Tempdb autogrowth settings
Typically in the environments I work in, SQL Server is generally placed on a multi-purpose server. So SBS might be on the box as well so I have to keep these things in mind. I am definitely an accidental dba (developer by trade) and your comments are much appreciated. I will have to come up with sensible defaults for each environment. Thanks
Jul
15
accepted Tempdb autogrowth settings
Jul
15
comment Tempdb autogrowth settings
Thanks for the links. It would be great if that trace flag could be configured for just one database
Jul
15
asked Tempdb autogrowth settings
Jul
11
accepted Safely moving and creating new tempdb files
Jul
11
asked Safely moving and creating new tempdb files
Jul
6
awarded  Yearling
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
May
28
comment Does SQL Server evaluate functions once for every row?
Thanks for the link and explanations :)
May
28
accepted Does SQL Server evaluate functions once for every row?
May
28
asked Does SQL Server evaluate functions once for every row?